Job Description :
Hi
Role: Teradata Developer
Hire Mode – 6+ month Contract
Location – Saint Louis, Missouri
Interview: Weekend Skype Interview Drive (2/17/2018)
Must have:
Minimum 7+ years of IT industry experience
4+ years of Teradata Development experience
Basic ANSI SQL understanding
ETL concept
Job description
Teradata Development
Primary Index, Secondary Index, Join Index
Spool space, Perm space, Temp space
Teradata Utilities, Partitioning
Tables types and their usage
AMP/Bynet/Node/PE/Hash concept
How Teradata stores & retrieves data
Different locks, Join strategies
Skewness, Stats, Explain plan
Performance tuning, how to perform row to column and column to row transpose
Basic ANSI SQL understanding
Joins, analytical functions, OLAP vs OLTP
DW architecture - star vs Snowflake schema, SDLC process
ETL concept
Requirement gathering, ETL concept
Restartability strategy
Scheduling concept
Unix knowledge
Suresh
Osair Technologies Inc