Apply on Employer Site

Saransh Inc · 2 months ago

ETL Business Analyst with Healthcare Domain exp

Philadelphia, PA

Contract

Onsite

Senior Level, Lead/Staff

10+ years exp

Saransh Inc is seeking an ETL Business Analyst with experience in the healthcare domain. The role involves working on data warehouse projects, performing data profiling, and preparing functional specifications and mapping documents for development and QA teams.

EmploymentInformation TechnologyStaffing Agency

H1B Sponsor Likely

Responsibilities

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)

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

Qualification

Healthcare Domain experienceData WarehouseSQLMapping Document preparationData ProfilingUAT / Business CheckoutGap AnalysisFunctional SpecificationsRDBMS conceptsData Model presentation

Required