Required Skills

Teradata Developer Teradata and SQL Data Warehouse Modeling Teradata Utilities Aggregates Unix and building efficient views; other SQL and UNIX experience plus Teradata certification

Work Authorization

  • Us Citizen

  • Green Card

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 19th Nov 2020

JOB DETAIL

Job Description: 

• Minimum of 2+ years strong Teradata and SQL, Data Warehouse Modeling, Teradata Utilities, Aggregates, Unix 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.

• 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

• In-depth hands on experience in database, ETL/ELT design and development and should have excellent data analysis skills


• 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

• Use Teradata utilities TPT, fastload, multiload, tpump to load data.

• Write BTEQ scripts and stored procedures 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.

 

Company Information