About Valleysoft
Valleysoft is an IT services provider delivering enterprise technology, application development, process management, and IT support solutions to clients worldwide. Operating across the information technology and services sector, the company partners with organizations on complex digital transformation initiatives and business-critical systems that support day-to-day operations and long-term growth.
Job summary
The data engineer (data integration) will be responsible for designing, developing, and maintaining enterprise data integration solutions that enable the efficient movement of data from operational and external source systems into the business intelligence and analytics environment. The role requires strong expertise in ETL development, data integration, data transformation, and data quality using enterprise integration tools such as Informatica, IBM DataStage, or Ab Initio.
This position is an on-site role based at the Administrative Control Authority (ACA) in the New Administrative Capital.
Key responsibilities
- Design, develop, and maintain enterprise data integration and ETL solutions.
- Build extract, transform, and load (ETL) processes to integrate data from multiple operational and external source systems.
- Develop data mappings, transformation logic, workflows, and reusable integration components.
- Ensure data quality, integrity, consistency, and completeness throughout the data integration lifecycle.
- Monitor, troubleshoot, and optimize ETL jobs for performance, scalability, and reliability.
- Collaborate with business analysts, data architects, BI developers, and application teams to understand data requirements.
- Support data migration, reconciliation, validation, and production deployments.
- Participate in data modeling, data profiling, and metadata management activities.
- Develop and maintain technical documentation, ETL specifications, and operational procedures.
- Support production issues, root cause analysis, and continuous improvement initiatives.
Requirements
- Bachelor's degree in computer science, information technology, information systems, engineering, or a related field.
- Relevant certifications in Informatica, IBM DataStage, or other data integration technologies are a plus.
- 7+ years of experience in data engineering, data integration, or ETL development.
- Proven experience delivering enterprise-scale data integration projects.
- Hands-on experience with at least one leading ETL tool such as Informatica PowerCenter, IBM DataStage, or Ab Initio.
- Experience working with large-scale enterprise data warehouse or business intelligence environments.
Must-have requirements
- Min 3 years of experience in data engineering or data integration.
- Strong hands-on experience with Informatica PowerCenter, IBM DataStage, or Ab Initio.
- Strong knowledge of ETL design, development, and optimization.
- Experience with SQL and relational database management systems such as Oracle, SQL Server, or PostgreSQL.
- Experience working with data warehousing and business intelligence environments.
- Strong understanding of data integration architecture, data mapping, transformation, and data validation.
- Experience with performance tuning and troubleshooting ETL workflows.
- Knowledge of data quality, data governance, and metadata management principles.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work effectively in a collaborative, cross-functional environment.
- Fluent in English, both written and spoken.
Good-to-have requirements
- Experience with cloud-based data integration platforms (Azure, AWS, or Google Cloud).
- Familiarity with big data technologies such as Hadoop or Spark.
- Experience with Python or shell scripting for ETL automation.
- Knowledge of CI/CD pipelines and DevOps practices for data engineering.
- Experience in government, financial services, or large enterprise environments.
- Experience with data governance frameworks and enterprise data management.