Are you someone who never rests on their laurels, always strives to go above and beyond, and is committed to keeping your PROMISES? Do you appreciate a company culture that is open, fosters work-life balance, and a dynamic team environment? Then Old Dominion is the home for you. We take pride in being the best in the industry, and from our humble beginnings we know that our People and our Family Spirit are the main ingredient in our secret sauce to success. At Old Dominion we are looking for individuals to join the OD Family that will provide innovative solutions and exceed expectations to keep OD the premier transportation solutions provider.

　　Lead the Data Integration Analysts on a daily basis and provide technical expertise to create and enforce data integration standards. Responsible for building data integration solutions utilizing Oracle Data Integration (ODI) tools, Oracle Enterprise Data Quality (EDQ) tools and defining database reporting schemas. Lead project teams to build data migration solutions that are stable, scalable and follow best practices.

　　Primary Responsibilities

　　Lead the evaluation for ETL and Data Quality solutions actively being developed including performance optimization and high availability

　　Lead the analysis, design, development, and unit testing of ODI and EDQ programs from detailed and high-level specifications and assist with troubleshooting

　　Build low latency end to end solutions using ODI and EDQ for change data capture

　　Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mapping documents

　　Enforce business rules using ODI Constraints and EDQ data quality functions

　　Create database objects, develop database procedures, functions, and triggers to perform complex ETL processes

　　Lead the conversion of Logical Data Models into Physical Data Models

　　Setup Java EE ODI Agents running in a WebLogic server cluster for High Availability

　　Design and build components to assist with automation of common tasks via the ODI SDK

　　Extend the base ODI Knowledge Modules to create customized versions that will be re-usable across the company’s data integration projects

　　Scrub and cleanse source data according to requirements and standards

　　Create both Design and Interface docs in support of data migration projects

　　Collaborate with the Development teams in a multi-user environment to promote code changes into source code control for deployment to INT, QA, Load and Production environments

　　Monitor ETL and data quality jobs and activities

　　Support ODI, EDQ and MDM software packages

　　Interface with Oracle Corporation for technical support

　　Provide guidance and mentoring to less experienced Data Integration Analysts

　　Rotate weekly on-call responsibilities

　　Job Qualifications

　　Education:

　　Bachelor’s Degree in Computer Science or related field or equivalent education and experience Experience:

　　9 years of experience working with ETL, Data Quality and MDM tools

　　Advanced capabilities with ETL and Data Quality Tools in Data Warehouse and MDM environments

　　Solid knowledge of RDBMS systems including Oracle, SQL Server and DB2

　　Solid capabilities with analysis, design, development, and implementation of major database structures

　　Proficient using SQL, SQL Plus and PL/SQL

　　Proficient using data modeling tools

　　Proficient with Oracle Data Integrator (ODI) and Oracle Enterprise Data Quality (EDQ)

　　Knowledge of Oracle RAC on a Super Cluster platform

　　Problem-solving ability and proven ability to work multiple deadlines

　　Demonstrated creativity and intellectual curiosity around problem resolution and solution definition

　　Detail oriented with strong interpersonal skills

　　Excellent verbal and written communication skills

　　Experience with Agile Development methodology preferred

　　Knowledge of WebLogic clustering and load balancing preferred

　　Exposure to iSeries DB2 preferred

　　Familiarity with Embarcadero ER/Studio preferred

　　UNIX experience preferred

　　Working Days:

　　Monday,Tuesday,Wednesday,Thursday,Friday,

　　Working Shift:

　　AM

　　Work Days and Shift are estimates and are subject to change, at any given time, based on job scheduling and/or business levels. Any information listed regarding Days and Shifts shall be considered a guideline of expectations for the specific position at the time of posting.

　　Join the OD Family Today!As a Full Time member of our Family, you and your family are eligible to receive:

　　Health, Dental & Vision Benefits

　　Short Term & Long Term Disability

　　Flex Spending Accounts

　　401(k) Retirement Plan

　　Life Insurance

　　Wellness Program

　　Credit Union access, Vacation & Holiday

　　“Birthday Holiday” who doesn’t love some extra attention on their Birthday?

　　Old Dominion Freight Line, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, and/or gender expression, sexual orientation, age, disability, pregnancy, genetic information, military status, Vietnam Era and/or veteran status, or any other characteristic protected by applicable law(s).

　　Welcome to Old Dominion. If you are looking for a new career with the best LTL (Less-than-Truckload) carrier in the industry you’ve come to the right place. Many companies tout their family atmosphere, but at OD it truly is a reality. We’ve grown from our humble beginnings of a single truck and one route in 1934 started by Earl and Lillian Congdon to a company of over 23,000 employees. At OD we strive daily to keep the family spirit alive and help the world keep promises.