Debarpan Coari
Kolkata
Summary
Results-oriented Data Quality Specialist with 10 years of IT experience, specializing in data profiling, rule creation, and monitoring using Collibra DQ. Proven track record of improving data quality by up to 30% through targeted ETL testing and data validation strategies. Led the optimization of data flows, reducing error rates by 20%, and ensuring 100% compliance with data quality standards across multiple projects. Adept at managing end-to-end data quality processes, delivering accurate, consistent, and trusted data that drives business decision-making.
Overview
1
1
Certification
10
10
years of professional experience
Work History
Senior Consultant
Absolutdata
Kolkata
10.2022 - Current
- Served as the primary liaison between EDMG and Loyalty teams; enabled the successful launch of the Loyalty Recon Dashboard through strategic coordination and cross-functional alignment.
- Developed and executed a comprehensive data quality management strategy for Expedia Group's data lake, enhancing governance and data trust.
- Led adoption initiatives for DQ tools by delivering impactful demos, Collibra training, and SQL workshops for both internal stakeholders and client teams.
- Conducted control gap analysis, root cause investigations, and tracked data quality trends to drive continuous improvement.
- Led data triage efforts and facilitated data quality workgroup sessions, conducting regular stakeholder reviews to ensure visibility and resolution of issues.
- Configured and monitored data quality rules, performed impact analyses, and managed reconciliation processes to align with observability standards.
- Implemented operational data quality checks and profiling using in-house platforms and Collibra DQ on cloud infrastructure, generating detailed, actionable reports.
- Created standardized policies, handbooks, and playbooks that institutionalized best practices, enhancing consistency across teams.
- Provided expert guidance to engineering teams and data consumers on scalable, effective implementation of data quality controls.
- Managed the enterprise data quality rules repository and evaluated industry trends in DQ tools and testing strategies.
- Conducted market research and vendor analysis; key contributor to the Valdio data quality tool assessment to inform strategic tooling decisions.
Associate
Cognizant
Kolkata
06.2021 - 10.2022
- Led end-to-end ETL testing processes, validating data flow from file ingestion through transformation to the presentation layer.
- Utilized Azure Databricks for data validation and orchestrated ETL pipelines with Azure Data Factory, enhancing testing efficiency.
- Executed attribute-level validation and transformation logic verification using advanced SQL queries to meet business requirements.
- Applied Slowly Changing Dimension (SCD) testing methodologies, ensuring historical data integrity in data warehouse.
- Performed data quality and completeness testing to ensure consistency, standardization, and adherence to business rules.
- Leveraged Azure Storage Explorer to inspect and validate Parquet files for data completeness and accuracy.
- Authored and executed complex SQL queries to test business-critical datasets and transformations.
- Led team with direct client engagement, aligning test strategy and enhancing communication for improved delivery quality.
- Awarded Best Performer at Cognizant for consistently delivering impactful solutions that drive significant client business outcomes.
Senior Software Test Engineer/ Associate
Accenture Solution Pvt. Ltd
Pune
05.2016 - 06.2021
- Handled large volumes of data in Hadoop using Putty for file management and workflow triggering.
- Converted complex business logic into SQL queries with Teradata Studio to visualize data flow.
- Identified and tracked defects using HP ALM, supporting developers through additional testing efforts.
- Wrote and executed optimized test cases to reduce manual effort in testing processes.
- Utilized Storage Explorer to read Parquet files for data analysis.
- Debugged code by reviewing configuration files and logs to locate root causes of issues.
- Operated under Agile and Scrum frameworks, delivering releases biweekly with organized sprints.
- Successfully deployed multiple work packages in production for OLAP applications.
Education
B.Tech - Bhubaneshwar
KIIT University
Bhubaneshwar05-2016
Skills
- Data quality management
- Data quality tools
- Collibra DQ
- Data profiling
- Data cleansing techniques
- ETL testing
- SQL querying
- Data Testing
- Data warehouse testing
- Root cause analysis
- Big data technologies
- Hadoop and Hive
- ETL technologies
- Data Visualization Testing
- Tableau
- Qlik sense
- Power BI
- Agile methodologies
- Jira and ALM
- Unix
- Project & Team management
Accomplishments
- Awarded Best Performer at Cognizant for consistently delivering impactful solutions that drive significant client business outcomes.
- Honored with the On-the-Spot Award at Infogain for successfully proposing and implementing a process improvement that resulted in cost savings in Data Quality rule deployment.
- Recognized by the Expedia Product Team with a formal shoutout for excellence in designing and establishing a highly efficient Data Quality reconciliation framework.
Certification
AZ 900
Timeline
Senior Consultant
Absolutdata
10.2022 - Current
Associate
Cognizant
06.2021 - 10.2022
Senior Software Test Engineer/ Associate
Accenture Solution Pvt. Ltd
05.2016 - 06.2021
B.Tech - Bhubaneshwar
KIIT University