Teradata Developer

Post Date

Dec 17, 2024

Location

Morris Plains,
New Jersey

ZIP/Postal Code

07950
US
Sep 07, 2025 Insight Global

Job Type

Contract

Category

Database Administrator (DBA)

Req #

STL-752525

Pay Rate

$52 - $65 (hourly estimate)

Job Description

Our healthcare client is seeking a Mainframe Developer to be based in New Jersey. The candidate will work on building custom output files for the Centers for Medicare & Medicaid Services using Teradata to process and stored data, specifically pulling cloud files from the IBM Mainframe. They will write SQL queries to extract the necessary data to meet client requirements and run jobs on the mainframe, including scheduling, loading, and uploading tasks using JCL and CA7. This role operates within an Agile environment with two-week sprint cycles and quarterly PI planning cycles. The candidate will be responsible for creating technical designs, managing file ownership from new teams, planning file scheduling, and ensuring the files meet design purposes and can hold historical data. Additionally, the role requires Unix/Linux Shell scripting experience. The candidate will collaborate with business owners, data teams, and QA teams to achieve deliverables. This position requires onsite presence one day per week, with flexibility according to the teams schedule.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

5+ years of experience with IBM Mainframe
3+ Teradata SQL
JCL (Job Control Language)- to specify the parameters for job execution, including the resources required, the sequence of steps, and the handling of input and output data
CA7-to schedule jobs and manage dependencies
Agile Environment
2+ Years Unix/Linux Shell Scripting
High School Diploma or GED

Nice to Have Skills & Experience

Previous experience in Healthcare or PBM industry
Bachelors degree or equivalent in Computer Science, Software Systems, Computer Applications
Jira for project management

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.