ETL Data Warehouse Test Engineer

Manoj Dinkarrao Banvaskar Contact : 960-***-****

ETL Test Engineer E-Mail ID : *****************@*****.*** 6 yrs of Experience in ETL Testing

PROFESSIONAL SUMMARY

ETL Test Engineer with 6 years of experience in ETL and Data Warehouse Testing, Data validation, Reconciliation, Data quality checks, SQL-based verification and source-to-target testing. Hands-on experience with Oracle 11g, Teradata, Hive, Unix/Linux environments, Ab Initio, Informatica, Databricks, Spark, WinSCP and Putty. Strong in end-to-end testing of data integration flows Test scenario design, Test execution, Defect management and analysis of Data mismatches. Experienced in Agile/Scrum delivery and working with cross-functional stakeholders. Seeking an ETL/Data Integration Testing role where strong Oracle SQL, Linux and Testra Tool, Chatbot Test,Dashboard Test platforms.

PROFESSIONAL SYNOPSIS :-

• Work Experience in ETL/ Datawarehouse testing, SQL Queries

• Testing experience by Writing and executing SQL Queries

• Exposure to Data warehousing Concept using Fact tables, Dimension tables, Star and Snow flake schema .

• Experience in Data Analysis, Data Validation, Data Cleaning, Data Verification and identifying data mismatch Data reconciliation by comparing source and target record counts, aggregates, and individual records.

• Good knowledge in Dimensions like SCD1, SCD2 and SCD3.

• Knowledge on OLTPand OLAP.

• Experience in ETL process consisting of Data transformation, Sourcing, Mapping, Conversion and Loading Data, Unix command, Data warehouse Testing, Chatbot Test, Dashboard Test, Python

• Validatethe Data using Oracle 11g, Putty, WinSCP, Abi initio, Hive, Tera Data, Hive,Spark,Databricks, Testerra

• Clear Understanding of Software Development Life Cycle (SDLC).

• Clear Understanding of Software TestingLife Cycle and Defect Life Cycle.

• ClearExperience of Agile and SCRUM Framework.

• Through knowledge of software testing methodology including Sanity, Smoke, Functional Testing, Retesting Testing and Regression Testing of an application.

• Strong experience in Analyzing requirements and identifying Test Scenarios, Writing Test cases, Test Execution, Documentation,CI CD

• Used JIRA as Defect Tracking tool.

• Knowledge of UNIX Commands.

• Perform the No. of Validation using SQL simple& complex queries on Database and Data warehouse Testing. Technical Skills

Database : Oracle11g,Tera Data,Hive

Project management Tools : JIRA, Testra

Tools : Abi initio,WinSCP,Putty, InformaticaPower Center, Oracal SQL Developer, Databricks

Operating Systems : Windows 7/10,Win11

Software Testing Skills : ETL Testing, Database/Data Warehouse Testing, Retesting, Sanity Testing,Regression Testing,STTM, Unix, SQL EDUCATION:-

B E in Electrical from RTMN University with (2018) 62 %.First Class

Diploma in Electrical from MSBTE board with (2012) 61 %.First Class

SSC Latur Division state board with (2006) 78 %. First Class

PAN CARD:-- CBUPB6523N

Resume

PROFESSIONAL EXPERIENCE :-

Total 6 years of experience in ETL Testing

Presently working as a ETL Test Engineer for VARITE INC, Pune - June 2026 to july2026. Varite INC

ETL Test Engineer

Project #

Project Title : Abbvie

Domain : Pharma

Client : US

Technology used : Teradata, Oracle SQL,Dashbord, Putty, Ab Initio,Jira,Hive. Spark shell,Databricks,Testerra,Python,cloud Ai, Automation Test in Testra, Unix

Role : ETL Test Engineer.

Duration : May 2026 to july2026

Description : Performed end-to-end ETL testing and source-to-target validation for pharmaceutical data, ensuring data accuracy, completeness and integrity across data warehouse layers and use also Unix,sql and CI CD

CAMSDATA Technologoes

ETL Test Engineer

Project #

Project Title : USCC

Domain : Telecom

Client : USA

Technology used : Teradata, Oracle SQL Developer, Putty, Ab Initio,Jira,Hive. Spark shell,Databricks,Testerra,Python,Unix

Role : ETL Test Engineer.

Duration : April 2025 to April2026

Description : Wireless data network and services, including data rating engine development and improvements. The projects have focused on features like wireless data call rating logic, roaming, number portability, and dynamic scripts for customer announcements. Net Connect Global

ETL Test Engineer

Project #

Project Title : KYC SRR

Domain : Banking

Client : Barclays, UK

Technology used : Teradata, Oracle SQL Developer, Putty, Ab Initio,Jira,Hive. Duration : March 2024 to Feb 2025

Description : Barclays Bank has been facing longstanding issues with it’s Financial crime environment which have been exacerbated following scrutiny from the financial conduct authority (FCA)

.In this project KYC we will find out the customer who is kyc pending and we do the kyc in ETL through. We will perform kyc.The bank remediation program will require a coordinated effort to improve it’s KYC practices meet regulatory requirement and mitigate the risk of penalties. Anaxturia IT Services

ETL Test Engineer

Project #

Title : Emblem Health

Client : Emblem, USA

Domain : Health Insurance

Tools and Technology Used : Oracle SQL Developer, JIRA, Informatica, Unix,Putty. Role : ETL Test Engineer.

Duration : August 2021 to March 2024

Description : Emblem health Insurance through its companies group health incorporated(GIH) and HIP health plan of NY(HIP) provides affordable quality health care coverage. The project goal is to create datamart for analysis of current information on various health plan and store all data in Dataware house. PERSONAL DETAILS:-

Name : Manoj D Banvaskar

Language : English, Hindi and Marathi

Gender : Male

Permanent Address : Sudarshan Nagar, Pimpri chinchwadgao Pune- 411033 Date:

Place: Manoj D Banvaskar

Contact this candidate