Data Engineer at Valleysoft

Cairo, Cairo, Egypt -

Full Time

Start Date

Immediate

Expiry Date

01 Jun, 26

Salary

0.0

Posted On

03 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Informatica PowerCenter, Data Modeling, ETL Pipelines, Data Warehouse, SQL, NoSQL, Big Data, Hive, Impala, YARN, Kafka, Data Quality, Performance Tuning, Change Control, Data Marts, ODS

Industry

Software Development

Description

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 marts. Gather, process, maintain, and analyze large datasets, ensuring data accuracy and quality. Design, automate, and support ETL pipelines and data flows across multiple applications. Create logical and physical data flow models and mapping designs for ETL processes. Strong SQL skills (performance tuning, index management) and solid understanding of database structures. Strong understanding of data modeling concepts. Familiarity with SQL and NoSQL storage, and Big Data technologies (Hive, Impala, YARN, Kafka, etc.). Informatica-specific requirements: 3+ years of professional experience in Data Engineering, including ETL pipelines, data modeling, and data warehouse environments. Hands-on experience with Informatica PowerCenter development (mappings, sessions, workflows). Strong knowledge of Informatica transformations (e.g., Lookup, Joiner, Aggregator, Expression, Router, Sorter) and performance tuning. Experience with Informatica Developer. Experience with Informatica B2B is a plus. Ability to design, automate, monitor, and troubleshoot ETL jobs, including scheduling. Banking sector requirements (preferred): Previous experience in the banking sector, preferably business banking, including working with banking datasets. Strong understanding of data quality and reconciliation expectations in banking environments. Experience working under regulated environments and change control practices is a strong plus.

Responsibilities

The role involves building and maintaining data warehouses and data marts, gathering, processing, and analyzing large datasets to ensure accuracy and quality. Responsibilities also include designing, automating, and supporting ETL pipelines and data flows across various applications.