Addison Group

SQL Developer

3+ months agoAustin, TX

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.

Job ID: AddisonGroup-484980