Looking for ETL Data Engineer. 80% of the work is on SQL development. Required qualifications include 7+ years of experience and the following skills: SQL (complex queries, stored procedures), ETL, Hadoop, Python, Oracle/Teradata/Vertica. Top skill required for the role is SQL -- must have 10/10 in SQL expertise level (e.g. 10 on scale from 1 to 10).
SQL Data Engineer With ETL And Python | Cupertino area, CA
- Employment Type: Contract, Corp-to-Corp with your company or 1099
- Work Status: US Citizens, Green Card, GC-EAD , OPT EAD
No H1B
- Rate: $50/-hr c2c
- Duration: 12-18+ Months Contract extendable
- Other: Interviews via Webcam/Locals F2F may required
We are looking for SQL (Structured Query Language) developers.
We are NOT looking for Hadoop or Informatica developers.
What we need to see is hands on Structured Query Language development in this environment: 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, Data Profiling.
Writing complex SQL Queries, Stored procedures, Triggers, Views, DDL, DML and UDFs to implement the business logic.
Wrote PL/SQL scripts for pre & post session processes and to automate daily loads.
Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
Extracted data from Teradata database. Design and develop methodologies to migrate multiple development/production databases from Sybase to Oracle 11g.
• Worked on data migration and data conversion using PL/SQL, SQL and Python to convert them into custom ETL tasks.
• Worked on performance tuning of ETL code and SQL queries to improve performance, availability and throughput.
• Involved in ingesting data into Data Warehouse using various data loading techniques.
• Involved in Data Mapping specifications to create and execute detailed system test plans.
• Extensively used joins and subqueries to simplify complex queries involving multiple tables
• Tuned existing ETL SQL scripts by making necessary design changes to improve performance of Fact tables.
Position Details:
- Must have very strong SQL and/or PL/SQL
- 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
- 1-2 Years experience with Python Coding and Scripting
- Preferred reporting tools: MSTR/Tableau/SSRS/BO
- Work with data infrastructure to triage infra issues and drive to resolution.
- SQL/Pipeline experience, experience with HIVE or HBASE is a strong plus
- Demonstrated ability and drive to learn new technologies, Tableau or other visualization tool.
- In effect, 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.
=== FILL FORM ===
Please fill the form below, skills matrix, and attach the following: resume, copy of Driver License, copy of work authorization.
- Full Legal Name: ___
- Cell No: ___
- Email ID: ___
- Skype ID: ___
- LinkedIn Profile: ___
- Work authorization, expiration: ___
- Can work on corp-to-corp contract with current employee: ___
- Employer and manager name and contact for corp-to-corp: ___
- BS/MS Degree type, major, name of college, location, year of graduation: ___
- Current Location (city/state): ___
- Availability Date to Start: ___
- Last 4 digits of SSN (may be optional or required): ___
- Birthday (MMDDYY):
- Have you ever been submitted to the Client listed on the Job Description? (if so, when) ___
- When did your current project end or is ending (Month and Year)? ___
- Will you work 100% on-site at the client location listed on job description? ___
- Will you go for a final interview face-to-face (not Skype)? (at candidate or their employer expense at the end client location listed in the job description): ___
- Current salary or rate and target salary or rate: ___/___
| Skill Listed on Job Description | Years of Experience | Year Last Used |
| SQL (Complex queries, Stored procedures) | Years | |
| ETL | Years | |
| Hadoop | Years | |
| Python | Years | |
| Oracle | Years | |
| Teradata | Years | |
| Vertica | Years | |
| Hive | Years | |
| HBASE | Years | |
| MSTR/Tableau/SSRS/BO Indicate which one you have: | Years |
Garima Gupta | Technical Recruiter | Apetan Consulting LLC
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment