16 Apr
Data Conversion Analyst
Vacancy expired!
- 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.
- Must be fluent reading, writing and speaking English.
- Must be located in Texas.
- Informatica Experience
- DB2 Experience
- VSAM Experience
- SQL Experience
Vacancy expired!