Exclusive FY 2023-24 Year End Offer - upto 40% off | Hurry up - Offer valid till 31st March 2024
OnBenchMark Logo

P (RID : 1dtksl92gqkqq)

designation   ETL Engineer

location   Location : Bangalore

experience   Experience : 4 Year

rate   Rate: $13 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 146
Key Skills
ETL Testing SQL data warehousing JIRA
Discription

Professional Summary:

  • 3.2Years of experience in ETL Testing, using SQL and domain experience in Health Care and Pharmacy.
  • Experience in creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Extensive Experience in Manual Testing, Database Testing, ETL Testing.
  • Experience on Data warehousing / ETL Concepts, Database testing, Manual testing, writing positive and negative Scenarios and Test Cases for System.
  • Knowledge on Data Modelling using Star Schema and Snowflake Schema, slowly changing Dimension (SCD).
  • Domain knowledge on Health Care, Pharmacy.
  • Experience in different software development life cycle methodologies like Agile and Software Testing Life Cycle (STLC).
  • Knowledge on Scheduling and running the Workflows by using ETL tool and validating the session log.
  • Monitoring errors/tasks using Workflow Monitor.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Education Summary:

GRADUATION : Bhagwant University in 2018, Ajmer,(Raj).india.

Technical Experience:

ETL Tester

Tools : SQL Developer,JIRA,HP QA, WinSCP, Microsoft Office.

Databases : Oracle SQL.

Operating Systems : UNIX/LINUX, Windows 2007/XP/2008/2010

Professional Experience:

Working as a ETL Testing Engineer in Centurion Software Solutions, Jan 2019 to 2022

Project #1 :

Project Name: HUMANA

Role : ETL Tester

Environment: - Informatica Power Center, ORACLE SQL, .

Description:

HUMANA health insurance is one of the health care companies and it can access to health care varies across countries, groups and individuals, largely influenced by social and economic conditions as well as the health policies in place. Clients have multiple sources to load the Member information and their plans and eligibility in the DWH in order to analyze the Member information and their plans and services.

Roles and Responsibilities:

    • Create Test plans which insure that ETL batch perform the required data transformations and load as specified in the requirement documentation.
    • Most of the requirements are derived based on source to target mappings which is nothing but a document which specifies any business logic to perform while perform ETL operation.
    • create some data records which tests the boundary conditions of the logic defined
    • Create some failures in the record format to check if the ETL batches fail with correct error or log the error as expected per the design
    • check the resulted data to insure correct was of the data as per requirement
    • Involved in functional study of the application.
    • Identified Test Scenarios and designed test cases.
    • Involved in running the ETL jobs.
    • Prepared and run SQL queries to verify the data.
    • Interaction with BA and Dev teams to resolve the issues.
    • Designed Reviewed & executed Test cases.
    • Identified Test cases for Regression testing.
    • Logged the defects in Tracker for any of the issues that were noticed during the Stesting.
    • Testing the logics and code implemented in ETL mappings, User Acceptance Testing (UAT) and Verifying fixes on data issues.

Project #2:

Project Name: CVS. Role: ETL Tester

Environment: - ETL Test, ORACLE SQL Developer, WinSCP, Putty.

Description:

CVS health is one of the health care companies and it can access to health care varies across countries, groups and

individuals, largely influenced by social and economic conditions as well as the health policies in place. clients have multiple sources to load the Member information and there plans and eligibility in the DWH in order to analyze the Member information and there plans and services.

Responsibilities:

  • Involved in functional study of the application.
  • Identified Test Scenarios and designed test cases.
  • Involved in running the ETL jobs.
  • Prepared and run SQL queries to verify the data.
  • Interaction with BA and Dev teams to resolve the issues.
  • Designed, Reviewed & executed Test cases.
  • Identified Test cases for Regression testing.
  • Logged the defects in Tracker for any of the issues that were noticed during the testing.
  • Testing the logics and code implemented in ETL mappings, User Acceptance Testing (UAT) and verifying fixes on data issues.

(P.Ganesh)

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!