ETL Developer

Al Qurayyat, Al Jawf
Permanent
Full-time

15 days ago
Apply easily

About the RoleWe are seeking an experienced ETL/ODS Developer with strong expertise in Informatica to design, develop, and maintain data integration solutions. The candidate will be responsible for building robust ETL processes, managing data flows, and supporting the organization’s operational data store (ODS) and data warehouse environments.Key Responsibilities

Design, develop, and optimize ETL processes using Informatica PowerCenter / IICS.
Build and maintain ODS layers and data pipelines to support reporting and analytics.
Analyze data requirements, source-to-target mappings, and data transformation rules.
Ensure data quality, integrity, and consistency across systems.
Monitor ETL jobs, troubleshoot issues, and provide performance tuning.
Work closely with data architects, DBAs, and BI teams to deliver end-to-end solutions.
Develop and maintain technical documentation (ETL workflows, mappings, job schedules).

Requirements

Bachelor’s degree in Computer Science, Information Systems, or related field.
Minimum 2 years of hands-on experience in ETL development using Informatica.
Strong SQL skills and experience with Oracle, SQL Server, or PostgreSQL.
Experience with ODS and Data Warehouse design principles.
Knowledge of data modeling, normalization, and schema design.
Familiarity with scheduling tools (Control-M, Autosys, etc.).
Strong analytical and problem-solving skills.

Nice to Have

Experience with cloud data platforms (AWS Redshift, Azure Synapse, GCP BigQuery, Snowflake).
Knowledge of Python or Shell scripting for automation.
Exposure to Agile/Scrum environments.
Informatica certification is a plus.

Tawantech