Data Analyst with ETL, IBM z/VSE Mainframe VSAM & SQ

Compensation

: $86,125.00 - $148,460.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





W2 CANDIDATES ONLY

The Data Analyst must be available to work a minimum of 40 hours per week.
The Data Analyst will primarily be responsible for detailed field level analysis, profiling and
mapping of the current IBM z/VSE Mainframe VSAM files loaded into SQL tables.

1. Mandatory Skills: Candidates must meet all the requirements below to be considered for
this position.
Minimum of five (5) years of source-to-target data mapping experience in a mixed
Mainframe, relational database and object storage environments.
Experience creating and/or maintaining ETL applications.
Experience migrating mainframe VSAM files to relational and/or dimensional SQL
databases.
Experience working in multiple development environments/systems: IBM Mainframe,
Windows Server, UNIX and SQL Server.
Strong SQL knowledge working with complex queries and stored procedures.
Proficiency in mainframe applications encompassing COBOL, VSAM and DB2.
Experience creating data dictionary documentation and data definitions/domains.
Excellent interpersonal, communication, presentation, writing, analytical, problem
solving, and information gathering skills along with fundamental technique
troubleshooting abilities.
Strong analytical skills demonstrated by the ability to receive and analyze
requirements and propose a suitable solution that adheres to the team s
methodology.
2. Preferred Experience:
Experience with Data Quality/Profiling tools.
Experience extracting business rules from the existing legacy code.
Experience with Data Warehouses and/or Data Marts.

- provided by Dice
Associated topics: data administrator, data analytic, data center, data engineer, data integrity, data scientist, database, erp, hbase, sybase * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...