Shanmugasundaram B

Experienced ETL Testing professional with 5.4 years of expertise in validating data transformations and supporting cloud migration projects. Proficient in testing and validating data pipelines and workflows using Informatica IICS and Azure Data Factory (ADF) with strong SQL development skills across Oracle, Snowflake, and SQL Server. Hands-on experience with tools like PostgreSQL for query execution, data validation, and database management

Date of Birth: 01/28/98

• English
• Tamil

SUMMARY: 

Project # 1

Domain: Vegetation Management Services
Role: QA Engineer
Team Size: 5
Environment: MSSQL Server, Informatica IICS, Azure Data Factory
Client: ACRT, United States of America
Duration: 07/2024 – 05/2025

Roles and responsibilities:

● Working closely with business and development teams to understand the data migration requirements and transformation logic during the migration from Informatica IICS to Azure Data Factory (ADF).
● Developing and executing complex SQL queries to validate data accuracy, completeness, and consistency between source and target systems.
● Performing end-to-end data validation of the migration pipeline, ensuring that business-critical data is preserved accurately during transformation.
● Designing and executing comprehensive test scenarios and test cases for the ADF pipelines to ensure data quality and system reliability.
● Logging and tracking defects in JIRA and collaborating with the development team to drive timely resolution.
● Conducting regression testing on newly migrated pipelines and verifying that existing data processing functionality is not impacted by the migration.
● Preparing and delivering detailed test summary reports (TSR) to communicate testing outcomes, coverage, and defect trends to stakeholders.
● Actively participating in Agile ceremonies (daily stand-ups, sprint planning, and retrospective meetings), providing progress updates and contributing to continuous improvement discussions.
● Recognized as a Standout Performer for exceptional contribution to the ETL Testing efforts in this large-scale ADF Migration Project

Project # 2

Domain : Industrial Real Estate & Supply Chain Logistics

Role : QA Engineer

Team Size : 7

Environment : MSSQL Server, Snowflake

Client : PROLOGIS, United States of America 

Duration : 01/2024 – 05/2024

Roles and responsibilities:

● Working closely with business teams to understand the requirements, functionality, and design.

● Developing SQL queries based on the mapping document and querying data against different databases for the data verification process.

● Contribution towards developing a test case scenario, running the test cases, and logging defects in JIRA, which helped identify and fix issues before deployment.

● Created SQL queries using joins, aggregate functions to validate the joiner, and aggregator transformation logics.

● Identified and resolved critical data integration issues during ETL testing, significantly improving data flow between applications and minimizing system integration errors

● Actively participated in agile calls as a team member, providing updates on my progress with JIRA tickets related to my tasks.

● Executed Negative Scenarios in all areas where it is possible and ensured the Reliability of the software.

● Applied SQL queries and data analysis techniques to test the integration between BI reports and the DWH. Ensured seamless data retrieval and accurate representation of Datawarehouse data within reports.

Project # 3:

Domain : Investment Banking

Role : Senior Process Associate 

Team Size : 8

Environment : SQL Server, Snowflake, Informatica 

Client : BMO, Canada

Duration : 08/2022 – 08/2023

Roles and responsibilities:

● Participated in preparation of test script development in ORACLE and SQL SERVER

databases using the SQL query techniques like joins, Subquery and analytical functions to validate various transformation logics.

● Validations of flat files by using of the UNIX commands to check the filename, patterns and permission for the source files.

● Created Bug reports in the Excel and reported the bugs in the JIRA application to communicate about the bug to development team and for the proper tracking of the bug till the closure.

● Involved in attending of agile calls and updated the current status of the working JIRA in the scrum call.

● Created test summary reports (TSR) to find the test coverage in the time of test closure.

● Involved peer -peer validation of the test cases, test scenarios and test scripts before executing them in the SIT environment.

● Smoke test to validate the application build for the initial, Regression for the impact of the build for the existing functionalities.

● Communicated to the business team to get clear about the requirement gaps and understand the functionality where ever the clarifications needed.

Project # 4:

Domain :Investment Banking

Role : Software Tester

Team Size : 15

Environment : Oracle, Postgres SQL, Unix 

Client : Lloyds Bank, London, United Kingdom 

Duration : 08/2019 – 07/2022

● Gather and analyze the business requirements of new change request and enhancement from client.

● Defects identified in testing environment are communicated to the developers through JIRA.

● Analyzing the output results and preparing the test summary report (TSR) while closing the testing process.

● Escalation of the issues wherever faced to the appropriate authorities to bring it up to their notice and getting immediate resolutions.

● Demonstration of the completed points to the scrum master and product owner in the Sprint review meeting.

● Involved in web application validations and the reports which are created by the application to validate the entire flow of data which are created in the transaction screens against the reports.

Balasekar

ETL Testing: Design and execute the SQL scripts to validate data integrity across all stages of the ETL process.

Data Warehousing: Analyze data which are migrated from source systems to target data warehouses (Star/Snowflake schema) to ensure data accuracy.

Data Quality Management: Identify and resolve data quality issues through log file analysis and various testing methodologies (Sanity, Smoke, Functional, Regression).

Agile Collaboration: Successfully collaborate within Agile teams for efficient data pipeline deployments.

• Recognized as a Standout Performer for exceptional contribution as an ETL Tester in the ADF Migration Project