Resume

Name- Satish Darekar

Mobile No - +91-956******* Email: ad1lb7@r.postjobfree.com AWS Cloud Practitioner Certified

Objective

To associate myself with an organization that provides me an opportunity to enhance my skill and to contribute towards my personal and organization growth

Profile summary:

●8 years of experience in Software Testing with excellent exposure to ETL/DWH testing.

●Expertise in ETL/DWH testing, Database testing, Data validations, Functional testing, NoSQL, Cloud Data Migration Testing

●Strong proven experience in Quality Engineering for domains like Healthcare, Telecom, Airline

●Expertise in preparation of documents like Test plans, Test scenarios, Test cases and execution of the same

●Extensive Exposure to Data Analysis, Data Validation, Data Cleansing, Data Verification, and identifying data mismatch

●Experience in working with Azure services like CosmosDB, Azure service bus, Blob storage, Databricks and ADF

●Well versed in agile frameworks like Scrum, Kanban

●Good knowledge and experience of writing SQL queries and hands on experience in Database migration testing

●Involved in end-to-end data migration testing of RXI applications covering areas like data mapping, data validation, data completeness, cross reference, transformation rules, checking logs for debugging code with Talend ETL tool and Linux commands, data extraction, transformation and loading of data in data warehouse system

●Thorough hands on experience of software testing methodologies including ETL/DWH Testing, Integration Testing, Regression Testing, Functional Testing, Sanity testing, User acceptance testing support, Operational testing for an Application

●Good exposure to Test Management Tool Quality Center/ALM, JIRA

●Good knowledge and experience of SQL queries and hands on experience in Database testing.

●Effective co-ordination between development team and testing team

●Ability to handle multiple tasks and work independently as well as in a team

●Good understanding on Python Pandas

●AWS Cloud practitioner certified

●Training the new team members in the team

Professional Summary:

●Working with GLOBALLOGIC India pvt ltd. As ETL tester from May 2021 to present

●Worked with Saama technologies Pvt Ltd. as ETL tester from August 2020 to May 2021.

●Worked with Tata consultancy services as ETL tester from May'19 to August 2020

●Worked with Vodafone India (Payroll- Magna InfoTech) as Software Test Engineer from June’18 to April'19.

●Worked with eclerx services ltd as Sr.Analyst from Feb’15 to May’18

Technical Skills:

●Testing : DWH/ETL Testing, Manual Testing, Data Migration Testing

●ETL Tools : Abinitio, SSIS, Informatica Power Center 9.6, Talend

●Database : Teradata, Oracle 11g, MS SQL Server.

●Test Management & Other Tools : HP ALM, JIRA

●Languages : Python

●Operating System : Windows, UNIX.

●Reporting tool : SAP Business Object, Power BI

Academic Details

●Post graduate in Master of Computer Application from JSPM’s JICA, Tathawade, University-Pune

●Bachelor in Computer Application from NAC’s, Ahmednagar, University- Pune

Project 1:

Project: WBA RXI- Store Data Migration

Role: Lead ETL Tester

Description: This project includes store data migration of on premise to cloud based service. Client runs 8K+ pharmacy

retail outlets as well as several drug manufacturing and distribution companies. To migrate all the store data Talend jobs

and ADF pipelines has created to move store data from legacy system to Azure cosmos DB for further operational work

and analysis

Responsibilities:

Analyzing data transformation requirement and create test cases, test scripts, Test execution

Verify the data, source to target data load on scrum environment

Verify the pre and post migration data validation dashboard data reports]

Verify the data, source to target data load and end to end flow

Raise defects and attend the daily defect triage calls, regression testing

Attend daily scrum call, raise the issue/blockers for testing

Active participation in production store migration activity and support runops team to run jobs

Prepare production deployment manifest - Knowledge transfer to new dev and testing team members

Coordinating with client side developers and stakeholders

Identification of RCA of defect and helped dev team to fix the bugs

Technologies: Talend Open Studio, DB visualizer, Optimus, Service bus, kubernetes, ADF pipelines, DB2, Azure cosmos DB, Power BI, Panda, GIT, Azure blob storage explorer, Data bricks, Unix, winscp

Project 2:

Project US clinical stage biopharmaceutical company

Role: Lead ETL Tester

Technologies: SQL, PostgreSQL, LSAC Analytics- Yellowfin reports, JIRA

Description: Saama’s Life Science Analytics cloud provides out of the box analytics which provides insight into clinical

and operational data of clinical trials. Custom reports can also be built using the add-on module.

Responsibilities:

Analyzing data transformation requirement and create test cases, test scripts.

Verify the data, source to target data load

Verify the dashboard data reports

Log Defects, regression testing, smoke testing

Project 3:

Project: CDD On premise to Azure Cloud Migration (Airline domain)

Technologies: Cosmos DB (Azure), Databricks Azure Storage Account, Container, JIRA, Scala, SparkSQL

Role: ETL Tester

Description: This project was for migration of on premise to cloud service, all passenger data was coming into multiple

Files and all these data are loaded to cosmos db for further analysis/reporting.

Responsibilities:

Understand the user stories and create test scenarios, test cases and test scripts.

Validate the data loaded into cosmos DB using spark scala (databricks).

Logging defects in Jira.

Attend daily scrum call, and raise the issue blocker for testing.

Project 4:

Project: Informatica to SSIS Migration (Airline domain)

Technologies: SQL Server, SSIS, Informatica, Jira

Role: ETL Tester

Description:

This project was for migration of ETL tool, all existing Code/functionality of informatica was migrated to SSIS tool.

Multiple modules was part of migration to flight crew access, Passenger data, baggage, wheelchair service data etc.

Responsibilities:

Understand the user stories and create test scenarios, test cases and test scripts.

Understand the informatica code and SSIS code for creation of test cases.

Run the informatica and SSIS jobs for data compare.

Logging defects in Jira.

Attend daily scrum call, and raise the issue blocker for testing.

Testing performed on QA, and staging environment.

Project 5:

Project: IOT data integration to EDW

Technologies: AbInitio, HP Quality Center/ALM, Winscp, Teradata

Role: ETL Test Engineer

Description:

Building content subject area in EDW to support pre-defined and ad-hoc 4G and iot reporting and analysis for ER

account and their subscription product holding.

Responsibilities:

Analyzing and understanding the High Level Design Documents, Low Level Design and Mapping Documents.

Test scenario and Test script creation based on the given transformation logic and execution on the same

Getting the code deployed into the test environment

Run and monitor ETL end to end in UNIX environment.

Validation on target tables in Teradata

Test management, Defect logging and tracking in ALM.

Training the new members in the team.

Project 6:

Project: Multi- channel customer view

Database: Teradata

Tool used: AbInitio, HP Quality Center/ALM, Winscp

Role: ETL Test Engineer

Description: This project provide a consolidated view of customer interaction across retail customer service and digital

channels that enables us to meet business goals

Responsibilities:

Analyzing and understanding the High Level Design Documents, Low Level Design and Mapping Documents

Test scenario and Test script creation based on the given transformation logic and execution on the same

Getting the code deployed into the test environment

Run and monitor ETL end to end in UNIX environment.

Validation on target tables in Teradata

Test management, Defect logging and tracking in ALM

Training the new members in the team.

Project 7:

Project Name : Cox Communications

Client: Cox Communications, USA

Environment: Abinitio, teradata, QC, unix

Role: Test Analyst

Description:

Cox communication is a one of the third largest telecommunication company in USA. The goal of the project is to develop strong database technology that will extract and transform the customer’s data is collected load into DWH, to take proper decision in each level with proper data.

Responsibilities:

Understanding Requirement Specifications and Design Documents.

Involved in writing test cases and execution of test cases.

Running the Jobs/schedules for ETL process.

Verifying the data in target database after ETL process.

Testing has been done based on Change Requests

Experienced in writing complex SQL queries for extracting data from multiple tables.

Write SQL queries to validate that actual test results match with expected results.

Responsible for execution of ETL test cases.

Participated in regular project status meetings related to testing.

Prepared status summary reports with details of executed, passed and failed test cases.

Interacted with developers, Business & Management Teams and End Users.

I hereby declare that the above mentioned information and details provided by me are correct to the best of my knowledge.

Place -Pune Signature

Satish Darekar

Contact this candidate