Senior Informatica Developer

Senior Informatica Developer

Location: Phoenix, AZ (current residents only)
Work Schedule: Hybrid
Position Type: Contract
We are seeking a Senior Informatica Developer to lead the full lifecycle, management, and optimization of our enterprise ETL processes and database systems. In this role, you will work closely with business, development, and QA teams to facilitate data reporting within established organization standards.
Here's What You Will Do
End-to-end design, development, maintenance, and testing of all IDMC (IICS) workflows, utilizing database conversions and specialized system connectors (Salesforce, SQL Server, etc.).
Leverage strong SQL expertise and an understanding of dimensional data models to design, implement, and maintain a secure enterprise data warehouse.
Develop and consume high performance REST APIs to connect cloud and on-premise systems.
Partner with architects and business analysts to translate requirements into scalable technical specifications.
Provide technical advice, code reviews, and guidance to junior developers on the team to ensure best practices across all development phases.
Work actively in all phases of the Software Development Life Cycle (SDLC) using Agile/Scrum methodologies.
Here's What the Ideal Candidate Has
Hands-on development experience with Informatica Intelligent Data Management Cloud (IDMC / IICS).
Direct experience working with Salesforce data integration and connectors.
Strong SQL experience with the ability to write, tune, and optimize queries.
Proven expertise in ETL data management, database architecture, and data warehouse design and implementation.
Must be local to the Phoenix, AZ metropolitan area to support the hybrid onsite requirement.
Bonus Points Experience working with Azure DevOps for repository management, task tracking, and deployments.
Experience developing and consuming REST APIs for data synchronization.
Strong foundation in Data Modeling, Data Warehouse Design, and Business Intelligence (BI) architecture.
Familiarity with different scripting languages (e.g., Python, Shell, PowerShell) to automate jobs.