- Empower all units of the company with information, predictions, and action plans, making the most out of data and maximizing business value. Moreover, this department shall guide upper management, foreseeing opportunities, and expanding this DCB platform.- Design, develop, document and implement new data management programs and subprograms, as well as enhancements, modifications, and corrections to existing data management platform.- Responsible for the over-all data management architecture, scalability, reliability, and performance.- Collaborating with and/or lead cross-functional teams, build and launch applications and data platforms at scale, either for revenue generating or operational purposes.- Developing and delivering quality services on time and on budget. Solutions developed by the team various ETL technologies.

• Building and Designing ETL jobs Using IBM DataStage.• Building and designing conceptual, logical and physical data models.• Applying dimensional data model concepts and principles to an existing dimensional model in order to enhance the performance and fixing data issues.• Reviewing the design of the DWH model, to confirm whether the data model design is an appropriate with the business requirement or not.• Using schemas design types in designing and building DWH and data mart include cumulative and snapshot facts• Refactoring DWH model In order to handle the data volume increases.• Data cleansing, migration and integration consultancy.

• Develop and maintain ETL jobs in order to automate and facilitate testing execution, and to cover business rules in one automated process.• Write extensive SQL queries, scripts during testing for data validation and Business intelligence projects testing• Act as Testing SME for Business Intelligence (BI) projects involving data migration, ETL, data analytics and reporting• Plan and assign tasks for Quality Engineering team • Review project requirements, design, and all related testing documents • Perform ad hoc testing and tests the most complex parts of the system• Ensure regression, stress, and security testing are done• Monitor bugs closure on ITWORX tracking tool• Manage projects' testing estimates• Manage quality assurance and testing processes• Conduct training sessions for Quality Engineers on different testing topics• Coach and support team members in technical issues, challenges, and problems.• Identify technical risks and support Project Leaders in developing risk management plan and tracking different measurable aspects in projects

 Handle project deliverables quality, audit reviews, and project conformance Prepare requirements defect and project reliability reports  Review requirements and design documents Own, review, and update project test plan and test cases  Prepare traceability matrix for requirements against test cases Execute test cases, test plans, and regression, stress, and security testing. Ensure conformance to quality assurance processes within project. Write extensive SQL queries, scripts during testing for data validation and Business intelligence projects testing