Data Analyst with IBM DataStage ETL Expertise

Hi, 

Hope you’re doing well!! 

Please find the requirement below. If you find yourself comfortable with the requirement please reply back with your updated resume or call me back at   

Position: Data Analyst with IBM DataStage ETL Expertise
Location: Brooklyn, NY(Hybrid) (Local)
Duration: 6+ Months
Visa: Client won't be able to sponsor any visa
LinkedIN ID

References Required: Minimum of three (3) professional references

INTERVIEW PROCESS WITH CLIENT-1st Round will be TEAMS CALL and 2nd  Round will be Face to face

What You'll Do

• Perform detailed field-level and metadata analysis of legacy VSAM files to support conversion into relational/dimensional SQL tables
• Conduct data profiling and source-to-target mapping across mixed Mainframe and Relational Database environments
• Build and maintain the organization's master data dictionary, including business terms, valid values, and definitions
• Support database design for NYCERS' mission-critical applications and maintain a component inventory
• Extract field references and calculated/derived data from COBOL programs to inform mapping and validation logic
• Develop and execute ETL pipelines using IBM DataStage to move and transform data between legacy and target systems
• Design and run complex SQL data validations based on Source-to-Target Mapping documents (STTMs) and target data models
• Collaborate with the Data Management team on process improvement initiatives beyond the core migration effort
• Develop reporting deliverables using SSRS

Required Qualifications (Mandatory)

• Minimum 5 years of source-to-target data mapping experience spanning mixed Mainframe and Relational Database environments
• Experience creating data dictionary documentation (business terms, valid values, definitions)
• Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases
• Minimum 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
• Minimum 3 years of recent experience with Pension Administration systems

Required Technical Ability

• Strong SQL skills, including complex queries and stored procedures
• Proficiency in SSRS report development
• Strong analytical skills — able to interpret requirements and propose solutions aligned with team methodology
• Ability to work across multiple environments: IBM Mainframe, Windows Server, and SQL Server
• Proficiency in mainframe technologies: COBOL, CICS, and DB2
• Solid understanding of data structures and their relationship to ETL processes
• Ability to build complex SQL-based data validations from STTMs and target data models
• Excellent analytical, problem-solving, and information-gathering skills, plus fundamental technical troubleshooting ability

Desirable Qualifications

• Experience extracting business rules from existing legacy code
• Experience with Data Quality / Data Profiling tools
• Experience with Data Warehouses / Data Marts
• Experience with SQL Server Reporting Services (SSRS)

• Prior experience in a pension system environment — New York State or New York City pension systems preferred

Thanks & Regards:

Amar Pratap

Senior Technical Recruiter
VISION INFOTECH INC
Phone: ext 531
Direct:  
Email:  
368 Main Street, st #3, Melrose MA 02176

E-Verified Company