ETL & Database Test Engineer (SQL, Snowflake)

SREEKANTH REDDY

ETL & Database Test Engineer SQL Data Warehouse Snowflake ADF MS SQL Server Azure Contact No: +91-879*******

Email: ***************@*****.***

PROFESSIONAL SUMMARY:

Results-driven ETL and Database Test Engineer with 4+ years of experience in ETL testing, database testing, data warehouse validation, data migration testing, and end-to-end data quality assurance. Strong expertise in SQL, MS SQL Server, Snowflake, Azure Data Factory (ADF), Azure Blob Storage, and data warehouse environments.

Experienced in validating complex ETL pipelines, source-to-target mappings, transformation rules, business logic, incremental and full data loads, fact and dimension tables, Slowly Changing Dimensions

(SCD Type 1 and Type 2), data reconciliation, and data integrity across heterogeneous systems. Strong hands-on experience in developing complex SQL queries for data validation, identifying data discrepancies, performing root cause analysis, validating ETL workflows, and ensuring data completeness, accuracy, consistency, and integrity. Experienced in testing Azure Data Factory pipelines, validating Blob-to-SQL/Snowflake data movement, executing regression and integration testing, and managing defects throughout the testing lifecycle. Proven ability to collaborate with Data Engineers, ETL Developers, Business Analysts, Developers, and Product Owners to identify data issues, analyze root causes, improve test coverage, and deliver high- quality enterprise data solutions.

TECHNICAL SKILLS:

Testing:

Database Testing, ETL Testing, Data Warehouse Testing, BI/Report Testing. Data & Tools:

SQL, Python, Azure Data Factory, Azure Data Lake

Databases:

Oracle, Snowflake, MS SQL Server.

Reporting Tools:

Power BI, Tableau.

Bug Tracking & Management:

Jira, Azure DevOps (TFS/ADO)

Operating Systems:

Windows, UNIX, MacOS.

KEY COMPETENCIES:

Strong understanding of Data Warehouse Concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables)

Expertise in ETL Testing & Data Validation Techniques Experience in Database Testing

Knowledge of Cloud Data Platforms (Azure)

Strong analytical and problem-solving skills

Effective communication and team collaboration.

PROFESSIONAL EXPERIENCE:

ETL & Database Tester

Worked as a Software Test Engineer in Infosys.

EDUCATION:

MBA in 2020 from Narayana Institute of Management Sciences, Sri Krishnadevaraya University, Tadipatri, Anantapur.

BSc Computers in 2018 from Saraswathi Degree Collage, Sri Krishnadevaraya University, Tadipatri, Anantapur.

PROJECT-1

Project Name: Cloud Data Warehouse & ETL Validation Environment: Azure Data Factory, Azure Blob Storage, Snowflake, MS SQL Server, SQL, Azure DevOps, Jira

Roles & Responsibilities

Analyzed source-to-target mapping documents and designed comprehensive ETL testing strategies for data ingestion and transformation pipelines.

Validated data flow from MS SQL Server Azure Data Factory Azure Blob Storage Snowflake.

Created complex SQL validation queries to compare source and target records across SQL Server and Snowflake.

Validated source and target record counts, column-level values, data types, NULL values, duplicate records, and business transformations.

Tested ADF Copy Activities and Mapping Data Flows for successful data movement and transformation processing.

Validated full-load and incremental-load scenarios using timestamps, business keys, and incremental extraction logic.

Tested SCD Type 1 and Type 2 dimension processing and verified historical record maintenance.

Validated Snowflake fact and dimension tables against source systems and business requirements.

Performed data reconciliation and identified missing, duplicate, rejected, and incorrectly transformed records.

Validated pipeline parameters, datasets, linked services, triggers, dependencies, and error-handling mechanisms.

Tested invalid files, missing columns, incorrect data types, duplicate records, NULL values, and malformed source data.

Investigated ADF pipeline failures and worked with developers/data engineers to identify root causes.

Executed regression and end-to-end testing for new pipeline enhancements. Key Achievements

Improved ETL validation coverage by developing reusable SQL validation queries for common source-to-target checks.

Reduced manual data comparison effort by automating repetitive record-count and reconciliation validations.

Identified critical transformation and data-quality issues before production deployment, reducing production data defects.

PROJECT-2

Project Name: Enterprise Data Warehouse & ETL Testing Environment: MS SQL Server, SQL, ETL, Data Warehouse, SSMS, Jira

Roles & Responsibilities

Designed test scenarios based on business requirements, source-to-target mappings, and ETL specifications.

Validated data extraction, transformation, and loading processes across staging, integration, and data warehouse layers.

Developed complex SQL queries using joins, CTEs, subqueries, window functions, and aggregations for data validation.

Validated fact and dimension tables against source system data.

Tested primary keys, foreign keys, unique constraints, NULL handling, duplicate records, and referential integrity.

Validated transformation rules, derived columns, calculated measures, data cleansing, and business calculations.

Tested incremental data loads and verified new and changed records.

Validated SCD Type 1 and Type 2 dimensions and historical data preservation.

Performed source-to-target reconciliation and investigated data mismatches.

Tested ETL failure scenarios and validated rejected/error records.

Executed regression testing after ETL changes and production defect fixes.

Logged defects with supporting SQL queries and evidence and collaborated with development teams for resolution.

Contact this candidate