Data Engineer

Valleysoft | Center of Excellence is a regional IT services provider based in Egypt, serving clients globally since 2006. The company collaborates with global partners like Oracle to address diverse business and technical challenges, from enterprise application development to process management. Valleysoft's vendor-neutral and process-oriented approach, coupled with operational maturity, ensures high-quality and cost-effective services for clients.Job description:Build and maintain data warehouse and data marts, including ODS and internal departmental martsGather, process, maintain, and analyze large datasets, ensuring data accuracy and qualityDesign, automate, and support ETL pipelines and data flows across multiple applicationsCreate logical and physical data flow models and mapping designs for ETL processesStrong SQL skills (performance tuning, index management) and solid understanding of database structuresStrong understanding of data modeling conceptsFamiliarity with SQL and NoSQL storage, and Big Data technologies (Hive, Impala, YARN, Kafka, etc.)RequirementsInformatica-specific requirements:3+ years of professional experience in Data Engineering, including ETL pipelines, data modeling, and data warehouse environmentsHands-on experience with Informatica PowerCenter development (mappings, sessions, workflows)Strong knowledge of Informatica transformations (e.g., Lookup, Joiner, Aggregator, Expression, Router, Sorter) and performance tuningExperience with Informatica DeveloperExperience with Informatica B2B is a plusAbility to design, automate, monitor, and troubleshoot ETL jobs, including schedulingBanking sector requirements (preferred):Previous experience in the banking sector, preferably business banking, including working with banking datasetsStrong understanding of data quality and reconciliation expectations in banking environmentsExperience working under regulated environments and change control practices is a strong plus