-
ID
#19757109 -
Job type
Contract -
Salary
TBD -
Source
Elegant Enterprise Wide Solutions -
Date
2021-09-17 -
Deadline
2021-11-15
Senior Data Analyst
New York, Brooklyn, 11201 Brooklyn USAVacancy expired!
1. Experience (50% of Technical Score) Mandatory: Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments. Hands-on MS Access programming (Macros, VBA, etc.). 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. Preferred: Experience extracting business rules from the existing legacy code. Experience with Data Quality/Profiling tools. Experience with Data Warehouses / Data Marts. Hands-on Experience with SSRS or SSIS. 2. Technical Ability (50% of Technical Score) Mandatory: Excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities. Strong SQL knowledge working with complex queries and stored procedures. 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. Understanding of data structures and their relationship to ETL applications.
Vacancy expired!