Systems Analyst – Mainframe Migration

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

Job Title : Systems Analyst - Mainframe Migration
Duration: 6 Months
Rate: $50-55/hr on Amtex W2- Try to be competitive
Location: Onsite 2-3 days/week, Pasadena, CA

Systems Programmer Analyst
Responsibilities and Requirements

Responsibilities

• Serve as a Systems Programmer Analyst responsible for analyzing business and system needs, documenting requirements, and translating them into clear functional and technical specifications.
• Perform systems analysis across applications, databases, batch jobs, interfaces, reports, and operational processes to support enhancements, troubleshooting, conversions, and production support.
• Develop, execute, validate, and optimize complex SQL queries and scripts to research data issues, support analysis, confirm expected results, and validate business rules or system changes.
• Analyze data structures, database relationships, source-to-target mappings, and application logic to support reporting, integrations, batch processing, and modernization efforts.
• Create and maintain requirements documents, functional specifications, process flows, data mappings, test scenarios, validation results, and implementation support materials.
• Collaborate with business users, developers, database administrators, quality assurance staff, architects, and project teams to clarify requirements, evaluate options, and support delivery of system changes.
• Support development and testing activities by reviewing logic, validating program output, creating test data, documenting defects, and assisting with optional programming or scripting tasks when needed.
• Assist with production support, implementation planning, post-deployment validation, and clear communication of findings, risks, and recommended remediation steps.

Requirements

• A Bachelor’s Degree from an accredited college in Computer Science, Information Systems, Business Information Systems, or a closely related field, -AND- at least three (3) years of progressively responsible, full-time, paid experience in a centralized Information Technology organization performing systems analysis, requirements documentation, application support, data analysis, SQL development, application development, or related technical analysis work.
• Strong systems analyst experience is required, including requirements gathering, functional and process analysis, technical documentation, stakeholder coordination, testing support, and implementation support.
• Advanced SQL proficiency is required, including writing, modifying, debugging, optimizing, executing, and validating SQL queries and scripts for data analysis, reconciliation, troubleshooting, reporting, and system validation.
• Experience analyzing relational databases, data models, source-to-target mappings, stored procedures, data quality issues, and application or batch processing logic is required.
• Experience supporting application development, enhancement, conversion, or modernization initiatives is required, including the ability to work with developers and technical teams to clarify logic, validate outputs, and support design decisions.
• Programming experience is preferred but not required; desirable experience may include Java, Spring, scripting, batch processing, report development, stored procedures, mainframe, or legacy technologies.
• Experience designing automated parity/comparison gates instead of manual report-by-report checks, and supporting a legacy-to-modern parallel-run/cut-over cycle is preferred.
• Strong analytical, troubleshooting, problem-solving, communication, facilitation, documentation, and attention-to-detail skills are required.