Data Engineer (Informatica & ETL/ELT)
A 6-month onsite contract role in Riyadh designing, building, and tuning ETL/ELT data pipelines with Informatica, expert SQL across relational and analytical databases, and automation via Bash/Python, covering performance tuning, pipeline monitoring, data modeling, and documentation.
- Compensation
- Not disclosed
- Location
- Riyadh, Saudi Arabia
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 5+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 5+ years dedicated experience in data engineering, ETL development, or data integration
- Strong hands-on Informatica (PowerCenter or IICS) experience: mapping design, workflow development, session tuning, parameter files
- Deep understanding of ETL vs ELT, incremental loading, Change Data Capture (CDC), and SCD Types 1, 2, 3
- Expert-level SQL for extraction, manipulation, and query optimization (PostgreSQL, Oracle, SQL Server, Snowflake, or Teradata)
- Data modeling experience: designing target schemas, data marts, Dimensional/Data Vault/Star-Snowflake schemas
- Proficiency in Bash or Python for data processing, job orchestration, and automation
- Experience integrating structured, semi-structured, and unstructured data (JSON, Parquet, CSV, XML, REST APIs)
- Hands-on experience with enterprise schedulers (Automic, Control-M, Airflow) and version control (Git)
- Track record translating complex business rules into reliable, production-grade pipelines
- Familiarity with Agile/Scrum methodologies
Nice to have
- Informatica certifications (e.g., Informatica Certified Professional in PowerCenter or IICS)
- Experience with cloud data platforms (Snowflake, Databricks, BigQuery, AWS Redshift)
- Knowledge of streaming or real-time data pipelines (Kafka, Spark Streaming)
Full description
Data Engineer (Informatica & ETL/ELT)
We are seeking a skilled and detail-oriented Data Engineer to design, build, and optimize robust data pipelines and integration workflows. In this role, you will be responsible for transforming raw data into structured, production-ready assets using Informatica and modern ETL/ELT methodologies. You will collaborate closely with data architects, platform admins, and analytics teams to ensure reliable, high-performance data delivery across the organization.
Location: Riyadh, KSA (Onsite)
Required Date: 25 th October 2026
6 Months Contract
Role Summary
We are seeking a skilled and detail-oriented Data Engineer to design, build, and optimize robust data pipelines and integration workflows. In this role, you will be responsible for transforming raw data into structured, production-ready assets using Informatica and modern ETL/ELT methodologies. You will collaborate closely with data architects, platform admins, and analytics teams to ensure reliable, high-performance data delivery across the organization.
Key Responsibilities
- Data Pipeline Development: Design, build, test, and maintain efficient ETL/ELT data pipelines using Informatica to extract data from varied sources and load into targets.
- Data Transformation & Modeling: Implement complex business logic, transformations, and data quality checks while adhering to scalable data modeling principles (Dimensional, Data Vault, or Star/Snowflake schemas).
- Performance Tuning: Optimize SQL queries, database indexes, and Informatica mappings/workflows to maintain high performance across large volume datasets.
- Pipeline Monitoring & Support: Monitor batch and real-time processing jobs, debug pipeline failures, resolve data discrepancies, and optimize resource usage.
- Data Governance & Documentation: Maintain detailed data lineage, technical specifications, data dictionaries, and source-to-target mapping (STM) documentation.
- Collaboration & Integration: Partner with platform admins for deployment and infrastructure optimization, and work with business analysts to translate business requirements into technical solutions.
Required Technical Skills & Experience
1.1.1Core Technical Stack
- Informatica Expertise: Strong hands‑on experience with Informatica (PowerCenter or IICS - Cloud Data Integration), including mapping design, workflow development, session tuning, and parameter files.