Debarpan Coari

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.

Senior Consultant at Absolutdata (2022-10 – Present)

• 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 at Cognizant (2021-06 – 2022-10)

• Recognized by the Expedia Product Team with a formal shoutout for excellence in designing and establishing a highly efficient Data Quality reconciliation framework.

Senior Software Test Engineer/ Associate at Accenture Solution Pvt. Ltd (2016-05 – 2021-06)

• 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.
• 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.

B.Tech – KIIT University (2016-05)