ETL Developer with 7+ years in Data Warehousing & ETL Testing
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Senior ETL Test Engineer with 7+ years of experience in Data Warehousing, ETL Testing, and Data Validation across Healthcare, E-Commerce, Telecom, and Insurance domains. Strong expertise in SQL-based data validation, source-to-target mapping, data reconciliation, and end-to-end ETL testing. Hands-on experience with Informatica, Talend, SSIS, and Power BI validation. Proven ability to ensure data accuracy, integrity, and performance in complex enterprise data ecosystems.
Vels University
BE
August 1, 2013 – June 30, 2017
VisionQuest Solutions Private Limited
Senior ETL Test Engineer
February 1, 2019 – Present
India
ShopEase
August 1, 2025 – June 1, 2026
Validated end-to-end ETL pipelines for sales, customer, and product data. Performed source-to-target data validation across MySQL, MongoDB, and data warehouse tables. Executed data cleansing, transformation, and reconciliation checks to ensure data quality. Validated incremental and full load ETL workflows developed using Talend and SSIS. Verified Power BI dashboards for accuracy and consistency with backend data sources. Conducted ETL performance validation and supported optimization initiatives. Implemented and validated error handling, logging, and recovery mechanisms in ETL jobs. Designed and executed ETL test cases, SQL validation queries, and test execution reports.
Connecto Telecom
June 1, 2023 – July 1, 2025
Performed ETL testing and data validation for customer usage, complaints, and subscription data. Validated ETL workflows developed using Informatica and Talend. Executed deduplication and transformation validation to improve overall data quality. Performed data reconciliation across Oracle and SQL Server data sources. Validated analytical datasets used for churn analysis and predictive modeling. Monitored ETL jobs, identified failures, and supported timely issue resolution. Automated SQL validation scripts to enhance testing efficiency and accuracy. Prepared data dictionaries, source-to-target mapping documents, and validation reports.
MediTrack
April 1, 2021 – May 1, 2023
Validated ETL processes consolidating patient records from multiple source systems. Performed data standardization, transformation, and accuracy checks to ensure data integrity. Validated centralized data warehouse tables for reporting and analytics readiness. Verified healthcare KPIs and metrics in Power BI dashboards against backend data. Implemented and validated data quality rules, constraints, and exception handling. Collaborated with business and clinical teams to analyze and resolve data discrepancies. Ensured audit-ready documentation covering ETL workflows, data lineage, and compliance requirements.
HealthGuard Insurance
February 1, 2019 – March 1, 2021
Performed ETL testing for insurance claims, policy, and customer datasets. Validated ETL workflows developed using Informatica and Talend. Executed fraud detection and duplicate record validations based on defined business rules. Performed high-volume data reconciliation across multiple source and target systems. Validated claims dashboards and MIS reports for business accuracy and completeness. Automated daily, weekly, and monthly ETL validation checks using SQL scripts. Supported regulatory compliance and audit requirements by providing test cases, logs, and validation evidence.
Cultural Fit Analysis
The candidate has worked across four distinct industry domains (E-Commerce, Telecom, Healthcare, Insurance) within a single company, demonstrating adaptability and a broad understanding of different business contexts. This diversity of experience suggests a willingness to tackle varied challenges and integrate into different project cultures. The focus on data quality and compliance across these sectors indicates a strong commitment to best practices, which aligns well with a culture valuing precision and reliability. However, the lack of diverse company experience might indicate a preference for stability over varied organizational cultures.
Soft Skills & Operational Fit
The candidate's project descriptions indicate collaboration with business and clinical teams, issue resolution, and supporting optimization initiatives, suggesting a proactive and team-oriented approach. Experience with Agile/Scrum methodologies (Jira, Sprint Planning, Defect Tracking) points to good operational fit within structured development environments.