Mainframe Migration Systems Analyst - Onsite Pasadena

Amtex Enterprises Inc; Pasadena (CA); On-site; USD 69,000 - 76,000; Part time

Job summary

Amtex Enterprises Inc is seeking a Systems Analyst for a 6-month onsite engagement in Pasadena, CA. The role focuses on mainframe migration, analyzing business and system needs, and documenting clear functional specifications.

The candidate will write and optimize SQL, support testing, and collaborate with cross-functional teams. Required is a Bachelor's degree in a related field with 3+ years of systems analysis experience, strong SQL skills, and the ability to support modernization

Qualifications

• Bachelor's degree in a related field and 3+ years of systems analysis experience.
• Strong requirements gathering and documentation capabilities.
• Advanced SQL proficiency for data analysis, validation, and troubleshooting.
• Experience analyzing relational databases, data models, and data mappings.
• Experience supporting development, modernization, or conversion initiatives.
• Experience with testing, validation, and rollout activities.
• Desirable programming experience (Java/Spring) and batch processing knowledge.
• Strong communication, facilitation, and attention-to-detail skills.

Responsibilities

• Analyze business and system needs and translate into functional/technical specs.
• Perform systems analysis across applications, databases, and batch processes.
• Develop, execute, and validate SQL queries and scripts for data issues and business rules.
• Collaborate with users, developers, DBAs, QA, and project teams to clarify requirements.
• Support development/testing activities and post-deployment validation.

Skills

SQL development

Data analysis

Requirements gathering

Stakeholder coordination

Testing support

Programming experience

Batch processing

Analytical skills

Communication

Problem solving

Education

Bachelor's degree in Computer Science/Information Systems/related field

Tools

Java

Spring

Mainframe/Legacy tech

Job description

Amtex Enterprises Inc is seeking a Systems Analyst for a 6-month onsite engagement in Pasadena, CA. The role focuses on mainframe migration, analyzing business and system needs, and documenting clear functional specifications.

The candidate will write and optimize SQL, support testing, and collaborate with cross-functional teams. Required is a Bachelor's degree in a related field with 3+ years of systems analysis experience, strong SQL skills, and the ability to support modernization