Data Integration Specialist

SSC Egypt

Key Responsibilities:

• Capture and analyze ETL requirements from business and technical stakeholders, and translate them into robust data integration designs.
• Design, develop, and maintain ETL workflows and data pipelines for loading data from diverse source systems into Data Warehouses and Data Marts.
• Ensure data quality, accuracy, and timeliness, while adhering to defined SLAs and performance benchmarks.
• Optimize existing data integration processes for performance, scalability, and resource efficiency.
• Troubleshoot and resolve ETL and data load issues in coordination with other data and infrastructure teams.
• Provide mentorship and guidance to junior developers and contribute to knowledge-sharing across the team.
• Create and maintain comprehensive technical documentation for data integration processes, design decisions, and operational procedures.

Technical Skills & Qualifications:

• Strong working knowledge of enterprise relational databases such as Teradata, Oracle, or IBM DB2.
• Proficiency in two or more ETL tools (e.g., Informatica, IBM DataStage, Oracle Data Integrator (ODI), SAS DI Studio).
• Advanced SQL skills and shell scripting experience for automation and custom logic implementation.
• Solid experience in delivering ETL solutions for large enterprise environments, handling complex transformations and high-volume data.
• Exposure to Hadoop ecosystems and Massively Parallel Processing (MPP) platforms such as Teradata is a plus.
• Hands-on experience with Unix/Linux OS, including scripting and command-line operations.