Senior Informatica ETL BDM Developer

We are seeking a Senior Informatica ETL BDM Developer with 7+ years of IT experience, responsible for the detailed design, development, and unit testing of ETL solutions. The candidate must produce scalable and high-quality code while ensuring compliance with functional and non-functional requirements. The role involves working closely with QA teams, leading integration testing, and being accountable for self-testing. The ideal candidate will analyze business requirements, design data flows, and resolve technical issues while collaborating with project teams.

Experience with Informatica BDM, Power Center, IICS, and working with databases like Oracle, MySQL, and Cloudera Data Lake is essential. Automotive OEM experience is a plus.

Key Responsibilities:

• Design, develop, and test ETL workflows using Informatica BDM, Power Center, and IICS.

• Perform integration testing and validate code independently before QA involvement.

• Identify and resolve technical issues in collaboration with technical leads.

• Implement secure development best practices and design patterns.

• Document design, system modifications, and process/data flow diagrams.

• Cross-train team members to ensure full knowledge coverage.

• Analyze business requirements and translate them into technical designs.

• Collaborate with project teams and business users as needed.

• Support functional and performance testing efforts.

• Ensure timely implementation of assigned work within project schedules.

Required Qualifications:

• 7+ years of IT experience with strong expertise in Informatica ETL development.

• Hands-on experience with Informatica BDM, Power Center, and IICS.

• Strong database experience with Oracle, MySQL, and Cloudera Data Lake.

• Proficiency in Microsoft Office applications (Visio, Word, Excel, Access).

• Experience working with both Unix and Windows platforms.

• Ability to design and develop Informatica workflows integrating with Oracle, Salesforce, Data Lake, or other data sources.

• Experience in creating or modifying Perl scripts for job control and process flow.

• Strong understanding of data flow design, process documentation, and best practices.

• Familiarity with software development methodologies, including waterfall, iterative, and agile.

• Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications:

• Experience with Informatica IDQ and ICRT.

• Knowledge of Axon for data governance.

• Exposure to additional ETL tools or cloud-based data integration solutions.