Teradata SQL Developer -Mainframe

Title :- Teradata SQL Developer -Mainframe

Location: Morris Plains, NJ / hybrid (3 days onsite)

Must have:

IBM Mainframe: 5+ years

JCL: 5+ years

Unix : 3+ years – Preferred

CA7: 5+ years

Teradata SQL experience: 5+ years

Job Description

Seeking Teradata SQL developer/lead and data analyst with experience working on an IBM Mainframe to build custom output files for our clients/vendors. Candidates will need to quickly get familiar with the Enterprise Data Warehouse that sources our output data and be able to write SQL queries to extract the data needed to deliver on client requirements. This role also includes leading and giving guidance to less experienced team members.

Job Specifics

Candidate must have experience working in an Agile environment and with being a collaborative member of an Agile team. Candidate must be good communicator and have strong people skills.

Must be able to create Technical designs and solutions that deliver quality solutions for client and business needs.

Must have a thorough understanding of Teradata- how it processes and stores data and how to write efficient SQL to retrieve data needed

Participate in all technical phases of each project assigned.

Accountable for quality and timeliness of product development, technical design and solution implementation as a development team member.

Partners with QA teams to resolve solution design deficiencies and related deliverables.

Troubleshoots, maintains, and develops application and system solutions for business mandated products and regular operational processes.

Skills

• .

• Job Qualifications required

• IBM Mainframe: 5+ years

• JCL: 5+ years

• Unix : 3+ years - Preferred

• CA7: 5+ years

• Teradata SQL experience: 5+ years

• Cloud tool experience (AWS/OpenShift) - Preferred

• Job qualifications considered a plus

• Previous experience in Health care or PBM (Pharmacy Benefits Manager) industry experience

• Jira

• PBM or Health Care business experience