C2C
Anywhere
Posted 9 hours ago

Role: BSA Experience in Data Warehouse

Location – Philadelphia, Pennsylvania

Mandatory Skills:

5 Years of Experience in Data Warehouse

5 Years of Experience in SQL Query

5 Years of Experience in SQL Scripting

5 Years of Experience in Data Modeling

5 Years of Experience in Target Mapping (apping Document to be used by Dev and QA team (Detailed level required. Provide Joins, Filters and Ranking (if required) to get UNIQUE records))

Good To have Skills:

2 Years of Experience in Data Profiling

3 Years of Experience in Gap Analysis

4 Years of Experience in RDBMS

Responsibilities:

• Perform Data Profiling (Identify all data issues before getting the data to DW)

• Prepare Functional Specification based on the interaction with Business and Technical teams

• Prepare Mapping Document to be used by Dev and QA team (Detailed level required. Provide Joins, Filters and Ranking (if required) to get UNIQUE records)

• Good understanding of RDBMS concepts

• Present the draft version of Data Model

• Perform UAT / Business Checkout using SQL Scripts Requirements

•At least 3 years with Data Warehouse, 5 years with SQL and 8 years on a BSA / Technical role

• Solid Healthcare Domain Knowledge

• BSA Experience in Data Warehouse projects (Preferably in Sourcing or Outbound Extracts)

• Good Communication Skills

• Good Analytical skills

• Prepared Source to Target Mapping

• Performed Gap Analysis / Data Profiling

• Prepared Functional Specifications working with Business

• Strong SQL skills

Comments: Data Profiling, Rdbms, Data Warehousing

Requirements