Teradata Developer

Mintbiz

Cupertino (CA)

On-site

USD 120,000 - 150,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A leading consulting firm is looking for a Teradata Developer in Cupertino, CA. The position requires at least 5 years of experience in data warehousing, with a strong background in Teradata and SQL. Responsibilities include designing and developing data warehouses, creating reporting solutions, and writing BTEQ scripts. Candidates should possess strong analytical skills and proficiency in various ETL tools. This is a full-time, permanent position offering competitive compensation.

Qualifications

At least 5 years experience in Datawarehousing/BI with hands-on expertise in Teradata.
Strong NCR Teradata and SQL proficiency.
Minimum of 5+ years in database, ETL/ELT design, and development.

Responsibilities

Design and deploy large-scale Data Warehouses using Teradata.
Develop reporting and dashboard solutions on the DW platform.
Construct Korn shell driver routines and implement UNIX scripts.

Skills

Critical thinking and communication skills

Problem-solving and analytical abilities

Designing and developing Data Warehouses

Database and ETL/ELT design and development

Reporting and dashboard solutions

Version control systems

Metadata Management

Project management using SDLC

NCR Teradata and SQL proficiency

Writing BTEQ and Fastload scripts

Education

Certification in Teradata and Teradata SQL

Tools

Teradata

Oracle

Informatica

UNIX

Job description

Hi,We are retained by one of the Top 5 Consulting firms in the US which has in its Client list most of the Fortune 500 Companies. We now have multiple full‑time, permanent opportunities for Teradata Developer in Cupertino, CA. Kindly keep me posted with your resume at sam@mint‑biz.com or call me at 703 665 4483 or kindly refer someone who would be a good fit for the opportunity.

Job Details

Job Title: Teradata Developer

Work Location: Cupertino, CA

Term: Full Time Permanent Opportunity

Relevant Experience (Years): At least 5 years experience in Datawarehousing/BI with hands on expertise in Teradata.

Necessary Skills

Critical thinking and excellent verbal and written communication skills
Strong problem‑solving and analytical abilities
Strong experience in designing and developing large‑scale and optimized Data Warehouses using Teradata, Oracle and Informatica
In‑depth hands‑on experience in database, ETL/ELT design and development and should have excellent data analysis skills
In‑depth hands‑on experience in developing reporting and dashboard solutions on DW platform using multiple UI and reporting tools
Experience in deploying solutions using version control systems like Subversion or CVS
Metadata Management, Enterprise data security architecture and Data Warehouse best practices
Project management using SDLC
Minimum of 5+ years strong NCR Teradata and SQL, UNIX, Data Warehouse Modeling, Teradata Utilities, Aggregates and building efficient views; other SQL and UNIX experience plus Teradata certification may be substituted for years of Teradata experience.
Certification in Teradata and Teradata SQL preferred.
Use Teradata utilities fastload, multiload, tpump to load data.
Write BTEQ scripts to transform data.
Write Fastexport scripts to export data.
Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
Construct Korn shell driver routines (write, test and implement UNIX scripts).
Write views based on user and/or reporting requirements.
Gather system design requirements, design and write system specifications.
SQL proficient.