Required Skills

Qlik Tableau BOE SQL Server Azure SQL DB Oracle

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 21st Dec 2020

JOB DETAIL

They ideally need to have IICS (Informatica Cloud Data Integration) experience, but if they don’t, regular informatica might work as well but I am seriously considering people with the at experience FIRST. THEY must be a green card holder or US Citizen and be ok with relocating to Columbus, OH once Covid is over and clears. Will be remote for the future.

FUNCTIONS ARE: · Build ETL to centralize data into a Data Warehouse environment. · Develop, unit test and system test integration components · Create support documentation describing the functionality of the integrations. · Maintain consistency in naming standards and ensure standards are followed. · Ensure adherence to data management/governance policies, processes, and standards. · Support/Maintain existing data interfaces.

Required Qualifications · 5 - 7 years of prior IT experience in Data Management / ETL / ELT / Data Warehousing · Proven experience with Data Management & Integration o Recent experience developing integrations using Informatica Cloud Data Integration (IICS – CDI Service) is required.

o Recent experience developing integrations using Informatica PowerCenter is required. o Experience in integrating multiple sources into a centralized data platform or Enterprise Data Warehouse o Experience in integrating data into, Star Schemas, Normalized Data Models. Data Vault models · 5+ years of in-depth experience working with a wide variety of RDBMS (SQL Server, Azure SQL DB, Oracle etc.). · Strong written and verbal communication skills. · Ability to work independently and as part of a data team. · Strong organizational, administrative, and analytical skills required.

Nice to have: · HealthCare Experience with Claims data and Clinical data. · Experience with BI tools and their data needs (i.e. Qlik, Tableau, BOE, or SAS as examples) desired o Experience in using visualization tools and an understanding of how those tools consume data · Understanding of Data Quality concepts and ability to use them effectively. · Experience in writing Data Quality routines for cleansing of data and capturing confidence score · Data Modeling experience · ETL tuning experience

Company Information