ETL Lead

Role: Architect, Overall ETL Lead+ delivery

Skill: IDMC (IICS)+ Delivery

Location - Hybrid @ Orlando, FL

**Unfortunately no Visa transfer / c2c available**

****Must have 12+ years of total experience to be considered**

: Key Responsibilities:

• Develop, enhance, and maintain ETL processes using Informatica PowerCenter and Informatica Cloud Data Integration (CDI).
• Lead or contribute to migration efforts from PowerCenter to IDMC/CDI.
• Integrate data across various platforms including Oracle, SQL Server, and Snowflake.
• Leverage REST APIs within IDMC CDI to connect with internal and external applications and systems.
• Collaborate with business and technical teams to understand data requirements and translate them into effective integration solutions.
• Work independently to analyze complex source-to-target mappings and resolve data integration challenges.
• Troubleshoot and optimize data workflows for issue resolution, performance, and scalability in a cloud environment.
• Develop and maintain SQL queries and Unix Shell scripts as part of data workflows and automation.
• Document ETL processes, data flows, and system integrations effectively.

Required Qualifications:

• 8+ years of hands-on experience with Informatica PowerCenter.
• 5+ years of experience with Informatica Cloud Data Integration (CDI).
• Experience with IDMC migration projects is a strong plus.
• Strong understanding of ETL architecture, data modeling concepts, and data warehousing best practices.
• Proficiency in SQL (complex queries, optimization) and Shell scripting.
• Ability to work independently with minimal supervision in a fast-paced environment.
• Excellent problem-solving skills and a proactive attitude toward learning and development.

Preferred Qualifications:

• Experience with Informatica Data Management Cloud Services (IDMC), Data Quality (IDQ), or other IDMC components.
• Exposure to cloud platforms such as AWS, Azure, or GCP.
• Exposure to Python, Snowflake is a plus
• Familiarity with job scheduling tools (e.g., Control-M, Autosys).
• Good communication and interpersonal skills to interact with cross-functional teams.