*Hello Professionals,* *Please reply me at rani.bejja...@veracity-digital.com <rani.bejja...@veracity-digital.com>*
*Title: SQL Data Engineer with SQL and Python* *Duration: 12-18+ Months Contract extendable* *Location: Menlo Park, CA* *Client: Facebook* *Positions Open: 6* *Interview: Video Conf* *Can work on C2CWe need SQL Guru* *Client is looking for SQL EXPERTS WITH STRONG *experience on *Large databases like Teradata/Oracle/Hadoop/Vertica and a knowledge on PYTHON/PERL* for this role (*SQL SERVER PROFILES ARE NOT ACCEPTED*). Must have experience building *ETL from scratch/Manually using SQL Scripts, WITHOUT ANY TOOLS.*Who can build a data mart that can support multiple data sources and customize it for scalability. 80% of the work is on SQL development: Temporary tables, Table variables and Common Table Expressions (CTE), Stored Procedures, Triggers and User Defined Functions, Performance tuning, query optimization and execution plan of queries, Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL and PL/SQL, Incremental Data Load, Slowly Changing Dimensions, Normalization, Constraints, Querying, Joins, Keys, Indexes(i.e., Clustered and Non Clustered), Data Import/Export, Triggers, Functions, Sub Queries, Cursors. Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, DataProfiling *Description :* · Manage reporting/dashboard plans, develop SQL pipelines, design and own data models for a product or group of products. · Interface with engineers, product managers, product analysts to understand data and reporting needs. · Build data expertise and own data quality in allocation areas of ownership. · Design, develop, test and launch new reports, pipelines, data aggregations and dashboards into production. · Provide support to reports, pipelines and dashboards running in production. · Design and manage SLAs for all data sets (existing and new) in allocated areas of ownership · Experience with Python Coding and Scripting · Work with data infrastructure to triage infra issues and drive to resolution. · We would like someone with strong SQL/Pipeline experience, have experience with HIVE or HBASE, demonstrated ability and drive to learn new technologies, Tableau or other visualization tool. · In effect we are looking for a full stack solid engineer with 7-10 years of experience, who has applied his/her skill in data engineering and also in some part visualization. -- *Thanks & Regards* *Rani. Bejjanki* *Veracity- digital* *Email id : rani.bejja...@veracity-digital.com <rani.bejja...@veracity-digital.com>* *Phone : 630-496-5072* -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
