Data Conversion Developer

About us ProPhoenix is a leader in the design and delivery of the most comprehensive, dynamic, and secure Public Safety software products in the industry. Established in 2003 and headquartered in Moorestown, New Jersey, ProPhoenix Corporation provides responsive, analytical, and manageable COTS (commercial-off-the-shelf) applications for Law Enforcement, Communication Centers, Fire/EMS, and Corrections Management. Responsibilities The Data Conversion developer will work directly with customers, subject matter experts (SMEs) and development team to establish a conversion approach, development and complete the data conversion of Phoenix Law/CMS/Fire Record Management Systems. Preferred Skills Mandatory SQL Server Query Writing Skills SSIS experience with stored procedures, optimization, views and indexes. Candidate should possess a strong knowledge of ETL processes including a complete functional understanding with hands on experience using Microsoft SSIS packages for the migration of data between OLTP, staging and OLAP environments. Knows control flow ,data flow items, variable handling, expressions, SCD, Lookup, Merge Join, Precedence constraint and can demonstrate usage of each SSIS Advanced component experience required (transformation objects in data flow) Experience in SSIS administration, i.e.; how to make and manage complete ETL flows. Create and manage SQL Integration Services packages to support ETL jobs and ad hoc data loads. C#.Net will be an added advantage. Job Type: Full-time Benefits: Dental insurance Health insurance Schedule: Monday to Friday Experience: SSIS: 1 year (Required) SQL: 1 year (Preferred) Ability to Commute: Moorestown, NJ (Required) Ability to Relocate: Moorestown, NJ: Relocate before starting work (Required) Work Location: In person