Senior Informatica Developer

Senior Informatica Developer

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) and Informatica Cloud
Develop and maintain ETL processes, data warehouse solutions, and 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, and database conversion
Workflow testing
Strong SQL development and query optimization experience
Strong understanding of dimensional data modeling, data warehousing concepts, and 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
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.