Scope of Services
Client seeks one (1) Senior Data Analyst with ETL expertise to work with the Information Technology (IT) Division. The Senior Data Analyst will primarily be responsible for detailed field-level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables, as well as conversion and validation efforts as part of the enterprise-wide Legacy Replacement program. The Senior Data Analyst must be available to work a minimum of 40 hours per week and will be subject to onsite and/or remote working in accordance with Client policies in effect for the duration of the project.
Mandatory Skills/Experience
1. Experience – Mandatory
-
Minimum of five (5) years of source-to-target data mapping experience in mixed Mainframe and Relational Database environments.
-
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.
-
Minimum of three (3) years of recent experience with Pension Administration systems.
2. Technical Ability – Mandatory
-
Strong SQL knowledge working with complex queries and stored procedures.
-
Proficiency in SSRS report development.
-
Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose suitable solutions that adhere to the team's methodology.
-
Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
-
Proficiency in mainframe applications encompassing COBOL, CICS, and DB2.
-
Understanding of data structures and their relationship to ETL applications.
-
Ability to develop complex SQL data validations based on STTMs and target Data Models.
-
Excellent analytical, problem-solving, and information-gathering skills, along with fundamental troubleshooting abilities.
3. Assumptions Regarding Consultant Tasks and Deliverables
The Senior Data Analyst shall provide the Client's Data Management team with technical expertise for the comp