ETL Developer

We have an Immediate Job opportunity for ETL Developer position.

Job Role: ETL Developer

Job Location: Abu Dhabi, UAE

Experience : 6 to 14 Years

Notice Period: Immediate

About Company:

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 15,000+, and has 58 offices in 21 countries within key global markets. For more information on the company, please visit our website or LinkedIn communit

Diversity, Equity, and Inclusion:

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and an affirmative-action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements, and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected.

Job Description:

Design and build Informatica PowerCenter ingestion pipelines for all identified source tables to the Azure Data Lake Bronze zone, supporting both full initial loads and incremental CDC/batch loads.

Implement schema drift detection, metadata capture, parameterization for reusability across environments and table lists, and idempotency/retry logic.

Develop EDS Data Quality checks at ingress (completeness, validity, referential integrity) with alerting dashboards; produce reconciliation reports vs. ETHIX source counts and totals.

Build Silver-zone transformation logic on Cloudera CDP using Spark: CASA variable calculations including window functions, aggregations, date logic, currency normalisation, product hierarchy mapping, customer de-dup, and survivorship rules.

Develop and maintain the CASA Variables Catalog: name, definition, formula, grain, data type, source lineage, DQ rules, and business owner per variable (60+ variables).

Build unit tests for transformation logic and produce reconciliation reports against sample business expected outcomes or legacy/manual calculations.

Design target RDBMS schema (entities, PKs, surrogate keys, indexes, constraints, partitioning strategy) and produce DDL scripts with deployment guides.

Develop Informatica publish jobs (merge/upsert strategies) from Gold zone to centralized RDBMS with performance tuning (batch size, indexing, statistics maintenance).

Integrate ETL pipelines into CI/CD (build, unit test, security scan, deploy, rollback) and support CAB approval process for production deployments.

Required Skills:

3+ years hands-on Informatica PowerCenter (mappings, sessions, workflows, parameter files, CDC connectors); Informatica Cloud (IICS) familiarity a plus.

Solid experience with ADLS Gen2 zone design (Bronze/Silver/Gold Medallion architecture), Azure Purview for lineage/cataloguing, and Azure-based orchestration.

Proven experience with Cloudera CDP, Apache Spark (PySpark or Scala), Hive, and Impala for large-scale data transformation and CASA-type variable computation.

Familiarity with enterprise data quality frameworks; experience implementing DQ rules (completeness, validity, uniqueness, referential integrity) with alerting and dashboards.

Strong SQL skills (Oracle, SQL Server, or PostgreSQL); experience with DDL design, merge strategies, indexing, partitioning, and performance tuning.

Experience with dimensional and relational data modelling; familiarity with SCD, surrogate keys, audit columns, and data lineage documentation.

Experience in financial services data (CASA accounts, transaction data, core banking extracts); understanding of credit scoring variable construction preferred.

Experience with CI/CD pipelines for ETL (build, deploy, rollback); familiarity with Git, JIRA, and change management processes (CAB).

Qualifications:

Bachelor’s or Master’s degree in computer science, Information Systems, or related field

Soft Skills:

Excellent communication and leadership skills.

Strong interpersonal and collaboration skills.

Ability to work under pressure and meet tight deadlines.

Positive attitude and strong work ethic.