Data Quality & ETL Testing Quality Engineer

AJINKYA KORDE

Quality Engineer

PROFESSIONAL SUMMARY

Database Testing, Manual Testing, Functional Testing, Non-Functional Testing, Web Application Testing, and End-to-End Testing. Proficient in full SDLC and Defect Life Cycle management, Regression Testing, Sanity Testing, Smoke Testing, and UAT. Skilled in validating data pipelines across Medallion Architecture (Bronze, Silver, Gold) using SQL, Snowflake, Databricks, Azure Data Factory, Delta Lake, and Azure DevOps. Experienced in Agile/Scrum environments, designing test strategies, writing test cases, executing validations, reconciling source-target data, and tracking defects to closure. Proven track record ensuring accuracy, consistency, and reliability of analytical datasets for business reporting and governance.

SKILLS

Testing Types ETL Testing • BI Testing • Database Testing • DWH Testing • Manual Testing • Functional Testing • Non-Functional Testing • End-to-End Testing • Regression Testing • Sanity Testing • Smoke Testing • UAT • API Testing • Web Application Testing • Application Testing • Integration Testing • System Testing Testing Processes SDLC (Software Development Life Cycle) • Defect Life Cycle / Bug Life Cycle • Test Planning • Test Case Design • Test Execution • Defect Reporting & Tracking • Test Closure • Agile / Scrum Methodology • Sprint Planning Data & Cloud Tools SQL • Snowflake • Azure Databricks • Azure Data Factory (ADF) • Azure Synapse Analytics • Delta Lake • Delta Live Table • SSMS • Boomi • Informatica • OLTP • OLAP • DWH Testing • Medallion Architecture Tools & Platforms Azure DevOps • JIRA • Postman • Git • Selenium (Basic) Certification Microsoft Azure AI Fundamentals (AI-900) WORK EXPERIENCE

Quality Engineer — Greystar May 2023 – Present

Led data quality assurance for a large-scale real estate analytics platform, performing end-to-end testing across the full SDLC and managing defects through the complete Defect Life Cycle using Azure DevOps.

Performed end-to-end testing across Medallion Architecture (Bronze, Silver, Gold) layers ensuring data accuracy, completeness, and consistency.

Executed functional testing to validate business rules, data transformations, and pipeline logic against requirements.

Conducted regression testing after each pipeline change or bug fix to ensure no existing functionality was broken.

Performed sanity testing on newly deployed builds to quickly verify critical data flows before full test cycles.

+91-960******* ********.*****@*****.*** Amravati, India Experience: 3 Years 7 Months 6Results-driven Quality Engineer with 3.7+ years of experience across ETL Testing, BI Testing,

Validated ingestion and transformation pipelines from multiple Property Management Systems

(Yardi, Entrata, Lavanda) ensuring correct integration into analytical tables.

Executed data quality checks: duplicate record validation, null/invalid value checks, primary/composite key validation, and row-count reconciliation between source and target systems.

Tested Gold layer tables for business reporting covering property performance, leasing charges, payments, collections, and financial metrics.

Supported pipeline enhancement testing including new column additions, join logic changes, data type corrections, and duplicate-removal logic.

Followed complete Defect Life Cycle: raised defects in Azure DevOps, tracked status through New Assigned Fixed Verified Closed, and collaborated with Data Engineers for resolution.

Participated in Agile/Scrum ceremonies — sprint planning, daily standups, sprint reviews — to align QA efforts with delivery timelines.

Created and maintained test cases, test plans, and test summary reports for each sprint and release.

Quality Engineer — Exo Edge Feb 2023 – Apr 2023

Contributed to QA activities for web applications and ETL pipelines, covering manual testing, functional validation, and end-to-end data quality assurance across SDLC phases.

Performed manual testing and functional testing of web application modules against business requirements and design documents.

Conducted application testing and website testing to validate UI workflows, form validations, navigation, and cross-browser behaviour.

Executed non-functional testing covering compatibility, usability, and performance baseline checks for web modules.

Applied SDLC knowledge across all phases — requirements, design, development, testing, deployment, and maintenance — ensuring QA coverage at each stage.

Followed the complete Defect Life Cycle: logged defects in JIRA, tracked severity and priority, retested fixes, and ensured timely closure.

Executed SQL queries for data extraction and performed database testing to validate ETL pipelines.

Wrote and executed test data scripts based on ETL mapping artifacts for end-to-end data validation.

Created test strategies and test cases for applications with ETL components to ensure data integrity.

Performed data mining and analysis on data warehousing systems for accuracy and reconciliation.

Executed formal test plans and defined QA metrics to monitor defects, test results, and overall test status.

Verified reports and dashboards for content accuracy, axis labels, prompt filters, and drill-through links.

Prepared UAT and production readiness guides for ETL testing efforts. PROJECTS

Enterprise Data Marketplace — Real Estate Analytics Medallion Architecture

(Bronze, Silver, Gold)

Client: Greystar Domain: Real Estate, Finance & Operations Data Sources: Yardi, Entrata, Lavanda, Salesforce

This project evolved from foundational ETL/BI validation to end-to-end data quality assurance across a modern lakehouse architecture. Testing scope expanded progressively as the platform matured, covering all SDLC phases from requirements gathering through production readiness. Phase 1 — Requirements, ETL & BI Report Validation

Gathered and analyzed business requirements and design documents to define test scope and test strategy.

Applied SDLC practices to plan testing activities aligned with development milestones.

Created comprehensive test strategies, test cases, and test scripts for ETL components.

Executed functional testing to validate data transformation logic against business requirements.

Performed end-to-end testing tracing data from source systems through ETL layers to BI reports.

Conducted sanity testing and smoke testing on new builds before full regression cycles.

Executed SQL queries to extract and validate data; performed data mining on data warehousing systems.

Validated BI reports and dashboards: page titles, axis labels, aggregation levels, and prompt filters.

Verified drill-through links from summary to detail reports across charts, tables, and headings.

Cross-checked report data against source-of-truth transactional systems for reconciliation.

Defined and tracked QA metrics including defect counts, test results, and test status.

Managed full Defect Life Cycle — logged, assigned, retested, and closed defects in JIRA/Azure DevOps.

Phase 2 — Data Marketplace Validation (Bronze / Silver / Gold Architecture)

Performed end-to-end testing for real-estate data flowing through Bronze, Silver, and Gold layers of the Data Marketplace.

Conducted regression testing after every pipeline enhancement to verify no data issues were introduced.

Executed non-functional testing checks including data volume handling and pipeline performance baselines.

Validated ingestion and transformation pipelines from PMS systems (Yardi, Entrata, Lavanda) into analytical tables.

Executed data quality checks: duplicate record validation, null/invalid value checks, primary/composite key validation, and row-count reconciliation.

Tested Gold-layer tables for property performance, leasing charges, payments, collections, and financial metrics.

Supported pipeline enhancement testing: new column additions, join logic changes, data type corrections, and duplicate-removal logic.

Created and executed SQL validation scripts to enable early defect detection and reduce downstream data issues.

Logged and tracked defects in Azure DevOps (ADO); collaborated closely with Data Engineers on root cause analysis.

Performed regression testing to validate all pipeline fixes and changes before production deployment.

Prepared test summary reports and production readiness sign-off documents for each release. EDUCATION

Bachelor of Engineering (B.E.)

Sant Gadge Baba Amravati University, Amravati 2019 CERTIFICATION

• Microsoft Azure AI Fundamentals (AI-900) — Issued April 2025 Credential ID: A05AC0C3DF72DCF3

EXTRA-CURRICULAR ACTIVITIES

Knowledge Sharing

Conducted internal knowledge sharing sessions on SQL best practices, ETL validation techniques, test case design, defect life cycle management, and data quality checks to upskill team members and improve overall testing efficiency.

ADDITIONAL INFORMATION

Hobbies: Data Visualization, Technology Trends

Languages: English, Hindi, Marathi

Contact this candidate