Hybrid Systems Programmer Analyst: SQL, Migrations & Testing

KPG99 INC; Pasadena (CA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

KPG99 INC is seeking a System Programmer Analyst to support SQL, migration, testing, and mainframe activities in a hybrid Pasadena environment. You will analyze business and system needs, document requirements, and translate them into clear specifications for delivery.

The role involves validating complex SQL queries, supporting data migrations, and collaborating with cross-functional teams to ensure accurate data processing and reliable production support.

Qualifications

• Bachelor's degree required with 3+ years of IT experience in systems analysis, requirements documentation, or related technical analysis work.
• Strong systems analyst experience including requirements gathering, functional analysis, and implementation support.
• Advanced SQL proficiency for writing, debugging, and optimizing queries across data analyses and system validation.
• Experience analyzing relational databases, data models, stored procedures, and data quality issues.
• Experience supporting application development, enhancements, conversions, or modernization initiatives.

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.

Skills

SQL development

Systems analysis

Data analysis

Testing support

Communication

Education

Bachelor's Degree in Computer Science / Information Systems

Tools

Java

Spring

Batch processing

Mainframe

Legacy technologies

Job description

KPG99 INC is seeking a System Programmer Analyst to support SQL, migration, testing, and mainframe activities in a hybrid Pasadena environment. You will analyze business and system needs, document requirements, and translate them into clear specifications for delivery.

The role involves validating complex SQL queries, supporting data migrations, and collaborating with cross-functional teams to ensure accurate data processing and reliable production support.