Senior Informatica Developer
Access Data Consulting Corporation · Phoenix, AZ · 5 days ago
HybridInformation TechnologyContract
End-to-end responsibilities
- 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
Requirements
- Hands-on development experience with Informatica Intelligent DataManagement 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 for 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