Teradata developer

Cygnus Professionals; Alpharetta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

Cygnus Professionals is looking for an experienced IT professional skilled in relational database development. The ideal candidate should have over 7 years of experience, particularly with NCR Teradata and SQL, and be well-versed in the Software Development Life Cycle (SDLC) of data warehousing projects.

Responsibilities include writing and implementing scripts, constructing Kornshell driver routines, and ensuring 24x7 emergency response availability. Certification in Teradata is preferred.

Qualifications

• Minimum of 7 years of relevant work experience in the information technology field.
• Minimum of 5+ years strong NCR Teradata and SQL experience.
• Teradata certification preferred.

Responsibilities

• Use Teradata utilities fastload, multiload, tpump to load data.
• Write BTEQ scripts to transform data.
• Gather system design requirements, design and write system specifications.

Skills

NCR Teradata

SQL

UNIX

Data Warehouse Modeling

Teradata Utilities

Education

Certification in Teradata and Teradata SQL

Job description

Primary Skills: Relational database development

Minimum of 7 years of relevant work experience in the information technology field. Participated in full Software Development Life Cycle (SDLC) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.

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.

Must Be Able To

1. Use Teradata utilities fastload, multiload, tpump to load data.
2. Write BTEQ scripts to transform data.
3. Write Fastexport scripts to export data.
4. Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
5. Construct Kornshell driver routines (write, test and implement UNIX scripts).
6. Write views based on user and/or reporting requirements.
7. Gather system design requirements, design and write system specifications.
8. Will be expected to be available for on‑call response in order to provide 24x7 emergency response capabilities.
9. SQL proficient.

Additional Information

All your information will be kept confidential according to EEO guidelines.