Mohan Kalyan

Quality Engineering Analyst with 5+ years of experience in Data Testing, ETL Testing, Data Quality Assurance, SQL-based validation, database testing, and enterprise data migration. Experienced in validating end-to-end data pipelines and data products across Healthcare, Telecom, Insurance, and Energy domains. Hands-on experience with AWS to Azure Databricks migration validation, Python-based test automation, source-to-target reconciliation, metadata validation, schema validation, business-rule verification, and data integrity testing.

Strong experience collaborating with Data Engineers, ETL Developers, Business Analysts, and stakeholders to identify, investigate, and resolve data-quality issues across SIT, UAT, regression, and production environments.

Quality Engineering Analyst at Infosys Ltd. (2021-06 – Present)

• British Petroleum (BP) – Data Migration Validation | Current Project
• Working on enterprise-scale AWS to Azure Databricks data migration, validating data pipelines and migrated datasets across source and target environments.
• Designed and developed a reusable Python-based data validation framework for automated end-to-end data-quality testing.
• Automated validation of record counts, duplicate records, null values, distinct counts, metadata, schema, and data reconciliation.
• Performed SQL-based source-to-target validation and reconciliation between AWS and Azure Databricks.
• Validated schema structure, column names, data types, nullable constraints, column counts, and other metadata attributes.
• Developed validation logic to identify data discrepancies and data-integrity issues during migration.
• Collaborated with Data Engineers to investigate migration failures, perform root-cause analysis, and improve data quality.
• Supported migration, regression, and production data validation activities across enterprise data environments.
• COLT Technology Services – ETL Testing & Data QA
• Performed end-to-end ETL and data validation for complex Telecom data-warehouse solutions.
• Validated File-to-DB and DB-to-DB ETL pipelines across multiple environments.
• Verified source-to-target mappings against business requirements, transformation logic, and mapping specifications.
• Developed advanced SQL queries for joins, aggregations, reconciliation, duplicate detection, and business-rule validation.
• Validated full-load and incremental-load ETL processes and identified data inconsistencies across source and target systems.
• Performed metadata validation covering schemas, keys, data types, constraints, column structures, and file layouts.
• Executed source-to-target reconciliation to verify data completeness, accuracy, consistency, and integrity.
• Used IDQE for data-quality profiling and business-rule validation.
• Created test plans, test cases, SQL validation scripts, execution reports, and test-summary reports.
• Collaborated with ETL Developers, Business Analysts, and stakeholders to investigate and resolve SIT, UAT, regression, and production defects.
• Executed ETL and Data Quality testing using SQL Server for healthcare data pipelines.
• Validated reporting-layer data and performed source-to-target reconciliation and backend database validation.
• Performed defect reporting and collaborated with project teams to resolve data-quality issues.
• Validated healthcare reporting data using SQL and performed ETL and data-integrity checks.
• Verified source-to-target data and business rules to ensure reporting accuracy.

B.Tech in Computer Science Engineering – Gayatri Vidya Parishad College, Visakhapatnam