O'Reilly Auto Parts · Nov 10th 2020
The Data Acquisition (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 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. • Analyze the performance of current code as well as new code to ensure reasonable performance is met. • Communicate with all levels of staff with regard to technical concepts and design in order to create the best product which meets all of the customer requirements. • Communicate with project teams on problem resolution, design issues, and technical implementations.
Skills/Requirements/knowledge REQUIRED: • 5+ years of experience as an ETL Developer using Informatica Enterprise Integration Tools (within an EDW): o PowerCenter 9.x o 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 DESIRED: • Bachelor’s Degree • Exposure to data modeling tools like Visio, Embarcadero, Erwin • Master Data Management experience and Metadata Management experience • Experience with Microstrategy