Job Title: 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).
- Develop and maintain ETL processes.
- Develop and maintain data warehouse solutions.
- Develop and maintain 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, including 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: 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.
- Expertise in ETL architecture and design.
- Proficiency in database architecture, data warehouse design and implementation.
- Salesforce integration experience, including Salesforce connectors, SQL connectors, and database conversion.
- Workflow testing, defect resolution.
- Strong SQL development and query optimization experience.
- Strong understanding of dimensional data modeling, data warehousing concepts, and BI architecture.
- Experience with REST APIs and Agile SDLC methodologies.
- Strong analytical, troubleshooting, and problem-solving skills.
- Experience working in enterprise Agile environments.
Preferred Qualifications
- Experience with Azure DevOps and REST API integrations.
- Experience in Data Modeling and Data Warehouse Design concepts.
- Familiarity with scripting languages and automation processes.
Primary Skills
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