Overview
On Site
$Competitive
Accepts corp to corp applications
Contract - W2
Contract - Independent
Skills
Data Mapping
RDBMS
Microsoft Windows
IBM
IBM Rational
Data Dictionary
Documentation
Migration
VSAM
Database
IBM InfoSphere DataStage
Git
Version Control
Continuous Integration and Development
Business Rules
Data Warehouse
Data Marts
Microsoft SSIS
Problem Solving
Conflict Resolution
Information Gathering
SQL
Stored Procedures
Linux
Unix
Shell Scripting
C#
Visual Basic .NET
Microsoft SSRS
Analytical Skill
IBM Mainframe
Microsoft Operating Systems
Microsoft Windows Server
Microsoft SQL Server
Mainframe
COBOL
CICS
BMC Control-M
Data Structure
Extract
Transform
Load
Data Management
Data Quality
Data Profiling
Data Cleansing
Process Improvement
Job Details
Job Description:
The Senior Data Analyst shall provide CLIENT' Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts part of ongoing Legacy Replacement initiative.
The Senior Data Analyst shall provide CLIENT' Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts part of ongoing Legacy Replacement initiative.
Required Exp.:
Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environment.
Hands-on IBM DataStage ETL administration experience in Windows environment.
Hands-on experience with SQL Server Reporting Services (SSRS) platform.
Hands-on experience with IBM RAA (Rational Asset Analyzer).
Experience creating data dictionary documentation with business terms, valid values, and definitions.
Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL.
Experience extracting field references and calculated data from COBOL programs.
Experience with BMC Control-M workload automation software.
Experience with GIT version control software, Build and CICD pipeline automation.
Minimum of three (3) years of recent experience with Pension Administration systems
Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environment.
Hands-on IBM DataStage ETL administration experience in Windows environment.
Hands-on experience with SQL Server Reporting Services (SSRS) platform.
Hands-on experience with IBM RAA (Rational Asset Analyzer).
Experience creating data dictionary documentation with business terms, valid values, and definitions.
Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL.
Experience extracting field references and calculated data from COBOL programs.
Experience with BMC Control-M workload automation software.
Experience with GIT version control software, Build and CICD pipeline automation.
Minimum of three (3) years of recent experience with Pension Administration systems
Preferred:
Experience extracting business rules from the existing legacy code.
Experience with Data Quality/Profiling tools.
Experience with Data Warehouses/Data Marts.
Experience with SQL Server Integration Services (SSIS)
Excellent analytical, problem solving, and information gathering skills along with fundamental troubleshooting technique abilities.
Strong SQL knowledge working with complex queries and stored procedures.
Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NET
Proficiency in SSRS reports' development and administration.
Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team's methodology.
Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
Proficiency in mainframe applications encompassing COBOL and CICS.
Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.
Understanding of data structures and their relationship to ETL applications.
Experience extracting business rules from the existing legacy code.
Experience with Data Quality/Profiling tools.
Experience with Data Warehouses/Data Marts.
Experience with SQL Server Integration Services (SSIS)
Excellent analytical, problem solving, and information gathering skills along with fundamental troubleshooting technique abilities.
Strong SQL knowledge working with complex queries and stored procedures.
Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NET
Proficiency in SSRS reports' development and administration.
Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team's methodology.
Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
Proficiency in mainframe applications encompassing COBOL and CICS.
Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.
Understanding of data structures and their relationship to ETL applications.
Responsibilities:
The Senior Data Analyst shall provide client Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing efforts part of Legacy Replacement initiative, as well as CLIENT' ongoing process improvement programs.
The Senior Data Analyst shall provide client Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing efforts part of Legacy Replacement initiative, as well as CLIENT' ongoing process improvement programs.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.