Required Skills

SQL Developer

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 :- 20th Nov 2021

JOB DETAIL

 

Learn and understand the Spectrum ( Tre_SQL ) data model which is the data source

Learn and understand the CDR ( Central Data Repository ) data model which is the data destination

Review and improve the level of existing documentation for existing SQL conversion scripts for selected tables

Learn and understand existing SQL script code as well as background business knowledge

Perform any required analysis, discuss, and confirm IMRF business system concepts with other IMRF Horizon conversion team members

Be in a position to make new changes to existing CDR SQL scripts and create new ones according to specifications in our ticketing system, ALM,  and other documentation from IMRF data analysts

Learn and be able to execute the CDR Load Tool ( IMRF provided ) in order to solve more complex issues that span multiple CDR tables and involve multiple SQL scripts

Perform any required analysis, discuss, and confirm IMRF business system concepts with other IMRF Horizon conversion team members

Be in a position to make new changes to existing CDR SQL scripts and create new ones according to specifications in ALM defects and other documentation from IMRF data analysts

Propose ways to help improve load times for conversion scripts

Attend meetings as needed to provide status updates on conversion efforts

Utilize company provided equipment at all times

Understand and adhere to data confidentiality rules

 

Company Information