Senior Data Analyst with DataStage

Hybrid in Brooklyn, NY, US • Posted 1 hour ago • Updated 1 hour ago
Contract W2
Contract Corp To Corp
1 Month
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

  • CICS
  • COBOL
  • BMC Control-M
  • Data Extraction
  • Datastage
  • IBM InfoSphere DataStage
  • Microsoft SQL Server
  • Meta-data Management
  • IBM Mainframe
  • Extract, Transform, Load
  • Microsoft SSRS
  • VSAM
  • Mainframe

Summary

Need data extraction from Cobol programs and ETL DataStage development

You 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/validation efforts as part of an enterprise-wide Legacy Replacement program.

 

• Minimum of five (5) years of source-to-target data mapping experience in a 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.

. Technical Ability Mandatory:
• Strong SQL knowledge working with complex queries and stored procedures.

• Proficiency in SSRS reports'' development.

• 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, 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 technical troubleshooting abilities.

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.
  • Dice Id: 10186340
  • Position Id: 9045675
  • Posted 1 hour ago
Contact the job poster
HK

Harisha Katanguri

Delivery Manager @ InfoPeople Corp
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

New York, New York

Today

Easy Apply

Contract

Depends on Experience

Hybrid in New York, New York

Today

Easy Apply

Contract

Depends on Experience

Brooklyn, New York

Yesterday

Easy Apply

Full-time, Third Party

85+

Hybrid in Brooklyn, New York

6d ago

Easy Apply

Third Party, Contract

Depends on Experience

Search all similar jobs