Ketan Patkar
Miami
Summary
Over 19+ years of experience in Information Technology Industry worked as a Quality Assurance Engineer and Test Lead/Manager, ETL Developer, Tech Lead and Project Manager who has the motivation to take independent responsibility as well as ability to contribute and be a productive team member. Specialized experience working on large scale Projects which involves Data warehouse (ETL), Data Migration, Data Validation Analysis, Reporting and Project Management activities. The domain areas of Banking, Healthcare, Finance, Telecommunications, Travel & Hospitality with proven track record of project implementation on multiple system environments.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Senior Associate / Manager- Projects
Cognizant Technologies Solutions US Corp
Miami
05.2014 - Current
- Collaborated with stakeholders to gather requirements for strategic initiatives.
- Analyzed data to support decision-making and identify trends.
- Designed and developed Informatica mappings for data loads, including Source Qualifier and Aggregator.
- Worked with ETL developers to create external batches using Informatica Workflow Designer for data integration.
- Data profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data.
- Reconciliation report preparation for data analysis.
- Perform unit testing, data validation at various levels of ETL.
- Ensure the overall process of testing is documented, and observations, bugs, and issues are logged and communicated to the team using Team Foundation Server (TFS), Azure DevOps Server, and JIRA.
- Provide production validation support, production release management, UAT, and integration testing.
- Review test cases and validate the queries (SQL).
- Preparation of test scenarios and test cases for functional testing, data validation.
- To perform testing in the System Integration testing environment.
- Prepare data validation scripts according to business logic and functionality using SQL scripts; automate the scripts for regression testing to ensure the coverage (DVO) – Data Validation Object from Informatica.
- Preparation of test cases and execution of test cases using the test management tool, TFS (Team Foundation Server) or ALM (Quality Center).
- Participate in progress reporting for the project, coordinating with various teams, and provide the traceability matrix and reporting.
- Conduct User Acceptance Testing coordination with the Business User and Development team.
- Responsible for E2E (end-to-end) testing for assigned projects/modules and integration.
- Conduct triage meetings, daily status meetings, and scrums.
- Analysis of SDLC (Waterfall or Agile Model) for any impact on the timeline of projects.
QA Lead / ETL Test Engineer
Wipro Technologies
India and USA
07.2005 - 05.2014
- Led quality assurance processes for software development projects at Wipro Technologies.
- Developed and implemented testing strategies to enhance product reliability and performance.
- Responsible for analyzing the requirements and providing high-level estimation.
- Provide estimations for testing efforts.
- Prepare test cases and scenarios according to business requirements and functional requirements.
- Prepare the test execution stack and plan according to complexity.
- Prepare test data according to the condition using TDM.
- Prepare data validation queries.
- Execute test cases in QC, and keep track of execution status.
- Report issues, observations, and defects to the project team.
- Prepare a requirement traceability matrix for end-to-end coverage.
- Raising defects and tracking defects using QC.
- Support user acceptance testing.
Education
Computer Science & Technology -
S.R.T.M.U. (MH-India)
India 05-2004
Skills
- Requirements gathering
- Data analysis
- ETL development and testing
- Data validation
- Quality assurance
- Effective communication
- Team collaboration
Certification
Reltio Multidomain Master Data Management Foundation
Timeline
Senior Associate / Manager- Projects
Cognizant Technologies Solutions US Corp
05.2014 - Current
QA Lead / ETL Test Engineer
Wipro Technologies
07.2005 - 05.2014
Computer Science & Technology -
S.R.T.M.U. (MH-India)