AAKASH GANGWAR
PUNE
Summary
Seasoned ETL Tester with comprehensive background in data warehousing and business intelligence. Proven abilities in creating test plans, executing test cases, and performing data validation. Strengths include exceptional problem-solving capabilities, adept at identifying discrepancies and inconsistencies in complex data sets. Demonstrable impact on improving quality of software systems through rigorous testing methodologies and optimization techniques.
Overview
5
5
years of professional experience
1
1
Certification
Work History
ETL Tester
TATA CONSULTANCY SERVICES
PUNE
03.2022 - Current
- Implemented automation frameworks using Selenium WebDriver for smoke and regression testing.
- Verified data integrity between multiple sources and targets after each load run.
- Created and optimized automated testing tools for repetitive tasks.
- Investigated existing production issues related to ETL process by analyzing logs files generated by various components involved in the process.
- Met project scope and delivery dates by planning optimal testing schedules.
- Assisted with developing automated test suites utilizing scripting tools such as TSQL or PL and SQL.
- Provided technical support to users during UAT phase of development life cycle.
- Participated in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems.
- Prepared reports summarizing findings from various rounds of testing activities conducted throughout a release cycle.
- Participated in meetings with stakeholders to discuss project progress, timeline updates and risks associated with the project.
- Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
- Identified discrepancies between source and target systems during ETL process testing cycles.
- Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
- Created detailed documentation of all findings from ETL application tests performed.
Database Administrator
TATA CONSULTANCY SERVICES
PUNE
01.2020 - 02.2022
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Provided technical support and training to end-users and junior DBAs.
- Designed and implemented database systems to meet organizational needs.
- Created and monitored performance metrics to keep databases functioning at optimal capacity.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Monitored performance of queries and tuned them as needed using Explain Plan tool.
- Defined database design specifications based upon project requirements.
- Partnered with project management teams on development of scope and timelines.
- Optimized storage and archiving practices to manage database size and performance.
- Implemented data models, database designs, data access, and table maintenance codes.
- Established security controls to help protect client systems.
Education
B.Tech - Information Technology
GOVERNMENT ENGINEERING COLLEGE
AZAMGARH(U.P)07-2019
11TH-12TH - Science Education
RLB
LUCKNOW(U.P)06-2014
Skills
ETL skills:
- ETL modeling
- Defect monitoring
- System testing
- New feature testing
- Data abstraction
- Multitasking capacity
- Agile methodology
Database Administrator:
- Performance tuning
- Database management
- Database analysis
- Microsoft SQL
- Systems administration
- Data modeling
- Oracle
Others: Splunk, SERVICE NOW,RDP,SAP BASIS,POWERBI,JIRA
Certification
- DATABASE ADMINISTRATOR(UDEMY)
- ETL(UDEMY)
- SAP BASIS(UDEMY)
Timeline
ETL Tester
TATA CONSULTANCY SERVICES
03.2022 - Current
Database Administrator
TATA CONSULTANCY SERVICES
01.2020 - 02.2022
B.Tech - Information Technology
GOVERNMENT ENGINEERING COLLEGE
11TH-12TH - Science Education
RLB
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Vaibhav SuryawanshiVaibhav Suryawanshi
UI Developer at Xcaliber Infotech Private LimitedUI Developer at Xcaliber Infotech Private Limited