ODS Enhancement, Saudi Telecom Company Project, Test Analyst, 01/2022 - Present, Understand the domain architecture and understanding the key holder systems and their impact on ODS system., Understand the behavior of a customer journey from end to end in any change request., Understand ODS scope and changes required from the HLD created by ODS Solution Designers., Referring the SDD for more information on the change functionally, if required., Design the Test Cases as per the requirement and setting up the test environment: for ETL, to setup the repositories (EME, Sandbox, configuration files) and to checkout the sandboxes. for Database, to setup the test and preprod database configuration, validating the replication and database tables to be made available & ready to use., As part of ETL testing, to validate the Abinitio graphs designed are properly checked-in, usage of the ETL components and the necessary transformations being applied, transferring the output to designated targets as per the functional requirement of the change request., Validate the output extracts generated using Unix commands in putty to be in required format., As part of Database testing/functional testing, validate the SQL code developed as in database views and database procedures/functions is deriving the data as per the requirement., Raise the bugs or errors for any deviations in the code in ALM, engaging with dev team for the defect closure and ensure to follow the defect lifecycle., Verify the database objects performance by validating the explain plan of the SQL code and simulating the load/performance test using JMETER tool., Document the test results by capturing the necessary proof of results., Coordinating with the E2E systems for various deliverables. Engaging with the system owners during the end to end integration testing., Managing BAT meetings alongside client and also supporting the activities from ODS end to sign-off project to further go-live., Capture the defects if any during E2E/BAT sessions and revalidating the code., Support for planned outage activities like DR or Upgrade Activities., Having cross functional training along with development and solution design team., Implement any project related automations required.