Senior Informatica Developer

Position Title:

Senior Informatica Developer
Location: Phoenix — Hybrid (Twice a month onsite)
Contract Duration: 6 Months Contract
Work Arrangement
Hybrid work model
Onsite presence required twice per month
Local Arizona candidates only
Position Summary
The Senior Informatica Developer will be responsible for designing, developing, maintaining, and optimizing enterprise ETL processes and data warehouse solutions using Informatica Intelligent Data Management Cloud (IDMC). The role involves close collaboration with business analysts, developers, architects, and QA teams to ensure reliable data integration, reporting accuracy, and system availability.
The ideal candidate should possess strong expertise in Informatica Cloud technologies, SQL development, Salesforce integrations, data warehousing concepts, and ETL lifecycle management. Experience with Azure DevOps, REST APIs, and Agile SDLC methodologies is highly preferred.
Key Responsibilities
Design, develop, and maintain ETL workflows using Informatica IDMC
Build and support enterprise data integration and data warehouse solutions
Develop, maintain, and test IDMC workflows and mappings
Analyze, troubleshoot, and resolve ETL and database-related issues
Collaborate with business, development, and testing teams to support reporting and analytics requirements
Ensure 24/7 system reliability and data availability
Perform database conversions and integrations using Salesforce and SQL connectors
Create and maintain dimensional data models and data warehouse architectures
Participate in code reviews, testing, deployment, and production support activities
Provide technical leadership and mentorship to junior developers
Work within Agile SDLC processes and participate in sprint ceremonies
Use Azure DevOps for work tracking, deployment coordination, and release management
Research and recommend process improvements and optimization opportunities
Develop and consume REST APIs for system integrations
Required Skills & Qualifications
Mandatory Skills
Strong experience with Informatica Intelligent Data Management Cloud (IDMC)
Hands-on experience with Salesforce integrations
Strong SQL programming and query optimization skills
Experience in ETL architecture and data integration
Data warehouse design and implementation expertise
Knowledge of dimensional data modeling concepts
Experience with ETL testing and defect resolution
Strong analytical and problem-solving abilities
Experience working in Agile SDLC environments
Preferred Skills
Azure DevOps experience
REST API integration experience
Data modeling and data warehouse design concepts
Knowledge of scripting languages
BI architecture understanding
Technical Environment
Informatica IDMC
Salesforce Connectors
SQL Databases
Azure DevOps
REST APIs
ETL/Data Warehouse Technologies
Agile Methodologies
Additional Requirements
Candidates must currently reside locally in Arizona
Resume must clearly mention current location
Must be available for in-person interviews within one week of posting closure
Must be able to start within two weeks of offer
Background check and drug screening through HireRight required