omkiran omkiran

ETL Test Engineer

India 8+ yrs exp 90 · Outstanding

About

ETL Test Engineer with 5.4 years of experience in Software Testing, specializing in ETL/DWH, BI, and Database Testing. Strong expertise in Test Case Design, Test Execution, Defect Tracking, and Data Validation. Hands-on experience with ETL tools like Informatica PowerCenter, Azure Data Factory, and Azure Data Bricks. Proficient in SQL, Data Warehousing concepts, and Data Quality validation.

Skills & Expertise (43)

Azure Data Factory Advanced

8.5/10

Years Exp

Snowflake Advanced

8.2/10

Years Exp

SQL Advanced

8.1/10

Years Exp

ETL Testing Advanced

8.0/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Functional Testing Azure DevOps TestRail Power BI Tableau Qlik Sense Selenium Data Warehouse Testing DataBase Testing Data Migration Testing Apache Airflow Regression Testing smoke testing System Integration Testing User Acceptance Testing API Testing Defect Management Test Case Design Execution Hive UNIX Windows Advanced SQL Oracle SQL PySpark Shell Scripting Oracle 21c Microsoft SQL Server Teradata Jira Azure SQL Database Informatica PowerCenter Azure Data Bricks SSIS Talend Data Integration AWS Glue LINUX Microsoft Azure

Work Experience

Senior ETL Test Engineer

Wipro Pvt Ltd

Mar 2021 - Present

Validated ETL processes for clinical, research, and patient datasets integrated into the enterprise data warehouse to support analytics and reporting. The scope included validating ingestion pipelines from SAS DI, clinical applications, and research systems into Snowflake through Azure Blob and Informatica IDMC. Performed end-to-end validation across staging, transformation, and warehouse layers to ensure data accuracy and consistency.

ETL Test Engineer

HSBC

Feb 2023 - Aug 2024

Validated data ingestion from various banking systems into Azure Data Lake using Azure Data Factory, followed by large-scale transformations in Azure Databricks. Ensured accurate tax data aggregation, reconciliation, and compliance reporting as per FATCA and CRS regulatory standards.

ETL Test Engineer

UnitedHealth Group

Mar 2021 - Jan 2023

Validated ETL workflows for healthcare insurance claims, patient, provider, and financial data integrated into the enterprise data warehouse. Ensured data accuracy, consistency, and HIPAA compliance while supporting insurance analytics and operational reporting.