ETL Business Analyst with Healthcare Domain exp

Philadelphia, PA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Role: ETL Business Analyst

Location: Philadelphia PA (Day 1 Onsite)

Job Type: Contract

Must have Skills:

Healthcare Domain experience (Mandatory)
10 Yrs of Exp Sr BSA (Business/Systems Analysts)
5 Yrs of Exp Data Warehouse SQL Data Profiling
5 Yrs of Exp Mapping Document to be used by Dev and QA team (Detailed level required. Provide Joins Filters and Ranking (if required) to get UNIQUE records)
6 Yrs of Exp - Data Warehouse projects (Preferably in Sourcing or Outbound Extracts)
6 Yrs of Exp - Perform UAT / Business Checkout using SQL Scripts
5 Yrs Of Exp - Target Mapping Gap Analysis / Data Profiling Functional Specifications working with Business
3 Yrs Of Exp - Data Profiling (Identify all data issues before getting the data to DW)

Experience and Qualifications:

At least 3 years with Data Warehouse 5 years with SQL and 8 years on a BSA / Technical role
BSA Experience in Data Warehouse projects (Preferably in Sourcing or Outbound Extracts)
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
Prepared Source to Target Mapping
Performed Gap Analysis / Data Profiling
Prepared Functional Specifications working with Business
Strong SQL skills

Role: ETL Business Analyst Location: Philadelphia PA (Day 1 Onsite) Job Type: Contract Must have Skills: Healthcare Domain experience (Mandatory) 10 Yrs of Exp Sr BSA (Business/Systems Analysts) 5 Yrs of Exp Data Warehouse SQL Data Profiling 5 Yrs of Exp Mapping Document to be used ...