Job Description :
Position : SQL Designer
Location : Madison, WI
Duration : 6+ months Contract

Job Description:

Key thinker who can read and analyze existing (complex) SQL to derive necessary business rules.
Ability to get answers to questions that will certainly pop up during analysis (from business and IT SMEs)
Will be a member of A2 team.
Will attend daily sprints and report on progress.
Proven experience in MS SQL Server (Stored procedures), SSIS development.

Like to have
o Experience in Merlin (most likely would need to take advantage of SME knowledge from existing Syntel resources who have Merlin knowledge)
o SAS development

Tasks (in order of importance)
o Recreation of SC_SCORING_EXTRACT: take existing code that exists in various spots (Unica) and convert it as Stored procedures that can be called for user-defined date ranges.
o ICC Model – Take existing SAS code and convert to stored procedures. Redesign user input so it does not require future IT involvement.
o Aviator – Take existing SSIS code that populates Aviator from Merlin and produce user document explaining business rules. Depending on decision by business once this is done, take this code and modularize it.