On-siteMidData Engineerposted 1mo ago

✦Role summaryAI-generated

Mid-level Data Engineer role focused on designing real-time data pipelines (Oracle GoldenGate, SQL Server) and optimizing high-throughput ETL/CDC workflows for enterprise systems in a fast-paced IT services environment.

Skills required

Oracle goldengate Sql server integration Etl pipeline engineering Data replication Batch processing Cdc change data capture Data integration tools High throughput data processing Data synchronization Enterprise data systems Software engineering Data infrastructure SQL ETL Data modeling Snowflake Data governance Data quality

About this role

Valleysoft is an IT services provider delivering enterprise technology, software development, process management, and IT support solutions to clients around the world. Working across complex business environments, the company helps organizations build dependable systems, improve operational efficiency, and get more value from their technology investments.

This Data Engineer role is a chance to contribute to data infrastructure that supports reliable movement, integration, and performance across critical enterprise systems. You will play an important part in shaping how data is synchronized, structured, and maintained to support both operational and analytical needs in a fast-paced technology services environment.

Responsibilities

Data Integration Batch & CDC: Design and manage real-time data replication and integration flows using Oracle GoldenGate and SQL Server integration tools.
Pipeline Engineering: Develop and optimize high-throughput ETL processes to move data between Oracle and Microsoft SQL Server environments.
Expert Data Modeling: Apply rigorous Relational Data Modeling (3NF) for transactional integrity, alongside Star and Snowflake schemas for analytical performance.
Database Optimization: Perform advanced SQL tuning and indexing strategies to ensure low-latency data access across both Oracle and SQL Server platforms.
Data Governance: Ensure all pipelines adhere to strict data quality standards and metadata management protocols.

Requirements

Experience: 5+ years of experience specifically within Oracle Golden Gate and SQL Server ecosystems.
Modeling Specialist: You have a deep appreciation for relational theory. You understand when to normalize for consistency and when to denormalize for speed.
Real-Time Focused: You have hands-on experience with Batch and Change Data Capture (CDC) and understand the complexities of "always-on" data synchronization.
Problem Solver: You don't just fix broken pipelines; you perform root-cause analysis to ensure they don't break again.
Eligible to work in Egypt.