ETL Informatica Developer

Spectraforce Technologies
United States, Michigan, Auburn Hills
Jan 13, 2025
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