SQL Server and ETL Developer

Consultants has to visit client location 2-3 days in a month

Need local consultant in CA or Bay Area

Job title: SQL Server and ETL Developer

Duration: Long term
Location: Sacramento(CA) 100% Remote
Job Type: Contract

Client: State of CA

Job Description:

Must Have Skills:
? Writing complex SQL queries, Stored Procedures, Views and Triggers using T-SQL
? Expert in implementing ETL solution using SQL Server Integration Services (SSIS), Data Lake and Azure Data Factory
? Experience in implementing complex data migration projects, migrating millions of records from different sources
? Good to have SQL integration services using Azure Synapse
? Working experience in RDBMS skills and Database Design, Normalize and De-normalize techniques
? Data modeling using tools like ER-Win
? DB Build Automation using DevOps and SQL Server Data Tools
? Azure SQL and DevOps 2019 experience
? Experience in using DevOps pipelines and Azure stack
? Expert in writing SQL using PowerShell
? Good to have SQL Server Analysis Services (SSAS) and Power BI experience
? Database builds consolidation and deployment activities
Good to have Skills:
? Dynamics Dataverse and Power Platform experience
? SSRS and Power BI knowledge
? Managing large and complex database systems in on-prem data centers
? Working experience on SQL Database Upgrade projects, migrating databases between data canters
? Familiarity with data analysis, data sciences and analytics
? Strong understanding of data integration issues (validation and cleaning), familiarity with complex data and structures
? Understanding of transformations and data modeling
? Experience in Agile methodology

Thanks and Regards,

Kundan Kumar

Technical Recruiter US Staffing

UCyber LLC

Direct:- Ext:- 103, Email:

Linkedin:

Address: 1309 Cofeen Avenue STE 1200 Sheridan, Wyoming 82801

Website: