Role: Senior Informatica Developer
Location: Phoenix, AZ
Hybrid – Local candidates only
Schedule: Onsite twice per month
Employment Type :6 months Contract
Job Summary
We are seeking a highly skilled Senior Informatica Developer to support the design, development, enhancement, and maintenance of enterprise ETL and data warehouse solutions. The ideal candidate will have strong expertise in Informatica Intelligent Data Management Cloud (IDMC), SQL development, data modeling, and ETL architecture within an Agile environment.
This role will be responsible for the complete lifecycle management of ETL processes and database systems, ensuring reliable data integration, system availability, and accurate enterprise reporting. The Senior Informatica Developer will collaborate closely with business analysts, architects, developers, and QA teams while also mentoring junior developers and contributing to continuous process improvements.
Key Responsibilities
- Design, develop, maintain, and optimize ETL workflows using Informatica IDMC/Informatica Cloud
- Manage end-to-end ETL processes and support enterprise data integration initiatives
- Develop and maintain scalable data warehouse solutions and dimensional data models
- Collaborate with business, development, and testing teams to deliver accurate and reliable reporting solutions
- Perform testing, troubleshoot defects, and resolve production support issues
- Ensure 24/7 system availability and proactively investigate system performance issues
- Work with REST APIs, Salesforce connectors, SQL connectors, and database integration tools
- Participate in database architecture, ETL architecture, and data warehouse design discussions
- Utilize Azure DevOps for Agile project tracking, deployments, and SDLC activities
- Provide technical leadership and mentorship to junior developers
- Research and recommend improvements to existing ETL processes and data workflows
- Support Agile development practices and participate in sprint planning, stand-ups, and retrospectives
Required Skills & Experience
- Strong experience with Informatica Cloud / Informatica Intelligent Data Management Cloud (IDMC)
- Expertise in ETL development, database architecture, and data warehouse implementation
- Strong SQL development and performance tuning experience
- Experience with dimensional data modeling and data warehouse design concepts
- Hands-on experience with Salesforce connectors and SQL connectors
- Experience developing, maintaining, and testing Informatica workflows
- Knowledge of REST APIs and enterprise system integrations
- Experience with Azure DevOps and Agile SDLC methodologies
- Strong analytical, troubleshooting, and problem-solving skills
- Experience working with BI architecture and enterprise reporting systems
- Familiarity with scripting languages for automation and support tasks
Preferred Qualifications
- Experience supporting enterprise-scale data environments
- Prior experience mentoring junior developers or leading technical initiatives
- Knowledge of cloud-based data integration and modern ETL best practices
Education
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field preferred.