USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Contact Name: DAVE

Job Details: ETL Consultant Date: May 19 2020

Job Reference: 3305
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Full Time, Contract
Degree: High School
Experience: 3 years
Location: Raleigh, North Carolina, 27602
Job Skills: ETL Consultant
Share Job with Others

Job Tools

Job Description

• IT Industry Experience (Required 8 Years)
• Data integration and ETL experience with SQL Server Integration Services (SSIS) or other industry leading tools. (Required 5 Years)
• Experience in SQL programming (Required 8 Years)
• Experience in designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volumes (Required 5 Years)
• Experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain mapping inform (Required 5 Years)
• Strong understanding of data integration, quality and validation (Highly desired 4 Years)
• Understanding of MDM, Data warehouse/data marts (Highly desired 3 Years)
• Clear understanding and experience with Microsoft platforms to include SSIS, DQS and MDS (Highly desired 3 Years)
• Reporting and analytics using SSRS (Highly desired 3 Years)

Description:- State of North Carolina: Department of Transportation (NCDOT)

This individual will be accountable for the successful design, development, and delivery of ETL, data cleansing and data integration solutions using Microsoft and other leading platforms.

This position will work closely with development teams, business, architecture, project management, business analysts, and QA areas.

The scope of the ETL Lead role involves all aspects of the project life cycle from inception to implementation and support.

The ETL Lead will drive the development of best practices for NCDOT and mentor developers, analysts and other members of the team.

The NCDOT IT is seeking a contractor to perform in the capacity of Database/ETL Lead Developer. We are seeking a 12 month assignment.

The individual will be accountable for the successful design, development and delivery of ETL, data cleansing and data integration solution to include development of databases to support development, QA and production environments.

Expected Skills: Able to work without assistance; can provide leadership to others; able to manage highly complex work efforts; may have advanced education; may have extensive industry experience.

1. Data analysis and database management

2. Maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.

3. (Logical) Administration of application objects within database; maintenance of business requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc.); performance of database application tuning; provision of business and data requirements and data for capacity planning

4. (Physical) Environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends.

Copyright © 2020 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.