Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SQL Server 2000 SSRS SSIS Object Frameworks Implementation ZOs DB2 .NET Library An
 
Requirement id 69649
Job title Analyst
Job location in Middletown, CT
Skills required Data Profiling, Data Analysis, Data Cleaning, SQL Server 2000 SSRS SSIS Object Framewo
Open Date 07-May-2018
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Analyst: Data Profiling, Data Analysis, Data Cleaning, SQL Server 2000 SSRS SSIS Object Framewo

Start Date :06/04/2018
End Date :12/31/2018
Submission Deadline :05/09/2018
Client Info :CT DESPP
Description :

The Software Engineer (SE) will analyze, design and develop processes to improve the data quality of the current MNI-CCH software application and prepare the data for migration into a new MNI-CCH software application. The SE will produce a logical and physical data model of the current MNI-CCH repository, design and develop a data dictionary that can be utilized for both the data cleanup project and for the MNI-CCH conversion, and plan, design, develop, and implement an ongoing data cleanup process for the current MNI-CCH data. The scope of MNI-CCH data includes data consumed from the Automated Fingerprint Identification System (AFIS) application and from the court Criminal and Motor Vehicle System (CRMVS) application.

Specific Services Required
1. Technical Tasks
a. Work with DESPP IT MNI-CCH resources to understand the existing data values and data relationships and to extract hard-coded default data values, code values, data values for data that is transformed and inserted/updated from the AFIS and CRMVS systems, and data values for data that is transformed and updated from the online and batch MNI-CCH applications.
b. Perform comprehensive analysis and evaluation of current MNI-CCH data
i. Develop logical data model
ii. Develop data dictionary
1. Identify data elements, data element types, data element values
2. Identify data element business rules
3. Create data element business descriptions
4. Identify creation source of each data element
iii. Identify and document data flows to/from external systems
iv. Identify potential issues that would affect data migration (data that cannot be converted, errors that cannot be resolved)
c. Develop data quality assurance procedures and reporting tools to align existing data with NFF requirements
i. Identify data quality issues that can be corrected without human intervention, and develop automated procedures for implementing the corrections. The tasks that can be automated include:
1. Identification and resolution of Data Element issues
2. Analyze and match records in Suspense with the AFIS Suspense based on Uniform Arrest Record (UAR) number
3. Identify and match records in AFIS Suspense with records in MNI.
4. Match/cleanup of Error Master and Error Offense records
5. Consolidation of State Identification Numbers (SID) numbers in MNI-CCH (programmatically completed in the AFIS application but not performed in MNI-CCH).
6. Identification and resolution of non-fingerprinted supported arrests
7. Identification and synchronization of FBI records that are not on state file
8. Match of MNI Person to court CRMVS records to determine value of family violence flag on Arrest table (10 year look back)
9. Identification and population of the Originating Agency Identifier numbers (ORI) not appearing on the Arrest file
ii. Identify data quality issues that require human intervention, and develop procedures and reports to facilitate that human intervention. The task requiring manual intervention are:
1. Identification of duplicate UAR numbers
2. Identification of a single identifiable person with multiple UAR numbers being assigned multiple SID numbers
3. Any automated identification/update tasks that fail or where the data issue is not specifically defined in the code.
iii. Document and report repeating data issues to Project Sponsor
2. Management Tasks
i. Assist with the creation of a Data Governance process
ii. Assist with the creation of a Data Quality process plan
iii. Assist with the creation of a Data Cleanup Detail Design document
iv. Assist with the creation of a work flow process for those issues requiring manual intervention

 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 69649 while calling.
 
Other jobs in CT: Bristol (4), Hartford (1), Shelton (6), Westport (1), Windsor (4), Windsor Locks (1),
Data Profiling job openings in Middletown, CT
Jobs List

Business Analyst - Level 3 - 53350
Create date: 07-May-2018
Start Date :05/26/2017
End Date :12/31/2017
Submission Deadline :05/22/2017
Client Info : CT DESPP

Description :

The Business Analyst (BA) will work on both systems simultaneously.
SLFU-The BA will ensure all business processes and requirements are accounted for in new .... (This job is for - job Jobs in CT Middletown Analyst - (in Middletown, CT))
 
 Data Profiling job openings in other states
Jobs List

Senior Pentaho Developer - 4977
Create date: 14-May-2021
Description:

Day-to-Day Tasks include, but not limited to:

Gather and validate of BI and reporting requirements.
Document requirements & solutions
Perform Data profiling on the source systems.
Design and review star schema dimensional model to support data warehouse and data marts.
Perfo.... (This job is for - MappingETL Jobs in NY Albany Developer - (in Albany, NY))

Business Data Analyst
Create date: 06-Apr-2020
Description:

The Data Management Branch is seeking a Business Analyst (Data Stewardship) which will be housed within the Division of Strategic Services and will work closely with Project managers, IT staff, and Management to help match and maintain data quality using IBM Master Data Management tool.

Primary Responsibilities:.... (This job is for - job Jobs in KY Frankfort Analyst - (in Frankfort, KY))

IT Data Analyst - 20-00109
Create date: 10-Mar-2020
Responsibilities

&ast&ast&ast is seeking 1 IT Data Analyst to start as soon as possible. This is a contract-to-hire, so all submitted candidates must be eligible to work in the US without sponsorship. Conversion terms are 1040 hours. Conversion Salary Range: 68K - 105K Please submit your top 2 candidates.

POSITION OVERVIEW job Jobs in MN Minnetonka Analyst - (in Minnetonka, MN))

Data Analyst - 15538
Create date: 21-Jan-2020
Description:

15538 – Data Analyst – Columbus, Ohio

4+ years experience

Candidate must have good skills in data profiling, mapping and data modeling.
2. Strong skills in Informatica, Information Analyzer and IBM data architect is big plus. Strong SQL skills is a must.
3. Hands-on experience in creating/upda.... (This job is for - Mapping Jobs in OH Columbus Analyst - (in Columbus, OH))

Data Analyst - 15452
Create date: 20-Dec-2019
Description:

Data Analyst – Columbus, Ohio

6+ years experience

1. Candidate must have good skills in data profiling, mapping and data modeling.
2. Strong skills in Informatica, Information Analyzer and IBM data architect is big plus. Strong SQL skills is a must.
3. Hands-on experience in creating/updating .... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH))
 
 Data Profiling job openings in CT
Jobs List

Oracle/PeopleSoft EPM Business Intelligence Developer -52987
Create date: 19-Jan-2018
Start Date : 02/05/2018
End Date : 08/03/2018
Submission Dead Line : 01/25/2018
Client Info : CT OPM
Description :

Oracle/PeopleSoft EPM Business Intelligence Developer/Administrator - Level 4

Specific Services.... (This job is for - Data Warehousing Jobs in CT Hartford Developer - (in Hartford, CT))
(Analyst: Data Profiling, Data Analysis, Data Cleaning, SQL Server 2000 SSRS SSIS Object Framewo in Middletown, CT)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved