Quality Assurance Data Warehouse

DIVYA SANTHOSH

E-mail : *********************@*****.***

Mobile : 91-996*******

PROFESSIONAL SUMMARY

Results-driven ETL Test Architect with over 14 years of experience in software engineering, specializing in data warehouse technology and quality assurance. Expert in designing and implementing comprehensive testing strategies to ensure the integrity, performance, and reliability of ETL processes. Adept at leading QA teams to deliver high-quality solutions that meet stringent business requirements. Proven track record of improving data quality and process efficiency through innovative testing frameworks and methodologies.

CORE COMPETENCIES

ETL Testing & Validation

Data Warehouse Technology

Quality Assurance & Control

Test Automation & Scripting

Data Quality & Governance

Team Leadership & Collaboration

Leadership

PROFESSIONAL EXPERIENCE:

Senior ETL Consultant - Deloitte Consulting Services India Pvt Ltd. [16/08/2021 – 24/0/2024]

Senior Test Consultant - Deloitte Consulting Services India Pvt Ltd (CTH)

Payroll- Source One Management Services Pvt Ltd. [Feb 2021 – Aug 2021]

Roles & Responsibilities:

Architect and oversee comprehensive testing strategies for ETL processes, ensuring data accuracy, completeness, and consistency in large-scale data warehouse projects.

Develop and maintain automated test scripts using tools such as Python to streamline the testing process and improve efficiency.

Collaborate with data engineers, analysts, and business stakeholders to understand data requirements and design test cases that validate ETL workflows.

Implement performance testing to identify and resolve bottlenecks, ensuring optimal data processing speed and system scalability.

Lead a team of QA engineers, providing mentorship and guidance to foster a culture of quality and continuous improvement.

Key Achievements:

Spearheaded the implementation of a new automated testing framework, reducing testing time by 40% and increasing test coverage.

Improved data quality by 35% through the development of rigorous validation protocols and data cleansing routines.

Successfully managed the QA aspects of a critical data migration project, ensuring zero data loss and minimal downtime.

Software Engineering Team Lead - Accenture Services Pvt. Ltd. June 2015 – September 2018

Roles & Responsibilities:

Designed, developed, and optimized ETL processes to support data warehousing and business intelligence initiatives.

Collaborated with data scientists and analysts to understand data requirements and translate them into technical solutions.

Utilized ETL tools such as SSMS, and Datastage to extract, transform, and load data from diverse sources.

Implemented data cleansing and transformation rules to ensure data integrity and consistency.

Monitored and troubleshoot ETL processes to resolve issues and maintain data pipeline reliability.

Key Achievements:

Improved ETL process efficiency by 35% through automation and process optimization.

Played a key role in the successful deployment of a new BI platform, enhancing data accessibility and visualization capabilities for stakeholders.

Developed comprehensive documentation and training materials, improving team productivity and knowledge sharing.

Senior Associate - Cognizant Technology Solutions, Chennai – Jan 2007 to June 2015

Roles & Responsibilities:

Designed and executed test plans for ETL processes, focusing on data integrity, performance, and security.

Utilized SQL and scripting languages to develop and automate test cases, improving the efficiency and accuracy of the testing process.

Conducted thorough data validation and reconciliation to ensure the accuracy of data loads and transformations.

Collaborated with development teams to identify and resolve defects, ensuring the timely delivery of high-quality software.

Produced detailed test reports and documentation to track progress and support continuous improvement.

Key Achievements:

Increased defect detection rates by 25% through the implementation of a risk-based testing approach.

Played a key role in the successful deployment of a data warehouse project, contributing to a 20% improvement in reporting accuracy.

Developed training materials and conducted workshops to enhance the QA team’s skills in ETL testing and data quality management.

Technical Skills:

Programming Languages: SQL, Python (Basics)

ETL Tools: DataStage, Cognos, Informatica, Talend

Testing Tools: HP ALM

Databases: Teradata, My SQL, SSMS

Cloud Platforms: Azure, DevOps

Projects:

Data Warehouse Quality Assurance Framework

Architected a comprehensive QA framework for the company’s data warehouse, integrating automated testing and validation processes.

Improved data reliability and accuracy by implementing stringent data quality checks and validation protocols.

ETL Performance Optimization Project

Led the performance testing and optimization of critical ETL processes, identifying and resolving performance bottlenecks.

Enhanced data processing speed by 30% through targeted optimizations and efficient resource utilization.

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (Electrical and Electronics) – Aarupadai Veedu Institute of Technology, Chennai (2002-2006)

CERTIFICATIONS

Oracle 9i certified Professional

Teradata Certified Professional

Certified Professional in Data Warehousing Concepts

Contact this candidate