Application and SQL Developer

California Creative Solutions Inc.

Job Location:

Sacramento, CA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Roles/Responsibilities:

Design develop and modify software applications as needed.
Design develop and modify relational and multidimensional database structures relationships data flows and data interfaces within the data warehouse as needed.
Modify the data load ETL processes as needed to Extract Transform and Load data from various data sources into the outage management data warehouse.
Analyze and modify the data structures within a data warehouse to adapt them to business needs and add enhanced functionality.
Use programming languages software development methods best practice programming techniques and department standards guides to develop new data warehouse structures and reports and to modify existing ones.
Unit test and debug code prior to delivery to stakeholders.
Participate in requirements gathering and analysis technical design testing documentation and planning.
Consult with stakeholders to gather information about needs objectives functions performance expectations and input and output requirements. Identify and propose technical alternatives to solving their requests and system problems and recommend the best alternative.
Follow department standards and create written documentation and diagrams as required and/or requested (e.g. technical specifications technical alternatives structure charts data flow diagrams) for both new functionality and modifications to existing functionality.
Consult with functional areas as requested to aid in the development of their test scenarios test plans and test scripts.
Strong oral and written communication especially when communicating technical information to the non-technical user community.
Establish and maintain effective working relationships and work effectively in diverse teams.

Mandatory Skills:

7 years of experience using Visual Studio and C#.
SQL Server/RDBMS 7 Years Experience.
Experience with RESTFul APIs and JSON.
Strong proficiency in writing and debugging C# code (provide examples in resume that demonstrates this).
Strong proficiency in writing SQL (provide examples in resume that demonstrates this).
1-year Electric Utility experience.
Technical Requirements: Provides experience in resumes that demonstrates qualification in these areas:

Microsoft SQL knowledge.
C# Experience.
Experience with SQL Server and query optimization.
.NET Framework.
.NET Core.
Winforms or Windows Presentation Foundation (WPF).
RESTFul APIs.
Web Services.
JSON.
XML.

Desirable Skills: Provides experience in resumes that demonstrates qualification in these areas:

Experience with MongoDB Postgres Cassandra.
MVC.
Design Patterns.
Blazor.
HTML.
PowerBI.
Mongo.
Python.
XSLT.
Linq.
SVN.
GIS (GTECH ESRI).
AMI (Itron).
Multispeak.
SQL Server spatial functions.
SOAP Web Services.
PI.
Windows API.

Roles/Responsibilities: Design develop and modify software applications as needed. Design develop and modify relational and multidimensional database structures relationships data flows and data interfaces within the data warehouse as needed. Modify the data load ETL processes as needed to Extra...

Roles/Responsibilities:

Design develop and modify software applications as needed.
Design develop and modify relational and multidimensional database structures relationships data flows and data interfaces within the data warehouse as needed.
Modify the data load ETL processes as needed to Extract Transform and Load data from various data sources into the outage management data warehouse.
Analyze and modify the data structures within a data warehouse to adapt them to business needs and add enhanced functionality.
Use programming languages software development methods best practice programming techniques and department standards guides to develop new data warehouse structures and reports and to modify existing ones.
Unit test and debug code prior to delivery to stakeholders.
Participate in requirements gathering and analysis technical design testing documentation and planning.
Consult with stakeholders to gather information about needs objectives functions performance expectations and input and output requirements. Identify and propose technical alternatives to solving their requests and system problems and recommend the best alternative.
Follow department standards and create written documentation and diagrams as required and/or requested (e.g. technical specifications technical alternatives structure charts data flow diagrams) for both new functionality and modifications to existing functionality.
Consult with functional areas as requested to aid in the development of their test scenarios test plans and test scripts.
Strong oral and written communication especially when communicating technical information to the non-technical user community.
Establish and maintain effective working relationships and work effectively in diverse teams.

Mandatory Skills:

7 years of experience using Visual Studio and C#.
SQL Server/RDBMS 7 Years Experience.
Experience with RESTFul APIs and JSON.
Strong proficiency in writing and debugging C# code (provide examples in resume that demonstrates this).
Strong proficiency in writing SQL (provide examples in resume that demonstrates this).
1-year Electric Utility experience.
Technical Requirements: Provides experience in resumes that demonstrates qualification in these areas: