• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 4th Aug 2022

Looking for experienced ETL developers with 8+ Yr of ETL Development exp

 (in either Matillion or similar ETL tool) with Solid SQL experience (All type of SQL joins and SQL Analytical functions)

 to work on implementing a system migration project.

 The ideal candidate must have experience in healthcare (payer and provider domains), must have experience with DB, ETL, analytics, and data conversion/migration

 with a large size project, and have a solid Information Technology (IT) background.

 Apart from education and experience, the ideal candidate will have leadership, communication, and strong technical skills.

 ESSENTIAL DUTIES & RESPONSIBILITIES

• Candidate will work on a project to convert and migrate HealthCare data (Eligibility, Medical claims and Pharmacy claims)

  between different DB systems and from raw files to the Snowflake datawarehouse.

• Proficient with ETL methodologies, including data analysis, data profiling, and data validation

• Perform all data conversion activities and tasks (data mapping activities) necessary to assure the data is imported properly before going live.

• Understand the healthcare business and associated data and how data elements and modules integrate

• Participate in workshops with vendor and IT teams to gather and analyze business requirements

• Analyze data in a variety of formats

• Artifact Management – Generate data mapping documentation

• Clearly describe and/or document issues concerning the quality of data with regards to their business requirements and processes

• Help the team with writing, editing, updating technical documentation to facilitate the goal of streamlining and documenting the conversion/migration processes.

• Develop, test, execute and document repeatable processes to migrate data into a new system

• Responsible for creation and version control of certain project documents, such as data mapping,

• Timeline Management – Responsible to work within the timeframes established by the project manager and client MINIMUM QUALIFICATIONS

• Degree in Computer Programming, Computer Science, Information Systems, or a related field. Min. 6+ years of experience working on DB Systems, SQL/Snowflake

• Understanding the translation between multiple file formats and data sets

• Ability to use scripting languages, ETL tools (preferably Matillion) and methodologies to map data between various formats

• Excellent working knowledge of relational databases such as Microsoft SQL Server versions 2008R2, 2012, 2014