SQL Developer
Location: Austin, TX

Responsibilities:

Collaborate with Data Conversion Lead to design, develop, test, implement, and support innovation and optimal data solutions;
Use Neosurance data structure knowledge to implement the data conversion procedures.
Use Neosurance UI product business knowledge to design the data conversion.
Use issues resolution knowledge along with the NeoTrack (Sagitec's SDLC tool) experience to monitor and resolve the data conversion issues.
Requires RDBMS and MS SQL Server skills to design, develop and implement data conversion.
Use Sagitec's Data Conversion and Migration methodology to perform data conversion tasks.
Create Stored Procedures, Functions, Scripts, and Triggers with extensive use of T-SQL;
Requires RDBMS and MS SQL Server skills that include T-SQL, SSRS, SSIS, SSMA expertise to implement the stored procedures, functions, scripts, and triggers required for data conversion.
Experience using ETL tools preferably Informatica Power Center and Power Exchange.
Experience in extracting data from Mainframe file formats like VSAM, etc.
Use Neosurance data structure knowledge to implement the data conversion procedures.
Ensures that any key legacy data fields and business rules are part of the data conversion
Use Sagitec data conversion framework and data obfuscation templates to perform data conversion tasks.
Use Neosurance UI product business knowledge to design the data conversion.
Use Neosurance data structure knowledge to implement the data conversion procedures.
Work with the data conversion manager to ensure that all ongoing data transformation, de-duplication, extraction, and load functions once ready for production deployment are documented and implemented for the legacy client database.
Identify SQL performance issues and provide corrective measures.
Meet daily\weekly\monthly deadlines.
Reports data conversion issues and status along with data conversion tasks.
Work with internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to process new data and build new reports.
Provide basic SQL Server Administration support as needed on the project.

Qualifications :

1-3 years of DD role experience
Understanding and experience with various methodologies used to convert data.
Strong organizational skills.
Strong interpersonal, verbal and written communication skills.
Ability to handle and prioritize multiple tasks.
Ability to work on various teams and contribute to the success of the teams.
Experience in UI systems will be a PLUS.
Bachelor's Degree in IT or related field.