Prashanth Chandroth

Senior Etl Data Qa Analyst @Enercare Inc.

Markham, ON, CA

Currently working on the Data Migration project, responsible for migrating data from legacy systems and enabling the integration of Salesforce CRM and Zuora Billing systems.o Collaborating with stakeholders to analyze ETL requirements, including data mapping, transformation rules, and business logic for legacy systems.o Identifying and prioritizing critical ETL test cases based on key data processes and transformations.o Conducting comprehensive data profiling on source systems to assess data quality, uncover anomalies, and address challenges in the ETL workflow.o Designing and executing detailed ETL test cases, ensuring accurate data extraction, transformation, and loading.o Overseeing the seamless integration of Salesforce with Amdocs Clarify (legacy CRM) and Zuora Billing systems.o Ensuring data consistency and accuracy by comparing Salesforce data loads against legacy system data.o Validating the completeness and integrity of data throughout each ETL stage.o Enforcing data rules to ensure compliance with expected formats, standards, and business requirements.o Developing custom stored procedures and SQL queries to perform pre- and post-load data comparisons, leveraging SSIS packages for efficient testing.Environment: Azure DevOps/ADO, SQL Server, SSMS, AWS, SSIS, Salesforce Sales Cloud, Zuora Billing