Sumit Aggarwal
Test Specialist
Delhi,DL
Summary
ETL Test Lead with proven ability to deliver high-quality testing outcomes efficiently. Possess strong skills in data validation, SQL scripting, and test automation, ensuring thorough and accurate database testing processes. Excel in problem-solving, communication, and team collaboration, driving successful project completions through effective leadership and technical expertise.
Overview
15
15
years of professional experience
Work History
Test Specialist
Coforge Limited
Greater Noida
04.2020 - Current
- Developed test plans and strategies for ETL testing processes.
- Documented, triaged, and managed defects in software and worked with developers to facilitate timely resolutions.
- Assisted developers in developing complex SQL queries for extracting data from various sources.
- Participated in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems.
- Performed back-end database testing using SQL queries to verify data accuracy in target systems.
- Coordinated with development teams in resolving technical issues related to ETL processes.
- Analyzed workflows and established priorities for daily operations.
- Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
- Test ETL packages for data loading from various sources such as flat files, XML files and SQL databases into the Data Warehouse using SSIS.
- Resolved technical issues encountered by offshore team during execution of tests.
- Ensured that all deliverables adhere to quality standards before being released into production environment.
- Conducted offshore test planning, scheduling and estimation activities.
- Developed test strategy for various projects based on the project requirements.
- Monitored progress of all tasks assigned to offshore team ensuring timely delivery.
- Worked with off-site teams to complete timely tests and facilitate smooth product releases.
Senior Software Engineer
Xavient Digital
Noida
12.2017 - 04.2020
- Performed manual testing to identify bugs and other issues in user interface, functionality, compatibility.
- Provided guidance to junior testers on best practices for software testing techniques.
- Documented, triaged, and managed defects in software and worked with developers to facilitate timely resolutions.
- Identified discrepancies between source and target systems during ETL process testing cycles.
- Developed test plans and scripts to validate ETL jobs.
- Reviewed functional requirements documents to understand scope of work required for testing purposes.
- Monitored bug resolution efforts and tracked successes.
- Conducted unit, integration, system, regression, and performance testing for ETL applications.
- Performed end-to-end validations using SQL queries across different databases like Oracle and Teradata.
Senior Software Engineer
Niit Technologies Limited
Greater Noida
05.2015 - 12.2017
- Documented all test results and reported defects using bug tracking systems.
- Developed detailed test cases based on functional specifications and use cases documents.
- Collaborated with developers on root cause analysis of identified issues.
- Created regression tests to verify fixes of identified defects.
- Monitored bug resolution efforts and tracked successes.
- Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
- Identified areas of improvement within the software development process.
Software Test Engineer
Magna Infotech Pvt Ltd
Gurugram
02.2015 - 04.2015
- Monitored and facilitated bug resolutions to optimize software.
- Completed unit and regression tests on software and individual modules.
- Managed project timelines to ensure timely completion of assigned tasks.
- Simulated software production environments to allow for enhanced testing.
- Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
- Worked with developers to identify, document and track defects in the system.
- Participated in peer reviews of test plans, scripts, data sets and other related documentation.
Software Test Engineer
Magna Infotech Pvt Ltd
Gurugram
03.2014 - 09.2014
- Monitored and facilitated bug resolutions to optimize software.
- Managed project timelines to ensure timely completion of assigned tasks.
- Documented results of all tests performed using standard templates or tools such as JIRA or Bugzilla.
- Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
- Collaborated with project team members to develop effective strategies and test plans.
- Worked with developers to identify, document and track defects in the system.
- Participated in peer reviews of test plans, scripts, data sets and other related documentation.
Software Test Engineer
Actia India Pvt Ltd
Noida
02.2010 - 02.2013
- Monitored and facilitated bug resolutions to optimize software.
- Completed unit and regression tests on software and individual modules.
- Managed project timelines to ensure timely completion of assigned tasks.
- Simulated software production environments to allow for enhanced testing.
- Documented results of all tests performed using standard templates or tools such as JIRA or Bugzilla.
- Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
- Collaborated with project team members to develop effective strategies and test plans.
Education
Master of Computer Applications - Software Engineering
Vinayaka Mission University
Tamilnadu09-2013
Bachelor of Science in Information Technology - Software Engineering
KUVEMPU University
Karnataka 01-2009
GNIIT DIPLOMA - Software Engineering
Niit
Delhi01-2009
Skills
- Data Migration Validation
- Data Warehouse Validation
- SQL server integration services
- Data Workflow Architecture
- Slowly changing dimensions
- Test environment setup
- Stakeholder communication
- Data integration testing
- Business intelligence testing
- Test strategy development
- Data mapping verification
- SQL proficiency
- Data validation testing
- Informatica powercenter
- Incremental load strategy
- SQL querying
- Custom SQL queries
- SQL server proficiency
- Kafka streaming
- Kafka integration
- Test process improvement
- Test estimation
- Test strategy planning
- User acceptance testing
Accomplishments
- Got Pat on the Back Award from Client
- Got Spotlight Award from Coforge
Timeline
Test Specialist
Coforge Limited
04.2020 - Current
Senior Software Engineer
Xavient Digital
12.2017 - 04.2020
Senior Software Engineer
Niit Technologies Limited
05.2015 - 12.2017
Software Test Engineer
Magna Infotech Pvt Ltd
02.2015 - 04.2015
Software Test Engineer
Magna Infotech Pvt Ltd
03.2014 - 09.2014
Software Test Engineer
Actia India Pvt Ltd
02.2010 - 02.2013
Master of Computer Applications - Software Engineering
Vinayaka Mission University
Bachelor of Science in Information Technology - Software Engineering
KUVEMPU University
GNIIT DIPLOMA - Software Engineering
Niit
Similar Profiles
Shanmukha Rao PulariShanmukha Rao Pulari
Senior Software Engineer at Coforge LimitedSenior Software Engineer at Coforge Limited
PAVANI BONTHALAPAVANI BONTHALA
Associate Software Engineer at Coforge LimitedAssociate Software Engineer at Coforge Limited
Sudhir PradhanSudhir Pradhan
Senior Test Engineer at Coforge LimitedSenior Test Engineer at Coforge Limited
Aparna AwasthiAparna Awasthi
Technical Analyst at Coforge LimitedTechnical Analyst at Coforge Limited
ANJU RATHOREANJU RATHORE
Software Developer at Bank of AmericaSoftware Developer at Bank of America