ETL QA and Data Validation Engineer

RUSHIKESH SHINDE

ETL TEST ENGINEER

Pune, Maharashtra +91-954******* *******************@*****.*** PROFESSIONAL SUMMARY

ETL QA / ETL Test Engineer with around 5 years of experience in ETL testing, database testing, functional testing, UI testing, regression testing, and end-to-end data validation. Hands-on experience with IBM InfoSphere DataStage, Talend, SSIS, Oracle SQL, Control-M, UNIX, Kafka, EDQ/OWS, Postman, JIRA, Azure DevOps and Splunk. Experienced in validating source-to-target data, developing SQL from mapping and DRS logic, testing CDC/OGG/file- based feeds, and validating SCD Type 1 and Type 2 implementations. Strong understanding of OLTP and OLAP environments, test case design, defect management, retesting, regression testing and production-release validation. Experience in banking and financial-services applications. Worked on AWS Cloud server CORE SKILLS

ETL & Data Warehouse Testing: ETL Testing, Data Warehouse Testing, Source-to-Target Validation, Data Validation, Data Integrity, Mapping Validation, and Initial/Incremental Load Validation Database & SQL: Oracle SQL, SQL Server, SSMS, Complex SQL Queries, Joins, Data Comparison, Source/Target Reconciliation

CLOUD: AWS EC2 Server, Storage service Amazon S3, AWS-Athena AI Tools: Github Co-pilot, HSBC Productivity Suite, JIRA AI Launcher ETL Tools: IBM InfoSphere DataStage, Talend, SSIS

Data Integration: CDC, OGG, File-Based, Kafka

Testing: Functional Testing, UI Testing, API Testing, Regression Testing, Retesting, End-to-End Testing, Test Scenario Identification, Test Case Design, Defect Testing

QA Tools: Tosca, Postman, JIRA, Azure DevOps (ADO) Scheduling & Platforms: Control-M, UNIX, Putty

Data Quality & Monitoring: OWS-EDQ, Splunk Dashboard, Tableau, QlikView Programming/Automation tools: Basic Python with selenium, TOSCA PROFESSIONAL EXPERIENCE

Ernst & Young (EY), Pune Senior Consultant – ETL QA May 2024 – Oct 2026 Client: HSBC Bank Project: Name Screening

• Perform end-to-end ETL testing for BAU change requests across CDC, OGG and file-based source systems.

• Validate source-to-target data using SQL derived from mapping documents and DRS logic, ensuring data accuracy and integrity.

• Perform end-to-end testing for approximately 20 country feeds during LP Evergreening and CLZ Evergreening initiatives.

• Validate application and data flows during Oracle database upgrade from 12C to 19C and RHEL upgrade from RHEL6 to RHEL8.

• Execute ETL and data-feed jobs through Control-M and CDC Console and perform regression testing for impact analysis.

• Perform OWS testing to validate sanctioned and non-sanctioned records and verify real-time screening alerts.

• Conduct L1 interviews for ETL Testing and support technical evaluation activities. Technologies: IBM InfoSphere DataStage, Control-M, Oracle SQL, SQL Server, Unix, PuTTY, OWS/EDQ, Splunk Dashboard, Tosca, JIRA, AI Launcher, GitHub Copilot, Git Commits, AWS S3 Kiya.ai, Pune Associate Consultant – ETL QA Sep 2022 – May 2024 Client: CRISIL Ltd. Projects: Garnet and SAP Revamp

• Performed functional and UI testing for 67 screens of the Garnet application and testing of Greenwich applications.

• Executed ETL jobs using SAP and Talend and performed source-to-target data validation.

• Identified test scenarios, designed and executed test cases, and documented test results.

• Logged defects using Azure DevOps, performed defect retesting, regression testing and validation of fixes.

• Participated in the Change Control Board (CCB) process required for production rollout.

• Performed testing of the Greenwich application following cloud migration to an EC2 server.

• Conducted L1 interviews for ETL Testing activities. Technologies: Oracle SQL, SAP, Talend, UNIX, Azure DevOps, Postman, UI Testing, Functional Testing, Manual Testing, UI Automation with python selenium, AWS Cloud services, EC2, S3 Athena Clear Trail Technology, Hyderabad Quality Engineer Mar 2022 – Aug 2022 Project: Comtrail-NX

• Performed ETL testing and validated data from source (SRCE) to target (TRGT).

• Executed test cases, documented results and uploaded execution evidence in Test Collab.

• Performed test case writing, test execution, retesting and regression testing.

• Supported deployment of new releases and patches on probes as per project requirements. Technologies: Unix, Kafka, ETL Testing, Test Collab, Retesting, Regression Testing, Hadoop, HBase, RabitMQ EDUCATION

• Bachelor of Engineering Dnyanshree Institute of Engineering and Technology, Satara Aug 2016 – Jul 2019

• Diploma KBP Polytechnic, Satara Jun 2013 – 2016 AWARDS

• YMD (You Made a Difference) Award – Winner, February 2023

• Execution Excellence Award – Q1 2023

LANGUAGES

English Hindi Marathi

Contact this candidate