Required Skills

Data Analyst - Metadata

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 5th Oct 2021

JOB DETAIL

Plays a key role for a Healthcare client to analyze data quality in source databases in preparation for metadata management, data quality rules, and data lineage repositories and rules for data being migrated to an Azure Cloud environment.

Review current claims, member and provider data ingestion process from source systems

Review the specific data fields/elements available in CDR2(Oracle) Data Source

Review the specific data fields/elements available in Facets Data Source 

Review the specific data fields/elements available in JIVA and HL7 Data Sources 

Review the specific data fields/elements available in External File Data Sources Perform Data Profiling on data from each source to identify data quality issues

Minimum Experience of 6-9 years in Data Analysis Business/Data analysis,  ETL Development and Data Modeling in MS Azure Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Experience in big data environment which involved Microsoft Azure Data Factory, Data Lake, and SQL server.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, and Data Mismatch Identification.

Experience in Business Requirement Gathering and Analysis, Feasibility study, ROI Analysis, Process Flow and Process Modeling, Functional and Techno - Functional Gap Analysis of existing system.

Experience with BI reporting tools in creating and assisting developers to get reports. Experience performance tuning of the queries and reports.

Experience in writing SQL queries to validate data movement between different layers in data warehouse environment.

Experience in developing strategies for ETL (Extraction, Transformation and Loading).

Experience in creating various artifacts for projects which include specification documents for data mapping and data analysis.

Experienced in developing accurate business process requirements.

Company Information