Teradata SQL developer/lead and Data Analyst

Ampcus Inc; Morris Plains (NJ); On-site; USD 90,000 - 150,000; Full time

Job summary

iTech Solutions Inc. seeks a Teradata SQL developer/lead and data analyst with IBM Mainframe experience to build custom output files for clients. You will work with the Enterprise Data Warehouse, write SQL to extract data, and support client requirements in an Agile environment.

You will contribute to design, collaborate with QA, and ensure timely, high-quality deliverables while leveraging Teradata and Unix/Linux scripting skills.

Qualifications

• 5 years Teradata SQL experience and strong IBM Mainframe background.
• Agile environment experience and effective teamwork.
• Proficient in Unix/Linux shell scripting.
• Ability to design technical solutions for client needs.
• Bachelor’s degree or equivalent; HS diploma required.

Responsibilities

• Work in an Agile team to deliver data solutions.
• Create technical designs and implement data solutions.
• Write efficient Teradata SQL to extract required data.
• Participate in all technical phases of projects.
• Ensure quality and timely delivery; coordinate with QA.
• Troubleshoot and maintain applications and systems.

Skills

Teradata SQL

IBM Mainframe

JCL

CA7

Agile

Unix/Linux Shell Script

Education

Bachelor’s degree or equivalent

High School Diploma or GED

Tools

Jira

Python

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.

Job Specifics

• Candidate must have experience working in an Agile environment and with being a collaborative member of an Agile team. Candidate must be a 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.
• Must have Unix/Linux Shell scripting experience.
• 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.

Job Qualifications Considered a Plus

• Previous experience in Health care or PBM industry
• Jira
• PBM or Health Care business experience
• Python experience

Skills

• IBM Mainframe: 5 years
• JCL: 5 years
• CA7: 5 years
• Teradata SQL experience: 5 years
• Agile: 3 years
• Unix/Linux Shell Script: 2 Years

Education

• Bachelor’s degree or equivalent in Computer Science, Software Systems, Computer Applications PREFERRED
• High School Diploma or GED REQUIRED

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

iTech Solutions, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.