Previous Job
Technology Lead | Database | Teradata
Ref No.: 18-00028
Location: Sunnyvale, California
Position Type:Contract
Start Date / End Date: 01/01/2018 to 03/31/2018
Job Description: DNA:
Job Title* Technology Lead | Database | Teradata

Work Location* Sunnyvale CA 94086
Client Name*Apple Inc Limited
Vendor Rate*59.00
Contract duration (in months)* 6
Target Start Date* 01 Jan 2018

Does this position require Visa independent candidates only? No

Job Details:

• Technical Skills:

• 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 loding 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:
Drug test details: No