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