Rajkumar Ladia

ETL MDM Quality Engineer Automation Lead

P3 Saint Marc Circle

South Windsor CT,06106

+1-959-***-****

14+ years of IT experience in Analysis, Design, Operations, Manual/Automated ETL/MDM Testing,Production Support and Service Delivery Mgmt Projects .8+ years of Quality Engineering exp with specialization in across Master Data Management, Data Warehouse& Business Intelligence applications

Leading the automation and innovation space in the Quality Engineering space for Accenture and actively involved in implementing automation for all ETL processes and Real time Web Services.

Expert in testing of Master Data Management processes and Extract Transform and Load (ETL) processes,Real Time/NRT Web Services with strong working experience in Data Analysis, maintaining Data Quality/Data Integrity, Data validation in Data Warehouse/MDM.

Deep understanding of Master data management processes like Standardizing, Match/Merge and Survivor ship rules with hands- on experience on location data.

Have experience as the ETL QE Lead on Big Data integration project for a major Insurance company, providing end to end testing solution for ETL segment of the project in Big Data and Teradata Environment.

Successfully handled a team of 35+ associate in Onsite/Offshore model including 5+ years of onshore experience (USA) Academic Background:

Bachelor of Engineering Computer Science, 2002– 2006 Expertise

• ETL Data warehouse Functional Testing

• MDM ETL Testing

• Soap/Rest API/Webservices Testing

• ETL Testing

• Snowflake,AWS

• Hive Teradata, Unix,Oracle Pl/SQL

• Business Requirement analysis/Project Management

• Automation Testing

Certifications

• Snowflake Pro Core Certification

• ITIL Foundation 2011

• Oracle PL/SQL Developer Certified Associate

Awards

• Employee of the Month- Cisco,Accenture Celebrate Excellence Award, Accenture Appreciates – Best Performer - Offshore Experience

MDM ETL QE Automation Lead – Certified Business (2018-Present)-Accenture

Leading the automation and innovation space in the Quality Engineering space for Accenture and actively involved in implementing automation for all ETL processes and Real time Web Services.

Handled overall Test Delivery for MDM Project along with driving defect management calls for various releases and QA Status Reporting to the Leadership and Client Team

Soap UI testing for Near Real Time and Real Time Microservices.

Hands on for testing of Master Data Management processes and Extract Transform and Load (ETL) processes,Real Time/NRT Web Services with strong working experience in Data Analysis, maintaining Data Quality/Data Integrity, Data validation in Data Warehouse/ MDM.

Co-ordination and planning of Integration/Regression testing with upstream and downstream partners .

Worked on CICD pipeline creation for Automating Regression of Batch Processes/Real time Services

Trained on AWS, Databricks and Snowflake Cloud Technology with hand-on Lab. ETL QE Lead – Contact Centre Data Product/Location Intelligence(2015-2018)-Accenture

Participated and Approve requirements and design specifications, technical documents, source to target mapping documents and other related documentation from testing perspective.

Created Test Strategy, Test Plan/Cases/Data and Test Scripts to validate source/target data.

Incorporate UAT test cases into testing. Provide support to business during the UAT phase.

Soap UI testing for all microservices for Location Detail Viewer Application(LDV)

Estimate the efforts required to design the test cases and execute the project.

Responsible for reviewing of test plans for team members to ensure high quality deliverables

Defect Tracking through HP ALM Quality center and provide test reports and Metrics to client.

Worked on Partitions & Buckets in Hive and designed Managed/External tables in Hive to optimize performance.

Worked on writing complex and efficient SQLs on huge volumes of data across different technology Production Support Delivery Lead /QE Analyst –Quote to Order -TCS

Project Lead with IT Production Support Team of Q2O Team of 35 members.

Effort estimation and E2E project delivery.

Debugging of procedures, packages & other Oracle objects for solving issues.

Problem management for prioritization of on-going issues and LTF planning.

Preparation of management reports/metrics and reviewing with client regularly

Gather Business requirements provided by Business Analysts and Business Owners.

Work with Developers and System Architects to decide on the feasibility of requirements

Analyzing current system to determine defects and risks in the normal system functioning.

Test case/data preparation, execution and verification of the test cases.

Participated in Smoke and UAT testing and provide metrics of testing reports to clients.

Contact this candidate