sathish s
ETL/BI/API Tester
About
Having 6+ years of experience in ETL and BI Testing. Experience in writing complex SQL queries, ability to determine the types of testing. Had experience testing multiple test phases in medium to large projects. Had adequate experience and clear understanding of data warehouse and data mart testing. Identification & Test Data Preparation Techniques & Proficiency with Test Case Preparation & Execution. Thorough knowledge of Software Test Life Cycle, Defect Life Cycle etc. Extensive exposure to Back End / ETL testing with high-level SQL skills is required. Possess experience in using Informatica, Azure Data Factory with experience in data analysis. Defect tracking experience (i.e., Jira, HP- ALM, etc.) Experience in data validation, including completeness, accuracy, duplicate checks, and source-to-target validation across ETL data pipelines Excellent knowledge in Python scripting for data validation between file to file and file to Database. Ability to multi-task and adapt quickly to changes while maintaining urgency in completing tasks.
Skills & Expertise (21)
Work Experience
Senior Test Engineer
Agreeya Solutions
Jan 2025 - Nov 2025
Involved in analyzing the Data Specification, mapping and report requirement documents. Participated in preparing test cases, script design for validating the data in different layers. Designed & Executed test cases and Prepared test data for testing. Analyzing ETL mappings to prepare SQL queries for validation between all the different layers. Verifying the data in target database and also between different layers after ETL process. Coordinating with the development team and Onsite coordinator. Created Test Plan, Test Requirements, Test Cases as per the client requirements. Working closely with the BA and developers to attain the user requirements. Validated Reports in Power BI for user interface checks and ETL validations of KPIs on Dashboard.
Senior Analyst
Ventas Softech Pvt Ltd
Apr 2022 - Dec 2024
Analyzing the Mapping Document and finalizing test scenarios. Involved in mapping document walk through calls with BA Team. Preparing and Running SQL Queries to verify Data. Comparing Record Counts of Source and Target. Verifying End to End validation between Source and Target Data. Sending Daily Test Status reports to Test lead. Performed ETL data validation in Snowflake by executing SQL queries to verify source-to-target data accuracy, completeness, transformation logic, and record counts. Attending Daily Standup Meetings, Sprint Planning Meetings, and Sprint review meetings.
Senior ETL Tester
Bizkrieg solutions
Aug 2019 - Mar 2022
Understanding the requirements from BA in grooming sessions. Preparing test cases and test scripts for Functional testing. Performed Different kinds of testing like Functional testing, Smoke testing and Regression testing’s. Preparing and executing Test Cases to validate source and Target data. Participated in Daily Status calls and Meetings conducted by the team management and Scrum master. Defect Analyzing and Reporting in Jira. Interactions with BA & Dev teams to resolve the issues. After testing giving demo to the clients of new functionalities.
Process Executive
Cognizant Solutions
Jul 2017 - Apr 2018
Understanding the requirements from BA in grooming sessions, Preparing test cases and test scripts for Functional testing. Performed Different kinds of testing like Functional testing, Smoke testing and Regression testing, UAT testing. Using HP-ALM tool to log all the QA activities like writing test cases, Execution, Bug reporting, raising the bugs. Participated in Daily Status calls and Meetings conducted by the team management and Scrum master. Training end users and grooming the team members according to their modules. Tracking the reports in HP-ALM on daily and weekly bases to calculate the complete team efforts. After testing giving demo to the clients of new functionalities.
Education
Master of Business Administration (MBA) - Osmania University
- 2016 · Afghanistan
Bachelor of Science (B.Sc.) - Kakatiya University
- 2014 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (21)
Click a skill to find developers with the same skill