Description

You will own the analysis and migration of legacy mainframe data into modern relational and dimensional SQL databases.

This role is hybrid.

Responsibilities

• Analyze legacy VSAM files and COBOL programs to extract field references, calculated data, and business rules for source-to-target mapping.
• Build and maintain the master data dictionary, defining business terms, valid values, and relationships.
• Develop and execute ETL pipelines using IBM DataStage to transform and move data between mainframe and SQL Server environments.
• Design and run complex SQL validations based on Source-to-Target Mapping (STTM) documents to ensure data integrity.
• Create SSRS reporting deliverables and support database design for mission-critical applications.

Required Skills

• 5+ years of experience with source-to-target data mapping across mixed Mainframe and Relational Database environments.
• 3+ years of recent experience developing ETL applications using IBM DataStage.
• Strong SQL skills, including complex queries, stored procedures, and data validation logic.
• Proficiency in SSRS report development.
• Experience extracting field references and calculated data from COBOL programs.
• Knowledge of mainframe technologies: COBOL, CICS, and DB2.
• Familiarity with BMC Control-M workload automation and GIT version control.
• Ability to work across IBM Mainframe, Windows Server, and SQL Server environments.

Preferred Skills

• Experience with Pension Administration systems.
• Knowledge of Data Quality/Profiling tools and Data Warehousing concepts.

Key Skills

Education

Any Gradute