Previous Job
Previous
SQL Developer
Ref No.: 18-64505
Location: Milpitas, California
Position Type:Full Time/Contract
Start Date: 09/04/2018
 Requirement: •Strong conceptual knowledge in Business Intelligence / Enterprise data warehouse Projects
•             Sound knowledge of one programming language - Python or Java
•             Must have extensive hands-on experience with one of the enterprise data warehouses e.g. Oracle, Teradata, SQL Server, any of the NoSQL DBs
•             Experience in developing complex SQLs, stored procedures
•             Experience in working with all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL
•             Experience in usage of analytical functions
•             Good understanding of Sql tuning for optimized performance - Query performance tuning (Query Plan Analysis, Profiler etc. 
•             Provide necessary recommendations to improve the performance of the slow running SQL queries / ETL processes and should be able to implement and test the changes.
•             Exposure to database modeling & design
•             Knowledge of SQL best practices
•             Knowledge on Distributed systems architecture
•             Excellent problem solving skills (for debugging)
•             Working knowledge in Teradata or Hive would be a plus
•             Experience in working with big datasets would be a plus