ETL Developer
At a glance
Mid-level Data Engineering role at Integrated Resources INC. Wilmington · no salary stated · we estimate $112,500–$160,000 across the United States.
Integrated Resources INC has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build SQL Server structures, integration packages, reports and analysis services for a manufacturing execution system deployment
- Develop and support applications across the Microsoft Business Intelligence suite, working independently and with project teams
- Maintain the applications and keep their design and delivery aligned with company procedures
- Create data warehouse and ETL solutions through modeling, design and development
What you bring
- At least five years working in information technology
- Hands-on experience with SQL Server Business Intelligence Development Studio 2012 and ETL development
- A relevant bachelor's degree, such as computer science
- Experience building SSIS packages, SSRS reports and SSAS analysis cubes
Who this fits
This mid-level role suits someone who can deliver BI and ETL work both independently and within a project team. The position is onsite in Wilmington, North Carolina, and runs for at least six months.
From the employer
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.
Position: ETL Developer
Duration: 6+ Months
Location: Wilmington, NC
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 data ETL packages using SSIS
- 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
- Project planning, requirements gathering and analysis, test plan development
- Informatica ETL experience would be a plus
Education and Experience
- Required Education: BS Computer Science or Degree Relevant to job posting.
- Experience Required: At least 5+ yrs. experience in Information Technology.
Manager Must Haves:
- Must have experience with Microsoft SQL Server Business Intelligence Development Studio 2012.
- Must have experience with ETL.
Thanks & Regards,
Nagesh
732-429-1641