Senior Informatica Developer

Senior Informatica Developer Job Code: AZ 11089 Client: Arizona DES – DTS Location: Phoenix, AZ (Hybrid/Local Only) Duration: 6 Months Contract Position Overview Arizona DES is seeking an experienced Senior Informatica Developer with strong expertise in Informatica Intelligent Data Management Cloud (IDMC), ETL development, Salesforce integrations, and SQL/database development. The ideal candidate will be responsible for designing, developing, testing, and supporting enterprise ETL workflows and data warehouse solutions while collaborating with business analysts, architects, and development teams in Agile environments. This role requires strong analytical, troubleshooting, and data integration expertise along with the ability to mentor junior developers and contribute to enterprise data modernization initiatives.

Key Responsibilities Design, develop, maintain, and optimize ETL workflows using Informatica Intelligent Data Management Cloud (IDMC) Informatica Cloud Develop and maintain ETL processes, data warehouse solutions, and database architecture and integrations. ETL processes Data warehouse solutions Database architecture and integrations Collaborate with business analysts, architects, QA/testing teams, and development teams. Support end-to-end ETL lifecycle management and production support.

Design and implement data modeling solutions, dimensional data models, and data warehouse architectures. Develop and maintain integrations using Salesforce connectors, SQL connectors, and REST APIs. Conduct workflow testing, defect resolution, and troubleshooting activities.

Maintain high system availability and data integrity standards. Participate in Agile SDLC activities including Sprint planning, Development, Testing, and Deployment. Provide technical guidance and mentoring to junior developers.

Support process improvement and enterprise data integration initiatives. Utilize Azure DevOps for work tracking, deployment coordination, and SDLC activities. Required Skills & Experience Strong hands‑on experience with Informatica Intelligent Data Management Cloud (IDMC) and Informatica Cloud.

ETL architecture and design. Database architecture, data warehouse design and implementation. Strong Salesforce integration experience including Salesforce connectors, SQL connectors, database conversion, workflow testing.

Strong SQL development and query optimization experience. Strong understanding of dimensional data modeling, data warehousing concepts, BI architecture. Experience with REST APIs, Agile SDLC methodologies, testing and defect resolution.

Strong analytical, troubleshooting, and problem‑solving skills. Experience working in enterprise Agile environments. Preferred Qualifications Experience with Azure DevOps.

REST API integrations. Data modeling and data warehouse design concepts. Familiarity with scripting languages and automation processes.

Primary Skills Informatica IDMC ETL SQL Salesforce Azure DevOps REST APIs Data Modeling Data Warehousing Agile Database Architecture Salesforce Connectors BI Architecture Flexible work from home options available. #J-18808-Ljbffr