The Senior ETL Developer will design, structure, and develop Informatica data warehouse program logic. This role is responsible for the extraction, transformation, cleansing, and movement of data/metadata, so they can be loaded into data warehouse/data mart/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 re-usability 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
Computer skills: Word, Excel, Lotus Notes, Adobe
Excellent organizational and time management skills
Excellent verbal/written communication skills
Excellent reading and comprehension skills
Excellent analytical skills and attention to detail
Knowledge of state and federal employment laws desired
5+ years of experience as an ETL Developer using Informatica Enterprise Integration Tools (within an EDW): PowerCenter 9.x and PowerExchange 9.x
Experience leading and developing medium to large scale Operational and Decision Support based Data Integration projects including Real-Time and Web service 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
Exposure to data modeling tools like Visio, Embarcadero and Erwin
Master Data Management experience and Metadata Management experience
Experience with Micro strategy
This is a full-time opportunity; Monday-Friday, 8 a.m.-5 p.m.
Stay connected with O'Reilly Careers: Facebook:O'Reilly Auto Parts Careers Twitter:@OReillyCareers LinkedIn:O'Reilly Auto Parts Instagram:O'Reilly_Careers
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, or disability.
O’Reilly Automotive Inc. has provided high-quality auto parts availability and excellent customer service since 1957. Today, as a Fortune 500 company, we are determined to be the leader in the auto parts industry through serving both retail and professional customers. We rely on exceptional team members to support our success and growth every day.