Preethi M

Overall 13.11 years of experience in IT, including 8 years in ETL, Big Data Hadoop, and Spark testing, and 6 years in Mainframe testing, I currently work as a Test Lead. I have 12 years of expertise in the US healthcare domain, specializing in HL7 formats and certified as an ISTQB foundation-level tester. My skillset includes extensive experience in manual and automated ETL testing, SQL querying, data warehousing, and Spark programming using Scala. Proficient in test management tools like HP ALM and JIRA, I excel in defect reporting, execution status reports, and documentation. I have strong problem-solving and communication skills, collaborating with cross-functional teams to ensure successful project delivery. Additionally, I bring expertise in healthcare consulting, risk management, and project implementation, along with a passion for driving business transformation.

Roles and Responsibilities:

• Lead the QA effort for ETL and data warehousing projects, ensuring the quality , reliability, and performance of the data solutions.
• Develop and maintain the overall ETL testing Strategy, encompassing test plans, test cases, test data, and automation frameworks.
• Manage and mentor a team of ETL testers, providing guidance, training and support.
• Collaborate with business analysts, data architects, developers, and project managers to understand project requirements and ensure alignment of testing efforts.
• Tested to verify that all data were synchronized after the data used Hive SQL to verify/validate my test cases.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Followed Waterfall and Agile development methodology and adhered to strict quality standards in requirement gathering.
• Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
• Worked on CSV, Json, Avro and TXT files.
• Prioritized projects and project tasks depending upon key milestones and deadline dates.
• Handled complex data from web API.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity and System.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data in Oracle Database.
• Analyses and understands ETL structural mapping and technical specification documents. Create test cases to perform Sanity, Functional, Regression, Database and ETL Testing.
• Analyse and report on complex data; both source and target systems to identify potential gaps in mapping documentation.
• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive data validation using SQL queries and back-end testing.
• Designs tests for ETL source data extraction, business transformation logic and target table loading.
• Involved with ETL test data creation for all the ETL mapping rules.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting.
• Document and publish test results, troubleshoot and escalate issues.
• Preparation of various test documents for ETL process in Rational tools.

• Date of Birth: 05/19/89
• Gender: Female
• Nationality: Indian