Bhaskar Amarnath Pennati
Guntur
Summary
ASPIRATION I have a 6+ years of experienced capable IT professional who has good experience in ETL ,DWH Testing & API Testing with solid approach on testing different scenarios and ensuring accurate data loads. Test Engineer with excellent technical communication skills, collaborative teamwork abilities and broad technical acumen across full SDLC. Familiar with scenario, functional ,regression testing and performance testing and UX in Windows environments. Qualified Test Engineer proven to implement and maintain cost-effective methods of system testing and troubleshooting to reduce operating costs. Technically-savvy and skilled at quickly learning new concepts, software and equipment. Collaborative team player with excellent communication and interpersonal talents.
Overview
7
7
years of professional experience
Work History
ETL Test Engineer
Deloitte
01.2023 - Current
- Project: JUNO
- Increased network efficiency by performing comprehensive ETL testing and analysis.
- Enhanced system performance through troubleshooting and resolution of identified issues.
- Improved customer satisfaction with optimized network coverage by conducting drive tests and analyzing data.
- Collaborated with cross-functional teams to streamline test procedures, resulting in reduced time for issue resolution.
- Developed detailed test plans for various ETL features to ensure seamless implementation and operation.
- Developed detailed test plans for various ETL features to ensure seamless implementation and operation.
- Maintained accurate documentation of all test results, ensuring easy access to vital information for project stakeholders.
- Reviewed, evaluated, and identified requirements for testability.
ETL Test Engineer
Capgemini
07.2021 - 07.2022
- Project: ANZ
- Previously worked in Capgemini as an, ANZ is one of the largest Banking Sector providing companies in the Australia and New
- Zealand
- The primary objective of the project was to construct an aggregated Data Mart for analytics and reports used by business
- As a QA Engineer, I used to run the test cases for the end-to-end process in that data mart
- Involved in Functional Testing, User
- Interface Testing, Multiplatform Testing
- Responsibilities:
- Worked on the ETL Testing processes using ETL tool to extract the data from sources like
- Oracle, MySQL, SQL Server, Flat files, Teradata thereby loading the data into the target
- Datamart
- Responsible for testing all new and existing ETL data warehouse components
- Executing back-end data-driven test efforts with a focus on data transformations between various systems and data warehouse
- Writes SQL queries including complicated joins to verify proper mapping of data elements
- Data cleansing and mockup data creation
- Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
- Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL for data integrity
- Experience in SDLC and Agile methodologies such as SCRUM
- Worked on the ETL Testing processes using SAS tool to extract the data from sources like
- Oracle, Flat files, Teradata thereby loading the data into the target Datamart
- Trained junior engineers on best practices for ETL testing, fostering a culture of continuous improvement within the team.
Software engineer
IBM
05.2017 - 06.2021
- Project: AHM
- Healthcare is one of the largest health insurances providing companies in the United States of America.
- Project object is build a Clinical – Subject Area specific data
- ROLES AND RESPONSIBILITIES:
- Developed SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying tables and columns from which data is extracted
- Involved in Unit testing and integration testing of Mappings
- Performed Functional testing, System testing, Regression testing and Back-end testing
- Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
- Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
- Worked with Business Analysts, developers while reviewing the Business Requirement
- Documents and when there are enhancements in the applications
- Involved in documentation in order to maintain and run scripts for future enhancements
- Involved in test plan, test cases and do the Unit testing, UAT and send them to projects lead for approval
- Prepared Test Cases and Test Plans for the mappings developed through the SAS tool
- Executed the developed Test Cases and Test Plans
- Responsible for creating Test Strategy for the DataMart design
- Responsible for communicating Defect Status Reports to business in project meetings
- Responsible for testing all new and existing ETL data warehouse components
- Proficiency with HP (mercury) tools – ALM/Quality Center
- Analyze and understand the ETL workflows developed
- Quality Management - Knowledge of quality management methods, tools and techniques
- Validation of data transformations and perform End-to-End data validation for ETL & BI systems
- Strong in ETL data validation developed using SAS ETL environments
- Consistently met project deadlines by effectively managing time and prioritizing tasks according to importance.
Education
B. Tech -
Loyola Engineering College JNTU
Skills
- ETL Testing
- Scrum Framework
- SSMS/Oracle Developer
- Performance Testing
- Test Plan Development
Timeline
ETL Test Engineer
Deloitte
01.2023 - Current
ETL Test Engineer
Capgemini
07.2021 - 07.2022
Software engineer
IBM
05.2017 - 06.2021
B. Tech -
Loyola Engineering College JNTU
Similar Profiles
Albert Laurentiu IonAlbert Laurentiu Ion
Junior Information Technology Consultant at DeloitteJunior Information Technology Consultant at Deloitte
Sai Rekha SuradaSai Rekha Surada
Solution Advisor - Manager FCC Investigations Team at DeloitteSolution Advisor - Manager FCC Investigations Team at Deloitte
Sai Ramesh VattiSai Ramesh Vatti
Sr. UIUX Consultant at DeloitteSr. UIUX Consultant at Deloitte