Highlights

• Having 4.5 years of Experience in Software Testing by using ETL.


• Well acquainted with the Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC).


• Excellent understanding of Business Requirements & Functional Specification Document.


• Experience in Functional Testing, Regression Testing, Retesting, and UI Testing &


• Compatibility Testing of software Applications.


• Experience in Preparing Test Data, Test Cases. as per requirements and Executing Test scenarios.


• Experienced knowledge in using Test Management Tool JIRA.


• Involved in discussions like Bug Scrub and Defect Tracking Meetings along with Developers & Team Members.


• Proven track record of specializing in ETL testing with a focus on data accuracy, integrity, and performance.


• Extensive experience designing and executing comprehensive test plans for complex data integration and transformation processes.


• Implemented robust data validation and cleansing procedures, ensuring the reliability of enterprise data.


• Discuss solution when faced with data related issues that's coming from various Web Services


• and also frequently changing requirements.


• Advanced proficiency in utilizing industry-leading ETL testing tools such as [Query Surge, Informatica Data Validation Option (DVO), Apache JMeter], enhancing efficiency and effectiveness in the testing process.


• Familiarity with a range of data validation and verification tools to streamline testing workflows.


• Adept at collaborating with cross-functional teams, including developers, analysts, and data engineers, to ensure seamless integration and data consistency.


• Committed to staying current with industry trends and emerging technologies in ETL testing.


• Enthusiastic about incorporating innovative testing methodologies and tools to optimize testing processes.


• In-depth understanding of Informatica Power Center, Talend, Microsoft SQL Server Integration Services (SSIS), MySQL to facilitate comprehensive ETL testing.


• Extensive working experience in all phases of Agile-Scrum methodology.

Skills

Projects

Project 1. EagleBank - IT Industry (16 months)

Description: EagleBank is a community bank headquartered in Bethesda, Maryland, with assets of more than $10 billion, with operations in the Washington, D.C. metropolitan area. EagleBank conducts full service commercial banking through small footprint of 20 branches in Montgomery County, Maryland.





Roles & Responsibilities:






• Collaborate with business analysts and stakeholders to understand ETL requirements related to banking data.


• Develop and implement ETL test strategies, considering the unique requirements and challenges of the banking domain.


• Define test scenarios, test cases, and acceptance criteria based on banking data and regulatory requirements.


• Implement and execute data quality checks to identify and rectify anomalies or discrepancies in banking data.


• Ensure the accuracy, completeness, and consistency of financial data throughout the ETL process.


• Conduct performance testing to evaluate the speed and efficiency of data extraction, transformation, and loading processes.


• Optimize ETL workflows to meet performance requirements and minimize latency.


• Implement regression testing to ensure that changes or updates to ETL processes do not adversely affect existing functionalities.


• Validate backward compatibility of ETL systems with historical banking data.


• Verify adherence to banking regulations, compliance standards, and data security protocols.


• Collaborate with compliance officers to ensure ETL processes align with industry-specific regulations.


• Create comprehensive documentation of test cases, test results, and issues encountered during the testing process.


• Propose and implement improvements to ETL processes, tools, and methodologies to enhance efficiency and data quality.


• Identify and assess potential risks related to data integrity, security, and compliance within the banking domain.

Project 2. Jellyfish.com - IT Industry (23 months)

Description: Jellyfish.com was a reverse auction online shopping website. The Middleton, Wisconsin- based Company was acquired by Microsoft in 2007. On May 22, 2008, Microsoft officially announced the cash back service as part of their Live Search group of tools. The site was shut down at midnight, February 16, 2009.







Roles & Responsibilities:






• Establish robust error handling mechanisms to capture and log errors encountered during ETL processes.


• Implement protocols for error notification, resolution, and reporting in the context of e-commerce data.


• Analyze business rules, product catalog data, and customer information to create comprehensive test plans.


• Optimize ETL workflows to meet performance requirements and minimize latency in health insurance processes.


• Develop and implement ETL test strategies that align with e-commerce domain requirements.


• Define test scenarios, test cases, and acceptance criteria based on product data, customer transactions, and business rules.


• Establish robust error handling mechanisms to capture and log errors encountered during ETL processes.


• Conduct data profiling to understand the structure, content, and quality of e-commerce data.


• Validate ETL transformations to ensure the accuracy and consistency of product and customer data.


• Propose and implement improvements to ETL processes, tools, and methodologies to enhance efficiency and data quality in the health insurance domain.

Project 3. Celtic Insurance - IT Industry (19 months)

Description: Celtic is a leading national health insurance company providing healthcare solutions to individuals, families and the self-employed. We are dedicated to offering our customers health plans with better access to high-quality healthcare.





Roles & Responsibilities:






• Develop and implement ETL test strategies that align with health insurance domain requirements.


• Conduct data profiling to understand the structure, content, and quality of health insurance data.


• Validate ETL transformations to ensure compliance with healthcare regulations and standards, such as HIPAA.


• Optimize ETL workflows to meet performance requirements and minimize latency in health insurance processes.


• Collaborate with compliance officers to ensure ETL processes align with health insurance regulatory requirements.


• Implement and test security measures to protect sensitive health information during ETL processes.


• Establish robust error handling mechanisms to capture and log errors encountered during ETL processes.


• Collaborate with healthcare domain experts to validate that ETL processes align with specific health insurance workflows.


• Propose and implement improvements to ETL processes, tools, and methodologies to enhance efficiency and data quality in the health insurance domain.