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 roleBSA 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 teamsPrepare 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 conceptsPresent the draft version of Data ModelPerform UAT / Business Checkout using SQL ScriptsPrepared Source to Target MappingPerformed Gap Analysis / Data ProfilingPrepared Functional Specifications working with BusinessStrong SQL skills