ETL Developer

Integrated Resources Inc.

Wilmington (NC)

On-site

USD 80,000 - 110,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading company in workforce solutions is seeking an ETL Developer to work on a project involving Microsoft SQL Server and Business Intelligence applications for a fiber optic manufacturing facility. The role requires experience in integration, reporting, and analysis systems development, along with strong SQL skills. Candidates with a BS in Computer Science and at least 5 years of relevant experience are encouraged to apply.

Qualifications

Must have at least 5+ years of experience in Information Technology.
Required education is a BS in Computer Science or relevant degree.

Responsibilities

Create SQL Server database structures, integration packages, reports, and analysis services.
Design, code, support, and maintain IT applications for Microsoft BI solutions.
Maintain adherence to company standards and procedures.

Skills

Integration systems development

Report design and development

Analysis Cube design

Data warehouse/ETL/BI Solutions

Relational databases knowledge

T-SQL and MDX query building

Familiarity with data warehousing

Education

BS Computer Science

Tools

Microsoft SQL Server Business Intelligence Development Studio 2012

Informatica

Job description

Integrated Resources, Inc., is led by a seasoned team with combined decades in the industry. We deliver strategic workforce solutions that help you manage your talent and business more efficiently and effectively. Since launching in 1996, IRI has attracted, assembled and retained key employees who are experts in their fields. This has helped us expand into new sectors and steadily grow.

Job Description

Position: ETL Developer

Duration: 6+ Months

Direct client: Immediate interview

Scope of Position

Create SQL Server database structures, integration packages, reports, and analysis services to support a MES deployment in a fiber optic manufacturing facility. Design, code, implement, support, and maintain Information Technology applications associated with the Microsoft Business Intelligence suite of solutions, both as an individual performer and as a member of a project team. Maintain adherence to company standards and procedures.

Required Skills

Ability to analyze, design, develop, implement and maintain integration, reporting, and analysis systems for a manufacturing environment using Microsoft SQL Server Business Intelligence Development Studio 2012
Experience in developing reports design and development using SSRS
Experience in Analysis Cube design and development using SSAS
Full Life Cycle Experience in Model, Design, Development of Data warehouse/ETL/BI Solutions
Knowledge of relational databases (primarily Oracle and Microsoft SQL Server)
Ability to build both SQL and MDX queries for integration or reporting services. Expert in transact SQL (Oracle and MS SQL Server)
Familiarity with data warehousing concepts and design

Desired Skills