Sr Informatica ETL Developer

Role: : Sr Informatica ETL Developer Location: Auburn Hills, MI Mandatory skills: Informatica, Oracle, MYSQL, Cloudera DataLake/SQL, BDM, IDQ, IICS Informatica · DBMS: Oracle, MYSQL, Cloudera DataLake/SQL experience ·

• Strong experience with Informatica programming across three main products BDM, Power Center and IICS - IDQ and ICRT experience is a plus. · Skilled in Microsoft Office applications (Visio, Word, Excel, Access) ·
• Experience in both Unix and Windows platforms ·
• Design and develop Informatica workflows to exchange data with the Oracle databases, Salesforce, Data Lake or other operational or warehouse data stores · Be able to create or modify Perl scripts for job control and process flow · Additonal experience a plus: Axon Job Details: · Responsible for detailed design, development/unit testing and support for integration testing · Experienced in both working with QA teams for integration testing as well as being responsible for testing own work (i.e. QA is not always involved in every task - ability to thoroughly test their own code is mandatory) · Produce scalable and flexible, high-quality code that satisfies both the functional and non-functional requirements ·
• Identify technical issues & coordinate the resolution of these issues with technical lead team members · Uses secure development best practices and design patterns ·
• Create or update design and systems documentation for developed or modified services or programs ·
• Create process and data flow diagrams for data movement capture · Cross train team members for full knowledge coverage on team ·
• Analyze and translate business requirements to technical design ·
• Analyze and resolve technical issues ·
• Collaborate/communicate with project team and business users as required ·
• Support functional testing and performance testing · Works with technical delivery lead on project activities ·
• Ensure assigned work is implemented within project schedules Includes all developer skills, plus the following; · Minimum of 7+ years overall IT experience ·
• Strong Automotive OEM experience a plus · Experienced in waterfall, iterative, and agile methodologies