Position: Data Warehouse Engineer Experience: 5 to 10 Years Location: Riyadh, KSAEmployment Type: 1 year contract
We are looking for an experienced Data Warehouse Developer with strong expertise in ETL development using IBM Data Stage and Informatica, along with solid SQL and data warehousing concepts. The candidate will be responsible for designing, developing, and optimizing ETL pipelines to support enterprise data warehouse and analytics initiatives.
Key Responsibilities Design, develop, and maintain ETL workflows using IBM Data Stage and Informatica. Develop and optimize SQL queries, stored procedures, and database objects for data extraction, transformation, and loading. Implement data integration processes between multiple source systems and the enterprise data warehouse. Perform data mapping, transformation logic development, and data validation. Build and maintain data pipelines to support reporting, analytics, and business intelligence systems. Troubleshoot and resolve data quality, performance, and integration issues. Work closely with business analysts, data architects, and BI teams to understand data requirements. Ensure adherence to data governance, security, and compliance standards. Perform ETL performance tuning and optimization. Document ETL processes, workflows, and technical specifications.
Required Skills Strong experience in IBM Data Stage ETL development. Hands-on experience in Informatica Power Center or Informatica ETL tools. Advanced SQL development and query optimization. Experience with data mapping, transformation rules, and data validation.
Preferred Skills Experience in banking or financial services data environments. Knowledge of data quality frameworks and data governance practices. Familiarity with BI tools such as Tableau, Power BI, or Cognos.