• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 18th Aug 2021

Our Client is looking for ETL/ SQL Developer in Oak Brook, IL. Looking for local Consultant only.

Written Test to Pass

MUST have extensive TSQL Exp, they are migrating their Pensions application to a new platform, lines and lines of data.

Must provide examples of TSQL code they have written.

Excellent communication skills a must

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