Position:Data Analyst / System Analyst
Location: Plano, TX
Duration:Long Term
Job Description:
For Data Analyst position we need below skills. Need 10+ years’ experience with Healthcare experience.
1) Experience writing basic sql and ability to build on smaller logics
2) Experience in DW and Web Services.
2) Experience with Source-to-target writing. Example Identity rule, natural key / primary key.
3) Understanding of Data wharehousing/ETL concepts like incremental load, type II dimension load.
4) Hands on or prior experience with Data modeling preferred Erwin.
5) Documentation skills, understands how to write an impact/gap analysis, Functional specification document.
6) Plus to have Health care domain knowledge
1)Good understand on D/W architecture and design and able to interpret the architecture diagram
2)Good hands on the DB2 database and write SQL queries
3)Understand Star Schema and snow flake schema in Data warehouse
4)Knowledge on Data Modeling and Erwin Tool
5)Knowledge on how to write effective Functional requirement Specification (FRS)
6)Understand the BRD(business requirement document) and research thoroughly the Data flow from end –to-end
7)Knowledge on writing S2T(Source to Target) with clear and effective transformation logic
8)Provide high level solutions based on the requirements
9)Understand Meta Data Hub concepts and support MDH
10)Knowledge on writing DED (Data Exchange Documents) and providing details on data sharing
11)Understanding of job scheduling knowledge and nice to have experience working with Ctrl-M scheduling
12)Ability to walk through the deliverables with Dev/QA/UAT teams and explain the details.