Sign in

Teradata Lead

Company:
iTech US Inc
Location:
Sunnyvale, California, United States
Posted:
February 15, 2018
Description:

iTech US Inc. provides end-to-end solutions for customized Software Development Solutions and IT consulting services for Fortune 1000 clients.

We Have Teradata Lead Job in Sunnyvale, CA

If you are seeking to apply please do share your updated resume and contact details, best time to reach you.

Job Title: Teradata Lead

Location: Sunnyvale CA 94086

Duration: 6 Months Contract

Job ID: 14538

Job Details:

• Strong Knowledge of TERADATA architecture

• Strong SQL skills

• Strong knowledge in TD performance tuning

• Good working knowledge in utilities like BTEQ, FASTEXPORT, FASTLOAD and MULTILOAD, TPT

• Solid understanding of DW and RDMS concepts

• Should have good Analytical skill

• Meeting clients and get requirements

• Should be able to create BRD

• Should be able to transform BRD to FS

• Good coordination skills with multiple stakeholder

• Very good communication skill and articulation skills

• Able to handle 3-4 members offshore team

1. Architecture - Data Warehousing, ETL (Inbound/Outbound)

2. Teradata

- Primary Index, Secondary Index, Value Ordered Secondary Index, Join Index

- Partition

- Join

- Working with - Transaction, Global Temporary Tables, Work Table

3. Data loading strategy - Semantic

- Incremental

- Complete

- History Load

4. Performance Improvement

- Stat Collection

5. Process

- Coding standard

- Version control

- Change management

Roles & Responsibilities:

• Responsible for overall project delivery

• Partner with Product Manager to perform design playback to business as needed

• Works with Project Manager to finalize, maintain and execute project plans

• Develops High and Low level Design documents, mapping documents and data models.

• Performs and owns the system integration and performance testing

• Supports business team during UAT

• Identifies any product issues and resolves them. PM will track issues

• Manages system cutover to the test environment and production environment and validates product is working

• Identifies any design gaps, reviews with Product Manager/BA and works with business to mitigate the gaps

• Develops functional test case documents and supports PM with test strategy development

• Supports the business training and involves the training team as needed

• Provide warranty support and resolves issues

• Should focus on one business area and limit number of multiple projects at the same time

Detailed Job Description:

Onsite for IBB p1 reports track, Requirement Analysis, Coordination with offshore, Design

Minimum years of experience*:5+

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute*: 1. Client Communication 2. Design 3.

Interview Process (Is face to face required?)No

Any additional information you would like to share about the project specs/ nature of work:

Thanks & Regards

Vignesh

iTech US, Inc

South Berlintion, VT, & TX-NJ-VA-CA & Canada