ETL Developer
Job Description
TAWANTECH is seeking an experienced ETL/ODS Developer with strong expertise in Informatica to join their team in Al Qurayyat, Saudi Arabia. This role focuses on designing, developing, and maintaining data integration solutions for the organization's operational data store (ODS) and data warehouse environments. The ideal candidate will have at least 2 years of experience with Informatica PowerCenter/IICS and strong SQL skills.
The position involves building robust ETL processes, managing data flows, and ensuring data quality across systems. You'll work closely with data architects, DBAs, and BI teams to deliver comprehensive solutions. Key responsibilities include developing ETL processes, maintaining ODS layers, analyzing data requirements, and providing performance tuning.
This is an excellent opportunity for a data professional who enjoys working with enterprise-level data integration tools and has a strong foundation in data warehouse principles. The role offers exposure to modern data technologies, including cloud platforms like AWS Redshift, Azure Synapse, and Snowflake.
The ideal candidate will have a Bachelor's degree in Computer Science or related field, strong analytical skills, and experience with major database systems. Knowledge of Python or Shell scripting and familiarity with Agile methodologies are considered advantages. This full-time, on-site position provides an opportunity to work with a diverse team and contribute to critical data infrastructure projects.
Responsibilities For ETL Developer
- 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 For ETL Developer
- 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
- Experience with cloud data platforms (AWS Redshift, Azure Synapse, GCP BigQuery, Snowflake) - Nice to have
- Knowledge of Python or Shell scripting for automation - Nice to have
- Exposure to Agile/Scrum environments - Nice to have
- Informatica certification is a plus
Related Jobs
