ETL Lead- IDMC; IICS

Please note, this role is not able to offer visa transfer or sponsorship now or in the future.

As an Architect and Overall ETL Lead, you will make an impact by driving the design, development, and migration of enterprise‑scale ETL and data integration solutions using Informatica IDMC (IICS). You will be a valued member of the Data Engineering team and work collaboratively with business stakeholders, technical architects, and cross‑functional delivery teams.

• Develop, enhance, and maintain ETL processes using Informatica Power Center and Informatica Cloud Data Integration (CDI).
• Lead migration efforts from Power Center to IDMC/CDI and integrate data across Oracle, SQL Server, and Snowflake platforms.
• Leverage REST APIs within IDMC CDI to connect with internal and external applications and systems.
• Collaborate with business and technical teams to translate data requirements into effective integration solutions.
• Troubleshoot and optimize data workflows for performance and scalability, and document ETL processes, data flows, and system integrations effectively.

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position requiring 3 days a week in Orlando, FL. The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements.

Rest assured; we will always be clear about role expectations.

• 8+ years of hands‑on experience with Informatica Power Center.
• 5+ years of experience with Informatica Cloud Data Integration (CDI).
• Strong understanding of ETL architecture, data modeling concepts, and data warehousing best practices.
• Proficiency in SQL (complex queries, optimization) and Unix Shell scripting.
• Ability to work independently with minimal supervision in a fast‑paced environment, with excellent problem‑solving skills.

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

We’re excited to meet people who share our mission and can make an impact in a variety of ways. Don’t hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.