OnBenchMark Logo

Sasidhar (RID : 1dtksl92fmpl5)

designation   Software Test Engineer

location   Location : Andra Pradesh

experience   Experience : 6 Year

rate   Rate: $16 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

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

Professional Summary:

  • Having around 4.3 Years of experience in ETL/DWH/MDM testing with Data Analysis
  • Extensive knowledge on Data Warehousing concepts & ETL process
  • Worked on Healthcare, Insurance, Retail domains mainly involved in Functional/Regression Testing/Data Analysis
  • Experience in Data Analysis and Test Plan Preparation.
  • Good Experience in Exact and Fuzzy match rules analysis.
  • Experience on JIRA.
  • Experience on MDM tool (Reltio).
  • Hands on experience in SQL Queries to validate all the data scenarios.
  • Involved in Preparing, Reviewing and Executing Test Cases.
  • Good knowledge of Defect Logging, Tracking and Analysis.
  • Basic Knowledge on UNIX
  • Ability to handle multiple tasks and work independently as well as in a team

Work Experience:

  • Associated with LKQ India Pvt Ltd, Bangalore as a Software Test Engineer from July-2018 to till Date.

Education:

  • Post-graduation completed from SV University in 2015.

Technical Skills:

  • Testing : ETL/DWH/Data Testing
  • ETL : Informatica 8.6.2/9.1
  • RDBMS Packages : Oracle 9i/10g
  • MDM Tools : Reltio
  • Data Access Tool : Oracle, SQL Server
  • Operating Systems : Windows 2000/XP/NT/7 and UNIX
  • Languages : SQL
  • Test Management Tool : JIRA

Project Summary:

1) PROJECT NAME

Client

Santen

Solution Environment

Informatica, SQL and Unix

Role

Individual contributor

MDM Tool

Reltio

Description:

This ETL testing performed to test EDW Data Warehouse process that loads the source systems files (STI,TSA,XPO,HCRS,CRMMI) from various source system and this source files are moved to staging Queue(S3) , And its loaded into UI after match/merge based on MDM rules data will generate a OV values. After this process through ETL jobs OV records will extract.

Responsibilities:

  • Requirement Analysis
  • Involved in preparation of Test approaches
  • Involved in Data analysis and SPEC writing
  • Coordination with onshore team for addressing offshore issues
  • Reviewing all offshore artifacts(Test plans & results)
  • Test plan preparation with detailed test cases using SQL Queries
  • Execution of Test Cases (Oracle, SQL server)& results documentation
  • Identifying test cases for Regression testing
  • Defect Analyzing and Reporting in QC
  • Attending daily standup meetings

2) PROJECT NAME

SIQP (Sales Incentive Quota Performance)

Client

UCB

Solution Environment

Informatica 9.5, Oracle 11g, Unix

Role

ETL Tester

Description:

This ETL testing performed to test EDW Data Warehouse process that loads the source systems files (DDD,DDDMD,XPO,HCRS,CRMMI) from various source system and this source files are moved to staging Queue(S3) , And its loaded into UI after match/merge based on MDM rules data will generate a OV values. After this process through ETL jobs OV records will extract.

Responsibilities:

  • Requirement gathering and analysis
  • Involved in Data Profiling, Data analysis and SPEC writing
  • Involved in preparation of Test Plan with approaches
  • Coordination with onshore team for addressing offshore issues
  • Technical walkthrough’s for offshore team
  • Preparing daily workloads for the offshore team
  • Reviewing all offshore artifacts (Test Cases& results)
  • Test plan preparation with detailed test case’s using SQL Queries
  • Execution of Test Cases & results documentation
  • Defect Analyzing and Reporting in QC
  • Attending daily standup meetings
  • Presenting DEMO’s to the client every sprint ending day

3) PROJECT NAME

HC278 - Care Management System Replacement(CMSR)

Client

BCBSNC

Solution Environment

Informatica Power center, My SQL assistance and Unix

Role

Individual contributor

Description:

The goal of this project is to replace the current Care Management system of BCBSNC, MaxMC. BCBSNC has entered into a Vendor agreement to replace MaxMC with Trizetto’s Care Advance Enterprise (CAE). The CAE application comprises of the following components:

CCA – Clinical Care Advance (Access to Nurses/Business Users)

CAP – Care Advance Provider (Access to Providers for Authorization and Referral data)

PCA – Personal Care Advance (Access to Members)

Responsibilities:

  • Requirement Analysis
  • Involved in preparation of Test approaches
  • Involved in Data analysis and SPEC writing
  • Coordination with onshore team for addressing offshore issues
  • Reviewing all offshore artifacts(Test plans & results)
  • Test plan preparation with detailed test case’s using SQL Queries
  • Execution of Test Cases (Oracle, SQL server)& results documentation
  • Identifying test cases for Regression testing
  • Defect Analyzing and Reporting in QC

Place: Bangalore (Sasidhar B)

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

stuff goes in here!