Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
RDBMS Data Warehousing Kimball Methodology SQL Server. T SQL PowerDesigner ERwin En
 
Requirement id 64693
Job title Engineer
Job location in Hartford, CT
Skills required SQL Reports, Software Engineer, RDBMS, Data Warehousing Kimball Methodology SQL
Open Date 09-Oct-2017
Close Date
Job type Not specified
Duration 8 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Engineer: SQL Reports, Software Engineer, RDBMS, Data Warehousing Kimball Methodology SQL

Submission Deadline : 10/11/2017

Client : Department of Children and Families

Description :

* Title: SQL Reporting
* Position Category: System Engineering Support
* Position: Software Engineer 2
* Duration of Assignment: 250 days
* Assignment Location: Hartford CO

The agency needs to continue the service of this Software Engineer 2 consultant position. The candidate will participate in the design and development activities in support of the agencys continued development of a CCWIS application/project and other SQL Server based applications. The specific focus of this candidate will be the key CCWIS project support, CCWIS enhancement design and development of CCWIS environments and other SQL Server based applications.

REQUIRED TECHNICAL SKILLS AND EXPERIENCE:

Refer to the State contracts for IT Professional Services Agreement (12PSX0251) for general experience and skill requirements for the job classification of Software Engineer 2. For this position, the candidate shares experience and judgment with team to plan and accomplish goals, leads groups in performing a variety of complicated tasks, mentors less experienced staff, a wide degree of creativity and latitude is expected. In addition, the agency requires:

A minimum of nine (9) years of prior experience demonstrating the following knowledge and skills:

1. Understands RDBMS principals such as Table Design, Normalization, ACID properties, Relationships, Referential Integrity and how these apply to SQL Server.
2. Understands Data warehousing principals and is familiar with Inmon and Kimball Methodology.
3. Knows how to optimize physical structures and data processing in SQL Server and T-SQL for OLTP vs. OLAP.
4. Knowledge of Tracing, Monitoring, and Auditing facilities and methods for SQL Server.
5. Create and schedule Batch Jobs to run on SQL Server.
6. Work closely with application developers and business users to design databases.
7. Design databases using PowerDesigner/Erwin, logical and physical level.
8. Develop database objects including tables, indexes, triggers, views, stored procedures and functions.
9. Create DTS packages and jobs to monitor, backup, import/export data and data warehouse extracts.
10. Review peer database design and code.
11. Work on conversion of structured and non structured data.
12. Participate in the definition, documentation and application of our Coding and Naming Standards.
13. Provide support to developers and/or testers to resolve technical problems with data and/or databases.
14. Experience in supporting SQL Server-based .NET applications.
15. Experience in assisting business analysts our business consumers in the modeling their data needs.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 64693 while calling.
 
Other jobs in CT: Bristol (4), Hartford (1), Shelton (6), Westport (1), Windsor (4), Windsor Locks (1),
 
 SQL Reports job openings in other states
Jobs List

CMAS 0000021468 RFO Senior Reports Developer -SP
Create date: 22-Nov-2021
Bid URL: https://caleprocure.ca.gov/event/7920/0000021468

Note: Email Submission
Note: CalSTRS will only accept one (1) offer per Vendor.

Submission Deadline: 11/29/2021 2:00 PM PST
Start Date: 3/1/2022
End Date : 2/28/2023

Client: California State Teachers Retirement Systems (CalSTRS)

De.... (This job is for - job Jobs in CA Sacramento Developer - (in Sacramento, CA))
 
 
(Engineer: SQL Reports, Software Engineer, RDBMS, Data Warehousing Kimball Methodology SQL in Hartford, CT)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved