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)

Featured Jobs Financial Manager (Jobs in Nashville, Tennessee) EPIC Implementation Consultant (Jobs in Nashville, Tennessee) Help Desk Software TechLead (Jobs in Jackson, Mississippi) SSRS ASP.Net&C# JavaScript Xml Developer (Jobs in Jackson, Mississippi) Analyst (Jobs in Jackson, Mississippi) MS Analyst (Jobs in Jackson, Mississippi) - - Consultant (Jobs in Chattanooga, Tennessee) FTP/SFTP SIEM Administrator (Jobs in Pontiac, Michigan) PMP Microsoft Manager (Jobs in Richmond, Virginia) Customer Analyst (Jobs in Raleigh, North Carolina)