Mekerta Mohammed

Development of a processing modernization prototype aimed at ensuring the reliability of flows feeding the Orange data warehouse (Individual & Professional revenue). Rewriting and industrialization of flows according to modern Datawarehousing standards (ODS, Work, DWH, historization layers). Advanced use of Teradata analytical functions (window functions, volatile tables, temporality) to automate: Catch-up of base tables, Data historization, Automatic closure of records in the past. SQL query optimization on very large data volumes (tables with billions of rows). Monitoring, diagnosis, and intervention on critical processes related to sensitive data (especially financial). Management and rapid resolution of incidents impacting sales compensation, through impact analyses and targeted correction scripts.

Gathering, Impact Analysis, and Scoping of business needs. Creation of complex SQL procedures and macros with advanced use of SQL and TERADATA (analytical functions, volatile tables, complex joins). Analysis and correction of KO scenarios for the CUCUMBER report. Use of a CI/CD pipeline to streamline creation, testing, and deployment. SQL query optimization to improve performance. Writing functional documentation for user stories with Confluence. Management of large data volumes (tables with billions of rows) and complex business rules related to the functional domain. Creation of Shell scripts to implement user stories. Execution of automated test scenarios with Cucumber. Acceptance testing of complete pipelines (JAVA, UNIX, TERADATA) with Cucumber and validation of the user story by the PO only if the report is green. Application of CI/CD chains for deployment and component integration. Code version management with GitLab, creating a separate branch for each developer for each user story developed before merging to the main branch. Management of code conflicts before merging code to the main branch using IntelliJ and GitLab. Deployment of TERADATA and JAVA components with JENKINS. Use of Kubernetes for monitoring deployments contained in specific Docker containers for each environment, acceptance testing under Assistance to the Product Owner in writing TERADATA user stories with Confluence. Assistance to the Product Owner in technical/functional scoping of TERADATA user stories by facilitating business workshops. Backup Scrum Master for AGILE ceremonies (Daily meeting, sprint planning, sprint review...). Resolution of production incidents on sensitive regulatory scripts manipulating tables with billions of rows.

TECHNICAL ENVIRONMENT: TERADATA 17.10, UNIX, GIT, JENKINS, CUCUMBER, intellij, JAVA, ANGULAR

Support and coaching of squad developers in solution implementation, helping them resolve complex technical issues and providing guidance to improve their skills. Supervision of Development Quality through code reviews and the implementation of development standards and practices. Coordination between different stakeholders: business, DATA architect, business analyst, production infrastructure management, developers, and Indian-based service providers, by facilitating meetings or workshops to advance and clarify all project elements. Regular communication with reporting on the squad's project progress. Monitoring of BIG DATA projects and planning of steps based on business priorities and dependencies between different data flows and technologies (HADOOP, TERADATA, MVS (JCL-TPT) ETL, UNIX). Analysis and optimization of TERADATA SQL scripts impacting production. Production monitoring and flow supervision with Control M, including hot incident resolution to restart the production plan. Analysis and scoping of business needs, carrying out technical and functional impact studies and estimations. Development of TERADATA SQL, TPT flows, and Datastage PX Jobs. Development acceptance testing: unit tests, integration tests, and regression tests if needed. Writing technical architecture documentation for the FRISCO DATAMART. Technical DEV/OPS referent for the squad for support, assignment, and management of developer rights. Application of CI/CD chains for deployment and component integration. Code version management with GitLab. Management of code conflicts before merging code to the main branch on GitLab. Deployment of TERADATA/ETL/UNIX components. Documentation of developments.