Description

You will design, build, and maintain ETL workflows using Informatica Cloud (IDMC) within an Azure DevOps environment. You own the data warehouse architecture, data modeling, and API integrations, ensuring robust data delivery and quality.

This role is hybrid.

Responsibilities

• Develop and maintain IDMC workflows for ETL processes and data management.
• Design dimensional data models and data warehouse structures using SQL and data modeling best practices.
• Integrate Salesforce and other databases using SQL connectors and REST APIs.
• Manage the full SDLC using Agile methodologies and Azure DevOps for CI/CD pipelines.
• Conduct testing, resolve defects, and ensure data warehouse security and reliability.

Required Skills

• 5+ years of experience in ETL data management and database architecture.
• Expertise in Informatica Cloud (IDMC) and data warehousing concepts.
• Strong SQL skills and experience with dimensional data modeling.
• Hands-on experience with Azure DevOps for pipeline management.
• Proficiency in designing and consuming REST APIs.
• Experience with Salesforce connectors and database conversions.
• Strong understanding of SDLC and Agile methodologies.

Key Skills

Education

Bachelor’s degree