Previous Job
Previous
FTE-Apple-Infosys - Teradata Engineer / BigData Developer - Sunnyvale, CA - Full Time
Ref No.: 18-31359
Location: Sunnyvale, California
Position Type:Direct Placement
Start Date: 05/07/2018
 
 Technology  Role   Job Description Screening Questoins
Hadoop / Hive / Spark
(Big Data Developer)
Data engineer / Tech Lead Hands on experience with Big Data systems, building ETL pipelines, data processing, and analytics tools
Understanding of data structures & common methods in data transformation.
Familiar with the concepts of dimensional modeling.
Sound knowledge of one programming language - Python or Java 
Programming experience using tools such as Hadoop and Spark.
Strong proficiency in using query languages such as SQL, Hive and SparkSQL
Experience in Kafka & Scala would be a plus
1. Are you willing to take up a 100% hands on job?
2. SQL programming skills - should be able to write complex SQLs (self rating 7 out of 10 or above)
3. Hive programming - Are you comfortable with advanced analytical functions?
4. Do you uderstand Hadoop architecture? 
5. How many end-to-edn implementation expreinces do you have ? we are looking for at least 2 prjects
6. we require you to be proficient in one fo the progamming languages? Python or Java
Teradata
(Teradata Developer)
Data engineer / Tech Lead Sound Knowledge of BI and Data Warehousing
Knowledge of Teradata architecture
Ability to play a Techno Functional role (business analyst experience and project management exposure would be a plus)
Experience in designing and developing ETL data pipelines
Proficient in writing complex SQLs, expertise in performance tuning of SQLs
Hands on experience in database and table design
Excellent knowledge of data loading tool stack TPT, FastLoad, MLoad, TPump
Working experience with huge volumes of data would be an advantage
Expected to lead offshore database engineers
Understanding of data analytics principles and reporting tools would be an advantage
1. Are you willing to take up a 100% hands on job?
2. SQL programming skills - should be able to write complex SQLs (self rating 7 out of 10 or above)
3. Teradata programming - Are you comfortable with advanced analytical functions?
4. Do you uderstand Teradata architecture? 
5. Have you written stored procedures in teradata?
6. we require you to be proficient in one fo the progamming languages? Python or Java
7. Can you do performance tuning of queries for large tables (500 Million to 1Billion rows etc)

These above two requirements have infinite positions . Location Bay Area
4+ yrs – TL --- $100k
7+ yrs – PM/Tech Architect -- $120 K to $125K
NOTE: 80% need will move around these two positions
 
9+ yrs – SPM – 145k to $190K
NOTE: 20% need will move around this.
 
IMPORTANT THHINGS TO CONSIDER --
The name of the group will be data analytics.
Major skill in the requirement is 100% hands-on in SQL, self rating should be 8/10
Refer to the screening questions above
100% understanding of the architecture, Teradata utilities
Understanding of Deep Complexities of SQL
Client expect 5--10 resumes for each requirement everyday.
Mode of Interview—local—inperson
                                   Non local—Video call
Interview timings – everyday from 4 pm to 6 pm