Need...Teradata SQL Specialist

Teradata SQL Specialist

Location: Hoboken NJ

Duration 1year

Interview Mode: Phone

 

8 Years plus Overall  Experience.

Minimum 8 Years SQL development  and performance optimization

Candidate must be strong and great communications skills.

Job Description:

- Minimum 8 Years SQL development and performance optimization

- Understand and maintain the Teradata code including ETL and Semantic Layer

- Teradata Macro and SQL Development

- Teradata UDF Knowledge

- Understand and maintain the TPT scripts

- Understand and support all connection points of the Teradata code in the semantic layer with the MicroStrategy Code

- Teradata SQL Developer Level Skills

- ETL Support support during the data loading cycle.

- Creating packages and deployment document for Teradata Admin. Maintain normal Marsh process for different environments. This is to support he lifecycle of code migrations from Dev to UAT to Production

- Deploy Teradata Packages based on instructions from Teradata Developer

- Performance Testing - whenever required, Teradata resource will support the Performance team to help them in building the script for performance testing.

- Update existing documentation of system by component (LPM, WCPA, Collateral) in drill down fashion to more detail (both visually and code comments)

- Code changes to support scripts that are database agnostic and make changes to components of GIDS references to our REF database

- Communicate implications of a business enhancement to other Teradata components

- Understand current processing 'breaks' to know what steps need to run if a changes is made (e.g. only need to run WCPA refresh vs full SL refresh)

- Clean up Teradata environment for all objects not directly related to production scripts (e.g., objects with user names appended)

 

 

Thanks and Regards

Shweta Ojha

Sr. Technical Recruiter | Sage Group Consulting

Direct: 732-784-6492

Email: sojha@sagetl.com

Gtalk: sojha1290|Ymail: ojha1290

 

 

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.