Senior Informatica Developer – ETL & Data Warehouse Solutions

We are seeking a Senior Informatica Developer to support enterprise data integration, ETL development, and data warehouse initiatives. This role will be responsible for managing the complete lifecycle of ETL processes, maintaining database systems, and supporting high-availability enterprise environments.

The ideal candidate will collaborate closely with business stakeholders, developers, testers, architects, and analysts to deliver scalable data solutions while ensuring accurate reporting, system reliability, and process optimization. The role also provides technical leadership and mentorship to junior developers while supporting enterprise modernization initiatives.

Key Responsibilities

• Design, develop, maintain, and support enterprise ETL solutions and data integration processes.
• Manage the full lifecycle of ETL workflows including development, deployment, monitoring, testing, and optimization.
• Develop, maintain, and support Informatica Intelligent Data Management Cloud (IDMC) workflows and integrations.
• Collaborate with business analysts, architects, developers, and QA teams to support data initiatives and business requirements.
• Design and implement robust data warehouse and dimensional data models.
• Develop integrations utilizing Salesforce connectors, SQL connectors, REST APIs, and enterprise interfaces.
• Conduct ETL testing, troubleshoot issues, resolve defects, and support production environments.
• Maintain high system availability and investigate opportunities for performance improvements.
• Support database conversion, migration, and modernization efforts.
• Mentor junior developers and provide technical guidance and best practices.
• Participate in Agile ceremonies and SDLC activities throughout project execution.

Required Qualifications

• Strong experience with Informatica Intelligent Data Management Cloud (IDMC).
• Experience developing enterprise ETL workflows and data integration solutions.
• Strong SQL development experience.
• Experience integrating with Salesforce environments.
• Expertise in ETL architecture, data warehouse implementation, and database design.
• Experience with dimensional modeling and enterprise reporting solutions.
• Strong analytical and problem-solving skills.
• Experience working within Agile SDLC environments.

Preferred Qualifications

• Experience with Azure DevOps.
• Knowledge of REST APIs and service integrations.
• Experience with Data Modeling and Data Warehouse Design.
• Familiarity with Informatica Cloud technologies.
• Experience with scripting languages and automation frameworks.
• Knowledge of BI architecture and enterprise reporting platforms.