We are seeking a skilled Data Engineer to design, implement, and support data integration solutions for our enterprise data warehouse. This role involves developing robust ETL pipelines, managing PL/SQL procedures, collaborating with business stakeholders, and ensuring the stability and performance of our data infrastructure.
Ready to apply for roles like this?
Unlock the company name and direct application link. Subscribers get instant access to fresh jobs across Dubai, Abu Dhabi and Riyadh, many with visa support.
Unlock employer & apply directly
Key Responsibilities:
- ETL Pipeline Development: Design, build, and optimize ETL pipelines to load data from multiple source systems into the enterprise data warehouse.
- Stored Procedure Management: Create, optimize, and maintain PL/SQL stored procedures to support business needs and improve query performance.
- Informatica Development: Develop, troubleshoot, and optimize Informatica ETL workflows, including large-volume file processing and integrations.
- Ad-Hoc Data Requests: Support the Risk Department (Credit and Market Risk) by designing ETL solutions and delivering datasets as required.
- Collaboration: Work closely with Credit and Market Risk teams to gather requirements, implement changes, and streamline workflows.
- Scripting & Automation: Use Python for automation and file handling; develop and maintain Linux/Unix shell scripts for operational tasks.
- Server Administration: Perform routine server patching and maintenance for both Linux and Windows servers to ensure stability and security.
- Operational Support: Provide 24/7 production support for ETL pipelines, monitoring performance, and resolving issues promptly.
- Documentation: Create and maintain comprehensive documentation for ETL processes, workflows, and system configurations.
Required Skills & Qualifications:
- Strong hands-on experience with Informatica PowerCenter (or similar ETL tools).
- Proficiency in PL/SQL development and performance tuning.
- Solid understanding of data warehouse concepts and data modeling.
- Experience managing large data volumes with performance optimization.
- Proficiency in Python for scripting and data handling.
- Strong knowledge of Linux/Unix environments, including shell scripting and administration.
- Familiarity with Windows and Linux server patching/maintenance.
- Ability to provide 24/7 production support in a mission-critical environment.
- Excellent problem-solving, troubleshooting, and communication skills.
- Experience working with Risk Management (Credit/Market Risk) teams is a plus.
