Abantika Ghosh
Kolkata,WB
Summary
High-performing and proactive professional with over 8 years of experience in data warehouse testing and ETL testing at recognized IT companies in the banking, telecom, and retail domains. Well-rounded data warehouse tester with successful experience in Agile teams, collaborating closely with development teams, IT analysts, data modelers, and users (UAT) to consistently deliver results on time. Demonstrated leadership skills through mentoring new team members and ensuring timely completion of deliverables. Proficient in conceptual data modeling and writing complex SQL queries in Oracle SQL Developer, Teradata, AWS Redshift and Athena, Snowflake, and Databricks to derive accurate test results within tight deadlines. Skilled in designing test scenarios and test cases, working effectively in Scrum teams, and possessing thorough knowledge of Agile technology and SAFe Agile methodologies. Hands-on experience in PL/SQL, SQL, shell scripting, Teradata, AWS Redshift, and AWS Athena to analyze business and data requirement documents for a deep understanding of banking and retail operations. Expertise in utilizing tools such as JIRA, HP ALM, SQL Workbench, AWS Cloud, AWS Redshift, and AWS Athena. Additionally, knowledgeable in the automobile domain through experience in functional testing and holds an ISTQB certification.
Overview
8
8
years of professional experience
1
1
Certification
Work History
ETL Test Lead
Deloitte Consulting India Private Limited
02.2021 - Current
- Company Overview: Industry: Insurance, Service Area: GPS, Service Line: GPS AI & Data, Website: [Deloitte](https://www2.deloitte.com/global/en.html)
- Involved in writing complex queries for source and target data validation, finding duplicacies in data
- Verifying data between Source and target
- Use of Databricks to validate data between different layers
- Writing Test Cases for the relevant scenarios
- Performing sanity testing and regression testing
- Performing defect retesting and tracking of the same
- Performing defect analysis and data analysis on the tickets assigned
- Industry: Insurance, Service Area: GPS, Service Line: GPS AI & Data, Website: [Deloitte](https://www2.deloitte.com/global/en.html)
ETL Tester
Accenture
07.2019 - 02.2021
- Company Overview: Industry: Food Industry, Service Area: Retail, Service Line: Data Governance and Management, Website: [Accenture](https://www.accenture.com)
- Involved in writing queries for source and target data validation, finding duplicacies in data
- Verifying data between Source and target
- Performing Data Load
- Use of Aws Redshift and AWS Athena to validate data
- Writing Test Cases for the relevant scenarios
- Performing sanity testing and regression testing of application
- Performing defect retesting and tracking of the same
- Support To UAT testers
- Performing defect analysis and Data analysis on the Use Cases
- Use of Jira, Agile methodology
- Industry: Food Industry, Service Area: Retail, Service Line: Data Governance and Management, Website: [Accenture](https://www.accenture.com)
ETL Tester
Capgemini
11.2016 - 07.2019
- Company Overview: Industry: Banking, Service Area: Banking, Service Line: ETL, Website: [Capgemini](https://www.capgemini.com)
- Involved in writing SQL queries for Source and Target data validation, finding duplicacies in data, Attribute Mapping, Reconciliation
- Verifying data between Source to Stage to Core to SBSL to Reporting SL
- Running Streams and Core Loading
- History handling And Delta handling Scenarios
- Backtracking and Analyzing Data Discrepancies
- Writing Test Cases for the relevant scenarios
- Use of Jira and ALM
- Defect Analysis and Defect Retesting
- Industry: Banking, Service Area: Banking, Service Line: ETL, Website: [Capgemini](https://www.capgemini.com)
Education
Bachelor of Technology - Applied Electronics and Instrumentation
West Bengal University of Technology
Skills
- Expertise in Oracle PL/SQL
- SQL Plus Proficiency
- Test case design
- Defect tracking management
- Test process improvement
- Test automation frameworks
- Teradata SQL Assistant
- SQL Workbench
- Unix Shell Scripting
- Python
- Unix
- JIRA
- HP ALM
- Confluence
Certification
ISTQB Foundation Level Certification
Company
Deloitte Consulting India Private Limited
Contact
+91, 8981732875
Personal Information
Title: Senior Consultant
Training
- Python for Everybody Coursera training completed
- RDBMS Training for Campus Joiners in Capgemini
System Experience
Putty/WinScp: Project Experience, Teradata SQL Assistant: Project Experience, SQL Workbench: Project Experience, AWS console Management: Project Experience, SQL: Expert, PL/SQL: Project Experience, Unix Shell Scripting: Project Experience, Unix: Project experience, Teradata: Project Experience, AWS Redshift: Project Experience, AWS Athena: Project Experience, Oracle SQL Developer: Project Experience, Microsoft Word/Excel/Power Point: Project Experience, JIRA: Project Experience, HP ALM: Project Experience, Confluence: Project Experience
Timeline
ETL Test Lead
Deloitte Consulting India Private Limited
02.2021 - Current
ETL Tester
Accenture
07.2019 - 02.2021
ETL Tester
Capgemini
11.2016 - 07.2019
Bachelor of Technology - Applied Electronics and Instrumentation
West Bengal University of Technology
Similar Profiles
Akhtar KhanAkhtar Khan
DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)
Gowtham BGowtham B
BA & QA Test Analyst at Deloitte Consulting India Private Limited | Bengaluru, IndiaBA & QA Test Analyst at Deloitte Consulting India Private Limited | Bengaluru, India
Shilpa SabuShilpa Sabu
Senior Analyst- Talent at Deloitte Consulting India Private LimitedSenior Analyst- Talent at Deloitte Consulting India Private Limited
Jayita BhattacharyaJayita Bhattacharya
Consultant at Deloitte Consulting India Private LimitedConsultant at Deloitte Consulting India Private Limited
Arpan MistryArpan Mistry
Operator Technician at TranstechOperator Technician at Transtech