Summary
Overview
Work History
Education
Skills
Timeline
Generic
Satish Kumar

Satish Kumar

ETL QA LEAD/DATA ANALYST
Hyderabad

Summary

  • Seasoned IT Leader with 14+ years of comprehensive experience in ETL testing, automation of ETL Testing, Data Analysis, Quality Assurance, driving excellence in data management and validation.
  • Designed Automation Frameworks, using SQL, PL/SQL, Excel, and Python, reducing execution time by 85% and enhancing productivity
  • Expert Data Analyst, transitioned seamlessly from ETL Tester to Data Analyst by delivering high-impact insights benefiting decision-making processes.
  • Pioneer in Trade Promotion Analytics (TPA) domain, with expertise in reconciling end-to-end KPIs and managing global data sources like Nielsen, EPOS, and IRI
  • Hands-on UAT experience supporting users and resolving data issues at client locations, including Sweden.
  • Proficient in Data Tools including Azure, SQL Server, Pentaho, PowerBI, Oracle, and Python, ensuring robust data integration, analysis, and reporting capabilities.

Overview

14
14
years of professional experience

Work History

Senior Tech Lead – QA

Celsior Technologies Pvt Ltd
07.2024 - Current
  • Developed automation templates for semi-structured file ingestion, and end-to-end data verification.
  • Designed a Python/SQL automation framework, reducing the validation cycle from 8 hours to 1 hour, and enabling 600+ automated test cases.
  • Built Power BI dashboards visualizing daily ETL validation results, which provide an instant status of all the quality checks.

Business Data Analyst

SAAMA TECHNOLOGIES (I) LTD
05.2021 - 06.2024
  • Performed data analysis and data profiling to derive actionable insights, and support strategic decision-making.
  • Performing end-to-end reconciliation from the source of truth and final TPA dashboards to ensure the data's correctness.
  • Worked closely with stakeholders to define KPIs and business logic.
  • Involved in UAT at the client location in Sweden, supporting users, clarifying data gaps, and addressing data issues to provide them with a seamless product UAT experience.
  • Writing effective SQL queries to check the complex business rules, and hands-on experience in Python for data reading and analysis purposes.

ETL Test Lead

SAAMA TECHNOLOGIES (I) LTD
01.2015 - 04.2021
  • Led a 9-member team in end-to-end ETL validation for TPA analytics, ensuring 99.9% data integrity.
  • Designed and executed test strategies, scenarios, and scripts, ensuring alignment with business requirements and client expectations.
  • Designed automation frameworks with a combination of SQL and Python, reducing manual effort by 85%.
  • Conducted root cause analysis for production issues, implementing corrective actions to improve data accuracy and system reliability.
  • Coordinated cross-functional teams to optimize ETL processes and improve data integration workflows.

Senior ETL Tester

SAAMA TECHNOLOGIES (I) LTD
05.2011 - 12.2014
  • Analyzed business requirements and translated them into detailed test cases for execution.
  • Conducted in-depth testing of ETL workflows and data transformations.
  • Initiated and developed the automation of the ETL testing framework, and automated 2,500 test cases; the automation test scripts executed and fetched the results within 20 minutes.
  • Prepared the PL/SQL procedures to test different test scenarios and store the test results in audit tables.
  • Led data reconciliation efforts, ensuring seamless integration between claim applications and data warehouse systems.
  • Collaborated with development teams to optimize ETL processes and enhance data transformation efficiency.
  • Improving quality, user experience, and efficiency of operations through agile delivery and best practices.

Education

Bachelor of Arts -

Andhra University
Visakhapatnam, India

Skills

ETL Testing

undefined

Timeline

Senior Tech Lead – QA

Celsior Technologies Pvt Ltd
07.2024 - Current

Business Data Analyst

SAAMA TECHNOLOGIES (I) LTD
05.2021 - 06.2024

ETL Test Lead

SAAMA TECHNOLOGIES (I) LTD
01.2015 - 04.2021

Senior ETL Tester

SAAMA TECHNOLOGIES (I) LTD
05.2011 - 12.2014

Bachelor of Arts -

Andhra University

Similar Profiles

CREATE PROFILE
Satish KumarETL QA LEAD/DATA ANALYST