BI ETL Consultant

Posted Yesterday
Be an Early Applicant
Skokie, IL, USA
In-Office
Junior
Big Data • Cloud • eCommerce • Software
The Role
Design, develop, test and document ETL processes and ensure data accuracy and integrity. Build data marts/star schemas using Kimball best practices. Perform hands‑on ETL development and advanced SQL work. Collaborate on analysis, coding, and testing; apply big data and NoSQL knowledge as needed.
Summary Generated by Built In
Company Description

Dunn Solutions Group is a full-service information technology consulting firm. We bring exceptional strategic experience, design skills and technology expertise to every project, plus complementary capabilities in client education.
 Focused on the business intelligence, application development and web/portal spaces, Dunn Solutions Group delivers services worldwide through offices in Chicago, Minneapolis, Raleigh, St. Louis, and Bangalore, India.
 We work closely with our software vendor partners including SAP, Liferay, Microsoft, Informatica and others to deliver solutions to our clients.
 Our IT professionals and business experts bridge the gap between business needs and technical solutions. Over the years, we have cultivated our experience and knowledge in a large number of industries and technologies in order to provide our customers with the most valuable solutions possible.
Specialties
Business Intelligence, Custom Application Development, Mobile Applications, Data Warehousing, Portals, E-Commerce
Website
http://www.dunnsolutions.com

Job Description

Experience
    1- 3 years of experience
Technical Skills
    Ensure accuracy and integrity of ETL; analysis, design, coding, testing and documentation
    Hands-on ETL developer (in one or more tools)
    Hands-on experience with designing data marts / star schemas following Kimball best practices
    Deep technical knowledge and hands-on experience with SQL
    Computer Science degree
Pluses
    Experience with SAP Data Services or Informatica or SSIS (or any combination)
    Experience with Talend or Pentaho
    Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)
    Experience with NoSQL databases
    IOT (Internet of Things)

Qualifications

 Experience with SAP Data Services or Informatica or SSIS (or any combination)
    Experience with Talend or Pentaho
    Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)
    Experience with NoSQL databases
    IOT (Internet of Things)

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

  • 1-3 years of experience
  • Hands-on ETL development experience (one or more ETL tools)
  • Design data marts / star schemas following Kimball best practices
  • Deep technical knowledge and hands-on experience with SQL
  • Computer Science degree
  • Experience with SAP Data Services
  • Experience with Informatica
  • Experience with SSIS (SQL Server Integration Services)
  • Experience with Talend
  • Experience with Pentaho
  • Experience with big data technologies (Hadoop, Hortonworks)
  • Experience with NoSQL databases
  • Experience with IoT (Internet of Things)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Skokie, IL
75 Employees
Year Founded: 1988

What We Do

Dunn Solutions Group is a digital commerce & business transformation consultancy focused on delivering velocity to our clients. DSG helps our clients achieve speed by automating business processes (application development), and direction using advanced analytics.

Similar Jobs

Caterpillar Logo Caterpillar

Digital Content Specialist

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Hybrid
Chicago, IL, USA
1000000 Employees
89K-134K Annually

Caterpillar Logo Caterpillar

Enterprise Payments Governance & Operations Lead

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Hybrid
Chicago, IL, USA
1000000 Employees
148K-240K Annually

Caterpillar Logo Caterpillar

Data Scientist

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Hybrid
Chicago, IL, USA
1000000 Employees
98K-158K Annually

Caterpillar Logo Caterpillar

Product Owner

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Hybrid
Chicago, IL, USA
1000000 Employees
98K-158K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account