ETL Architect

5 days ago Be among the first 25 applicants Get AI-powered advice on this job and more exclusive features.We are seeking a highly skilled and experienced Lead ETL Architect with deep expertise in Informatica Power Center 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 Power Center 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.Key Responsibilities Serve as the technical lead for all ETL activities including design, development, enhancement, and monitoring of Informatica Power Center workflows.Own and proactively manage daily Power Center 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 Power Center 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 Qualifications8–10+ years of progressive experience in ETL architecture, data integration, and job orchestration, with a primary focus on Informatica Power Center.Hands-on expertise in Power Centre and IDMC (Informatica Cloud) with proven experience in migrating complex Power Center 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.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 Dev Ops practices for ETL automation and cloud data platforms (e.g., Snowflake).Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Dautom by 2x Sign in to set job alerts for “ETL Architect” roles.Senior Solution Architect - Data & Analytics Principal Technical Architect - Big Data Senior Technical Architect - Salesforce Marketing Cloud & Data Cloud Client Success Management Architect - Data, AI, and Security Dubai, Dubai, United Arab Emirates 21 hours ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr