Sr Informatica ETL Developer III

Axiom Software Solutions Limited•Auburn Hills, MI

About The Position

Description · 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 Incudes 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 # 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

Requirements

Minimum of 7+ years overall IT experience
DBMS: Oracle, MYSQL, Cloudera DataLake/SQL experience
Strong experience with Informatica programming across three main products BDM, Power Center and IICS
Skilled in Microsoft Office applications (Visio, Word, Excel, Access)
Experience in both Unix and Windows platforms
Experienced in waterfall, iterative, and agile methodologies

Nice To Haves

Strong Automotive OEM experience a plus
IDQ and ICRT experience is a plus.
Additonal experience a plus: Axon

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
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
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