ETL Business Analyst with Healthcare Domain Exp

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