Data Integration Specialist/ Analyst/ Senior Analyst
- Banque Misr Transformation office
- New Cairo City, Cairo Governorate, Egypt
- Full-time
وصف الوظيفة
The role involves designing, analyzing, and developing Effective Assurance Techniques to profile, identify, and address data-related issues throughout the Data Life Cycle and during Data Model Loading Activities, ensuring alignment with organizational objectives. The position also entails the creation of data integration methodologies and reporting frameworks aimed at maximizing the benefits of Data Warehouse Models for the bank.
Additionally, the individual will be responsible for architecting and developing the ETL and ELT environments, processes, programs, and scripts required for data acquisition from source systems, enabling efficient integration into the database tables. A profound understanding of the overall data warehouse architecture is essential for this role.
متطلبات الوظيفة
Core Responsibilities
•Capture ETL Requirements.
•Design, develop, test, support processes for extracting, transforming and loading data from source systems to DWH and Data Marts.
•Design the processes to meet service level agreements for data timeliness and frequency
•Analyze and optimization current solutions, physical model optimization, query tuning
•Mentoring junior members of the team in data integration development best practices
•Analyze and improve query and solution performance, optimize physical model
•Developing project deliverable documentation
•Utilize effectively Online Data Processing Tools
Core Competencies:
•Performance Excellence
•Collab. & Creating Synergy
•Agility & Resilience
•People Centricity
Technical Competencies
•Knowledge of any enterprise relational database (Teradata, Oracle, IBM)
•Professional Knowledge of Two of industrial ETL tool (Informatica, DataStage, ODI, SAS DI or others)
•Strong SQL and Shell scripting
•Experience in implementing ETL solutions for large, enterprise-grade customers
•Experience in implementing ETL solutions in Hadoop environment is an advantage
•Knowledge of MPP system – Teradata, is an advantage
•Any ETL tools, DB certified is an advantage
•Experience Unix/Linus OS
Domain Expertise
•Bachelor's degree in computer science is preferred
•Master/ Certificate preferred
•Banking experience preferred
