APPLICATION AND SQL DEVELOPER

  • Sacramento, CA
  • Posted 1 hour ago | Updated 1 hour ago

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 6 Month(s)

Skills

Application Developer
SQL Developer
relational
multidimensional
database structures
relationships
data flows
data interfaces
ETL
Extract
Transform
Load data
Data Flow
Data Loading
Data Structure
Data Warehouse
Data-flow Diagrams
Database
Debugging
Documentation
Esri
Extract
Transform
Load
Interfaces
Microsoft SQL Server
MongoDB
PostgreSQL
Programming Languages
Query Optimization
RESTful
Reporting
Requirements Elicitation
Software Development
SQL
.NET
Specification Gathering
Microsoft SQL
C#
SQL Server
.NET Framework
.NET Core
Winforms
Windows Presentation Foundation (WPF)
RESTFul API's
Web Services
JSON
XML
Cassandra
MVC
Design Patterns
Blazor
HTML
PowerBI
Python
XSLT
Linq
SVN
GIS
GTECH
AMI (Itron)
Multispeak
SQL Server spatial functions
SOAP Web Services
PI
Windows API
Test Plans
Test Scenarios
Test Scripts
Testing
Unit Testing
WPF
Technical Drafting
Management
Knowledge Transfer

Job Details

APPLICATION AND SQL DEVELOPER 6 Months Sacramento, CA (Hybrid)
Job Duties:
  • 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 our 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. Documentation may include technical specifications, technical alternatives, structure charts, data flow diagrams, etc. for both new functionality and for 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.
Technical Requirements
  • Microsoft SQL knowledge
  • C# Experience
  • Experience with SQL Server and query optimization
  • .NET Framework
  • .NET Core
  • Winforms or Windows Presentation Foundation (WPF)
  • RESTFul API's
  • Web Services
  • JSON
  • XML
Desirable Qualifications
  • 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
Assumptions
  • Contractor must have reliable internet, work exclusively within the United States.
  • Contractor will be onsite at client s location in Sacramento, CA.
  • This is a hybrid task, Contractor will be required to be on-site during the 1st month of the task for on-boarding and knowledge transfer. After that resource will work with the Task Manager for a hybrid schedule ensuring 50% of onsite reporting for the resource.
  • Daily Schedule of the resources will be between 7am 5pm (PST), Monday through Friday. This will be a full-time position.
  • The resource must be available to start work on the task s start date.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.