Loading some great jobs for you...

Tech Valley Talent (TVT) is looking for a Data Analyst with ETL experience in a mainframe environment for a 3 Year contract with our client in Brooklyn, NY. Client has right to hire anytime after 6 months on contract. We CANNOT work with third parties as per client agreement. Interviews are ONSITE only in Brooklyn. Start date is targeted for September 2019.

Tech Valley Talent (TVT) is an Information Technology (IT) Professional Services firm founded on the values of high integrity, trust, honesty and commitment. Our team provides exceptional value to our clients by recruiting and supplying the best IT staffing talent. Our partnerships with key technology firms enables us to provide even greater value to our clients.

Job description:

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.

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.

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.

It is TVT's policy to provide for and promote equal employment opportunity in employment compensation and other terms and conditions of employment without discrimination based on age, race, creed, color, national origin, gender, sexual orientation, disability, marital status, Vietnam Era Veteran status, genetic predisposition, pregnancy-related conditions or carrier status

- provided by Dice
Associated topics: data analyst, data center, data integration, data management, data scientist, hbase, mongo database, sql, sybase, teradata

* 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...