Role: ETL Informatica Developer Location: Auburn Hills, MI 48326 (3 days onsite per week) Duration: 11 Months Duties and Responsibilities: - 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
Education and Years of Experience: 7+ years in overall IT experience
Required and Desired Skills/Certifications: - 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
- Additional experience a plus: Axon