Overview
Skills
Job Details
Hi,
We have an open requirement with our client. Please share your updated resume along with your rate and availability to start.
Location: Sacramento
Client: CDPH
Work Mode: Hybrid
Primary Responsibilities:
Maintain and enhance ETLs for importing data from external partners/systems and transferring data from OLTP to the Data Warehouse.
Strong experience required in working with SSIS packages.
Maintain the on-premises STAR schema-based SQL Server Data Warehouse, including:
Building custom views for data reporting
Optimizing query performance
Creating and maintaining tables, stored procedures, and functions
Experience working with denormalized and normalized data sets.
Maintain stored procedures and functions supplying data to application-based reports.
Serve as a backup to the Informatics Lead.
Interface with external partners and communicate technical concepts to non-technical audiences.
Manage product backlog, incidents, and related activities when the Informatics Lead is out of office.
Preferred Experience:
Experience importing data from XML files.
Tableau development or reporting experience.
Database Administrator (DBA) experience.
.NET development experience (preferably version 6+, though any knowledge is acceptable).
Understanding of .NET application integration with databases (ADO).
Thanks & Regards
Divyendu Singh
Siminfotech Inc
Ph: