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. - 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. - Private Health Insurance - Training & Development