SQL Developer

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.

• 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.