User's Cover Picture
User's avatar

Swarna Joti Balaji

DW ETL Testing | MDM Testing | Report Testing- PBI | API Testing | Agile

Message
Intro
Sonderborg, Denmark
Studied Electrical and Electronics Engineering at Anna University
Information Technology & Services
Joined June 8, 2023

Skills

Languages

English
-
Fluent
About
I worked in Cognizant and Deloitte USI as Test Engineer specializing in the ETL, SQL, Datawarehouse, Test Design, Data mining, Agile methodology, Functional Testing with a experience of 6.2 years. I have enjoyed my experience in Subject Matter roles, delivering large and complex projects. I see my key strengths to being process-oriented, applying best practice strategies, communication, assertiveness, and problem-solving.
Experience
User avatar
Deloitte India
Nov 2021 – Apr 2023
India
ETL Test Analyst
• Subject matter expert in ETL testing. • Work closely with stakeholders, developers and source teams to analyze and gather requirements • Good experience in test data management • Designed test strategies, RTMs, test scenarios and test cases • Performed Functional, E2E, Sanity, Smoke and Regression testing • Co-ordination and execution of Integration testing with cross-functional teams • Well versed in data validation for the ETLs developed using Informatica, DBT, Abinitio and DataStage tools • Participated in Agile ceremonies like Sprint planning, Backlog grooming, Sprint Retrospective, Daily Stand and Sprint reviews • Used Application Life-cycle Management (ALM), Rally, Polarion and Jira for Test and Defect management • Sound knowledge on Software testing and Defect life cycle processes. • Experience in working with Unix commands to Sample test files and run scripts for ETL Process • Provided demos/walk through of documented testing results at the end of projects • Worked closely with the Automation team in fine-tuning the SQL queries used in Automation test scripts to reduce the Automation regression failure due to bad data • Initialed and lead the documentation process after test closure to highlight the pain-points and mitigation process for future reference • Formulated the test metrics on a monthly, weekly and daily basis • Provided live demo of the project at the end of each sprint to the clients and users • Designed a working prototype of a data validation tool to validate data between Teradata and PostgreSQL databases using python • Onboard and mentor junior members of the team to get them to speed. • Working experience in enhancing data validation tools.
User avatar
Cognizant Technology Solutions
Feb 2017 – Oct 2021
India
ETL Test Analyst
• Subject matter expert in ETL testing. • Work closely with stakeholders, developers and source teams to analyze and gather requirements • Good experience in test data management • Designed test strategies, RTMs, test scenarios and test cases • Performed Functional, E2E, Sanity, Smoke and Regression testing • Co-ordination and execution of Integration testing with cross-functional teams • Well versed in data validation for the ETLs developed using Informatica, DBT, Abinitio and DataStage tools • Participated in Agile ceremonies like Sprint planning, Backlog grooming, Sprint Retrospective, Daily Stand and Sprint reviews • Used Application Life-cycle Management (ALM), Rally, Polarion and Jira for Test and Defect management • Sound knowledge on Software testing and Defect life cycle processes. • Experience in working with Unix commands to Sample test files and run scripts for ETL Process • Provided demos/walk through of documented testing results at the end of projects • Worked closely with the Automation team in fine-tuning the SQL queries used in Automation test scripts to reduce the Automation regression failure due to bad data • Initialed and lead the documentation process after test closure to highlight the pain-points and mitigation process for future reference • Formulated the test metrics on a monthly, weekly and daily basis • Provided live demo of the project at the end of each sprint to the clients and users • Designed a working prototype of a data validation tool to validate data between Teradata and PostgreSQL databases using python • Onboard and mentor junior members of the team to get them to speed. • Working experience in enhancing data validation tools.
Education
User avatar
Anna University
Sep 2012 – May 2016
Bachelor's of Engineering, Electrical and Electronics Engineering