Duration: 6 months initial contract - W2 only + possible extension

No C2C/ Corp to Corp/ 1099

Need candidates in local to San Jose, CA and/or nearby. Onsite interview.

No functional and cloud side and data analyst.

More interested in people who have ETL developer, SQL database developer, DWH/ Data-mart background

Job Description:

• Need a senior candidate - majorly supporting the back end development / Bug Fixes / enhancements for the dashboards for various business teams
• Working with different business channel partners/sales data, salesforce/ crm is a plus
• Looking for someone in strong SQL expr, heavy in PL/SQL solutions, analytical skills
• Data warehousing background- creating data mart solutions - required good warehousing concepts - solid in the back end side to creating these solutions
• Develop/performance tune complex SQL (PL/SQL and/or T-SQL) queries and stored procedures.
• Create single source /data layers; structures for 1 or 2 tables, exiting data source and how the data is being used/reporting
• Create new query to build a dashboard for Business active customers
• Do pull requests and deploying code to different environments
• Tableau should be able to open it up and review it - at least in dash-boarding (using tableau-to make changes)
• Scripting is a plus like airflow, fronttab but to understand how these scripts work

Requirements

• 7-10 years of experience with Database Development using Packages/Stored Procedures/Triggers in SQL and PLSQL
• 7-10 years of experience in Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD)
• 7+ years of experience in SQL performance tuning and optimization techniques
• Ability to work on on ad-hoc requests and should be able to work on simultaneous projects or tasks
• Effective and positive communication and Team working skills.