Lead ETL Architect – Informatica PowerCenter & IDMC

Dicetek LLC


Date: 12 hours ago
City: Dubai
Contract type: Contractor
Job Title: Lead ETL Architect – Informatica PowerCenter & IDMC

Location: Onsite – Dubai, UAE

Experience: 8–10+ Years

Availability: Immediate / Short Notice

Role Overview

We are seeking a highly skilled and experienced Lead ETL Architect with deep expertise in Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC) to lead and manage critical data integration and migration initiatives across the enterprise. This role requires a strategic thinker and hands-on technologist capable of managing end-to-end ETL operations, owning the PowerCenter job landscape, and leading the migration to cloud-based IDMC. The candidate will play a pivotal role in ensuring robust, performant, and scalable data integration across Salesforce, Oracle EBS, and Oracle Fusion platforms.

This is an onsite leadership role in Dubai, ideal for a self-driven professional passionate about data integration, operational excellence, and transformation.

Key Responsibilities

  • Serve as the technical lead for all ETL activities including design, development, enhancement, and monitoring of Informatica PowerCenter workflows.
  • Own and proactively manage daily PowerCenter job executions, reviewing logs, resolving sync failures, and mitigating risk of job failures.
  • Enhance and refactor legacy return jobs to improve reliability, throughput, and performance optimization.
  • Design, lead, and execute the migration of PowerCenter workloads to IDMC Cloud, including architecture definition, process mapping, and validation frameworks.
  • Collaborate with cross-functional teams including application owners, database administrators, and business stakeholders to ensure seamless data flows and alignment with enterprise data strategy.
  • Manage workflow schedulers, job orchestration tools, and dependencies across applications.
  • Drive root cause analysis, implement permanent fixes, and create robust monitoring, alerting, and documentation frameworks.
  • Maintain data integrity, quality, compliance, and audit requirements across integrations and jobs.
  • Provide technical mentoring and guidance to junior developers or ETL support teams when required.

Required Qualifications

  • 8–10+ years of progressive experience in ETL architecture, data integration, and job orchestration, with a primary focus on Informatica PowerCenter.
  • Hands-on expertise in Power Centre and IDMC (Informatica Cloud) with proven experience in migrating complex PowerCenter jobs and frameworks to cloud.
  • Strong understanding of Salesforce, Oracle EBS, and Oracle Fusion data models and integration points.
  • Advanced SQL / PL-SQL skills and deep knowledge of enterprise integration patterns and performance tuning.
  • Experience with workflow scheduling tools (e.g., Control-M, Tidal, Informatica Scheduler) and cloud connectivity strategies.
  • Ability to translate business requirements into scalable and secure integration designs.
  • Excellent analytical and troubleshooting capabilities with a proactive and strategic mindset.
  • Strong communication skills and ability to interface with senior business and technology stakeholders.
  • Willingness to work full-time onsite in Dubai and support mission-critical integration systems.

Preferred Skills

  • Familiarity with data governance, metadata management, and data quality frameworks.
  • Knowledge of API-based integrations, web services (SOAP/REST), and event-driven architectures.
  • Exposure to DevOps practices for ETL automation and cloud data platforms (e.g., Snowflake).

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Private Bank - Client Service Executive, Global South Asia - AVP

Deutsche Bank, Dubai
2 hours ago
Position Overview Details of the Division and Team: Provide fundamental support to the Relationship Manager(s) (RM), Investment Managers (IM) to assist in the day-to-day business activities in all aspects of client servicing and operational support.Act as the primary point of contact for RM and client for all operational requests by liaising with key stakeholders at the Booking Centre (Cross Border...

GIUS Application Specialist Emerging Markets

GE HealthCare, Dubai
14 hours ago
Job Description SummaryThe General Imaging Ultrasound Application specialist will provide regional clinical expertise to ensure our General Imaging Ultrasound solutions are best-in-class across various care areas and specialties. You will collaborate closely with regional sales leaders, segment sales teams, application specialists, and customers to enhance product performance, utilization, and customer experience. Additionally, you will play a key role in executing...

Market Medical Executive

Cigna Healthcare, Dubai
15 hours ago
ABOUT US:Cigna healthcare is a global health service company with roots in the US, serving more than 180 million customers and patients throughout the world. We deliver quality health care through choice, predictability, affordability and through integrated capabilities and connected, personalized solutions that advance whole person health.Cigna’s mission is to help our customers improve their health, well-being and sense of...