O'Reilly Automotive Stores, Inc Senior ETL Developer in SPRINGFIELD, Missouri

The Senior ETL Developer will design, structure, and develop Informatica data warehouse program logic. The Extract Transform Load (ETL) Developer is responsible for the programs required to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store. In addition, he/she will lead the work of other ETL Developers and work closely with Data Analyst and Data Modelers to develop enterprise data integration solutions that promote reusability and standardization.

Essential Job Functions

  • Design, code, and test major features, as well as work jointly with other team members to provide complex software enhancements for databases

  • Collaborate with functional team and other team leads to create integration solutions

  • Apply generally accepted programming standards and techniques to assure efficient program logic and data manipulation

  • Lead design and review meetings with all appropriate parties

  • Ensure design, structure, and content meet performance guidelines; assist with test planning and testing

  • Develop detailed documentation including functional and technical design documents, test cases, support documentation, migration and installation steps, release notes, mapping documents etc

  • Provide high-level analysis and design reviews to solve conceptual problems and avoid duplication of efforts within the development group

Skills and Qualifications


  • 5+ years of experience as an ETL Developer using Informatica Enterprise Integration Tools (within an EDW): PowerCenter 9.xand PowerExchange 9.x

  • Experience leading and developing medium to large scale Operational and Decision Support based Data Integration projects including Real-Time and Webservice based initiatives

  • Extensive experience with SQL with relational databases (SQL Server, DB2)

  • Experience with relational and dimensional data modeling

  • Experience building and operating a data warehouse

  • Knowledge of Data Profiling and Data Quality concepts and techniques

  • Critical thinker with excellent analytical and problem solving skills

  • Advanced knowledge of industry standards/best practices surrounding all aspects of the Software Development Life Cycle


  • Bachelor's Degree

  • Exposure to data modeling tools like Visio, Embarcadero, Erwin

  • Master Data Management experience and Metadata Management experience

  • Experience with Microstrategy

O'Reilly Auto Parts is an equal opportunity employer. It is the policy of the Company to treat all applicants for employment and all team members in a manner that does not discriminate against them because of their race, religion, color, national origin, sex, sexual orientation, pregnancy, age, military obligation, disability or any other status or characteristic protected by local, state, or federal law.