Omkar Karlekar

Background

About Omkar Karlekar

With 4+ years of experience as ETL Test Analyst, I have demonstrated expertise in leveraging various Azure services to perform End-to-end data validations. Proficient in conducting various types of testing – Smoke, Functional, Regression, Integration in various test environments, identifying defects and collaborating with cross-functional teams to achieve project goals. Skills:• ETL/DWH Testing, SQL. • Azure Cloud Services (DP203 Certified): Data Factory, Databricks, DevOps. • Python, PySpark. • Agile Methodology. • Jupiter Automation Tool. • Functional testing, E2E Data flow testing.• Test case design and Execution• Data pipelines execution and monitoring• Database: SQL Server, Oracle.I have been involved in -Understanding the business requirement and contributing to writing, reviewing and execution of test cases -Executing and monitoring end-to-end data pipelines to extract test data from Upstream systems using Data factory-Creating complex SQL queries for E2E data validations using Azure Databricks Notebook-Performing Reconciliation, Defect retesting, Functional & Regression testing-Raising and managing defects in Azure DevOps -Participating in standups & sprint meeting-Effectively communicating and coordinating with various cross functional teams for bug resolution.Highlight• Received ‘Cheers Team Award’ for contributions to project testing -Utilizes Jupiter Automation Tool to Perform validations between source in different databases agaist target in Data Lake, Parquet file format. Reduced overall time required to perform validations by 75%Certifications: 1. Microsoft Certified Azure Data Engineer (AZ-900, DP-900, DP-203) 2. Databricks Certified Data Engineer Associate 3. Academy Accreditation- Generative AI Fundamentals 4. Complete SQL Bootcamp by Udemy