ETL Developer

ETL Developer – Informatica PowerCenter & IDMC Specialist

Join our dynamic team as an **ETL Developer** and leverage your expertise in **Informatica PowerCenter and IDMC** to architect, develop, and optimize robust data integration pipelines. In this pivotal role, you will play a critical part in transforming raw data into actionable insights, ensuring seamless data flow across our enterprise systems. This opportunity is ideal for a seasoned professional with a proven track record in designing high-performance ETL solutions, driving data quality initiatives, and collaborating with cross-functional teams to deliver scalable data solutions.

As an **ETL Developer**, you will be responsible for leading the development, maintenance, and optimization of complex data integration workflows. Your technical acumen will be instrumental in enhancing data processing efficiency, ensuring data accuracy, and supporting business intelligence initiatives. This role demands a deep understanding of **Informatica’s suite of tools**, advanced SQL, and database optimization techniques, along with the ability to troubleshoot and resolve performance bottlenecks.

Key Responsibilities

Your primary focus will be on:

• Designing and Developing ETL Solutions: Create and maintain high-performance **Informatica mappings, workflows, and sessions** to ensure seamless data transformation and integration. Leverage **Informatica Data Management Cloud (IDMC)** to develop sophisticated data quality and governance frameworks.
• Optimizing Data Pipelines: Implement **performance tuning strategies**, including partitioning, pushdown optimization, and query optimization, to enhance data processing efficiency and reduce execution time.
• Advanced SQL and Database Expertise: Write and optimize complex SQL queries, ensuring data integrity and supporting database schema design for optimal performance.
• Custom Development: Develop **custom transformations and Java-based solutions** to address unique business requirements and integrate third-party systems via APIs and web services.
• Data Quality and Governance: Establish and enforce data quality standards, ensuring compliance with governance policies and maintaining metadata documentation for traceability.
• Collaborative Problem-Solving: Work closely with data analysts, business intelligence teams, and technical stakeholders to diagnose and resolve ETL-related issues, ensuring smooth data workflows.
• Technical Documentation: Document ETL processes, workflows, and troubleshooting steps to facilitate knowledge sharing and onboarding for team members.
• System Maintenance and Upgrades: Support **Informatica upgrades, installations, and maintenance**, ensuring system stability and alignment with evolving business needs.
• User Support and Training: Provide guidance to end-users on new or updated workflows, ensuring adoption and minimizing operational disruptions.

Why This Role Matters

In today’s data-driven landscape, the ability to extract, transform, and load data efficiently is the backbone of informed decision-making. As an **ETL Developer**, you will not only enhance our data infrastructure but also empower our organization to derive meaningful insights from its data assets. Your contributions will directly impact operational efficiency, data accuracy, and strategic business initiatives, making this role a cornerstone of our technology-driven vision.

If you are a **results-driven professional** with **5+ years of experience** in **Informatica PowerCenter and IDMC**, and you are passionate about building scalable, high-performance data solutions, we invite you to take the next step in your career. Join us in shaping the future of data integration at our organization in **Riyadh, Saudi Arabia**.

For more information or to submit your application, please send your updated CV to [email protected].