Sagitec Solutions
Sr. Database Developer
Sagitec Solutions, Denver, Colorado, United States, 80285
Job Title: Sr. Database Developer
Location: Sacramento(CA) (or) RemoteJob Status: Fulltime
Job Description
The Sagitec, Data Developer, responsible for...
To develop, test and execute data conversion procedures and processes
Understand the Pension system and Legacy data and provide data analysis on legacy client databases
Document the data mapping, processes, programs and solutions as per established standards.
Identify SQL performance issues and provide corrective measures.
Learn and understand Sagitec Data practices and learn Retirement Benefit system.
Develop, test and execute data conversion procedures and processes
Requirements:• Interface with customer, gather requirements and create mapping documents• Has a strong understanding of the overall software delivery lifecycle and activities.• Expertise in developing ETL packages using SQL Server Integration Services (SSIS) ( Data Extraction, Transformation, and loading from heterogeneous Sources to SQL Server target).• Strong in T-SQL Scripting. Designing, Developing, Testing SQL queries.• Experience with Microsoft SQL Server 2008 or above.• Experience with Microsoft SQL Server Security and User administration.• Ability to analyze the data sources, identify the data issues and patterns before Data Migration.• Ability to learn and support new and existing applications.• Ability to work in a fast-paced work environment, manage time effectivel• Pension or Retirement domain experience a plus
Requirements:• Bachelor's degree in Computer Science, IT, or related field.• Minimum 5+ years of experience in SQL Server, SSIS (ETL Processing)• Interface with customer, gather requirements and create mapping documents• Has a strong understanding of the overall software delivery lifecycle and activities.• Expertise in developing ETL packages using SQL Server Integration Services (SSIS) ( Data Extraction, Transformation, and loading from heterogeneous Sources to SQL Server target).• Strong in T-SQL Scripting. Designing, Developing, Testing SQL queries.• Experience with Microsoft SQL Server 2008 or above.• Experience with Microsoft SQL Server Security and User administration.• Ability to analyze the data sources, identify the data issues and patterns before Data Migration.• Ability to learn and support new and existing applications.• Ability to work in a fast-paced work environment, manage time effectivel
Location: Sacramento(CA) (or) RemoteJob Status: Fulltime
Job Description
The Sagitec, Data Developer, responsible for...
To develop, test and execute data conversion procedures and processes
Understand the Pension system and Legacy data and provide data analysis on legacy client databases
Document the data mapping, processes, programs and solutions as per established standards.
Identify SQL performance issues and provide corrective measures.
Learn and understand Sagitec Data practices and learn Retirement Benefit system.
Develop, test and execute data conversion procedures and processes
Requirements:• Interface with customer, gather requirements and create mapping documents• Has a strong understanding of the overall software delivery lifecycle and activities.• Expertise in developing ETL packages using SQL Server Integration Services (SSIS) ( Data Extraction, Transformation, and loading from heterogeneous Sources to SQL Server target).• Strong in T-SQL Scripting. Designing, Developing, Testing SQL queries.• Experience with Microsoft SQL Server 2008 or above.• Experience with Microsoft SQL Server Security and User administration.• Ability to analyze the data sources, identify the data issues and patterns before Data Migration.• Ability to learn and support new and existing applications.• Ability to work in a fast-paced work environment, manage time effectivel• Pension or Retirement domain experience a plus
Requirements:• Bachelor's degree in Computer Science, IT, or related field.• Minimum 5+ years of experience in SQL Server, SSIS (ETL Processing)• Interface with customer, gather requirements and create mapping documents• Has a strong understanding of the overall software delivery lifecycle and activities.• Expertise in developing ETL packages using SQL Server Integration Services (SSIS) ( Data Extraction, Transformation, and loading from heterogeneous Sources to SQL Server target).• Strong in T-SQL Scripting. Designing, Developing, Testing SQL queries.• Experience with Microsoft SQL Server 2008 or above.• Experience with Microsoft SQL Server Security and User administration.• Ability to analyze the data sources, identify the data issues and patterns before Data Migration.• Ability to learn and support new and existing applications.• Ability to work in a fast-paced work environment, manage time effectivel