ETL Specialist

ETL, DataStage, SQL, datawarehouse
Contract W2
$100,000 - $108,000 /yr
Work from home not available Travel not required

Job Description

Stefanini is hiring!

The Business Analytics team is looking for an ETL Specialist to support the application development of a new customs project initiative in the Supply Chain portfolio. This ETL Specialist must be familiar with building data pipelines to load data from a source database into a data warehouse or data mart. The ETL specialist will also be familiar with databases, writing queries, and should have experience using tools like IBM DataStage. This will be a T&M agile engagement and will require dedicated resources. The expectation is that these resources will participate in daily standup calls and be active members of the agile development team. This candidate will be capable of imagining the front end of a business partner facing solution and delivering a dashboard experience that allows business partners to better make decisions.

The customs team has recently approved a capital project to create new import and export dashboards, to be used when company imports or exports vehicles from the US. In addition to import and export compliance, the project will also facilitate improved duty drawback through penalty reduction. Dashboards will be used for internal business partners to pay a 3rd party supplier to classify drawback payments, giving the company an opportunity to reduce costs. Dashboards will also give business users the ability to track drawback payments and monitor savings.


Responsible for extracting data from various sources, transforming the data as required, and loading it to various target (ETL) database(s) and/or structures

Analyze and review complex object and data models and the metadata repository in order to structure processes and data for accuracy, efficiency, and maintainability

Work with various levels of project managers, data modelers, DBAs, and system administrators to design load processes and identify potential problem areas

Create complex data loading processes for Operational Data Stores, Data Warehouses and Data Marts that satisfy all functional and technical requirements

Collaborate with the Data Architect to understand, interpret, and implement complex data integration requirements

Work with internal business clients to solve data integrity issues and ensure timely data availability

Assist in data load monitoring and problem resolution. Take action to resolve recurring issues

Good experience with DataStage software - development who can advise team on best practices, capabilities and limitations

A successful candidate should have 5 to 7+ years of ETL and database experience, additional analytics experience is a plus.

Experience delivering BI and Data Warehouse solutions with both Dimensional and Relational modeling a plus

Proven experience with SQL and relational databases (Oracle 11g preferred)

Solid design, coding, testing and debugging skills

Strong analytical and good communications skills

Knowledge of standards and practices in BI, Data Warehousing, ETL and DataStage

Ability to develop DataStage guidelines and standards

Excellent communication skills are essential

Familiar with: Windows, Unix/Linux, PL/SQL, Shell Scripting

Required: Bachelor's degree or equivalent experience is needed

We sponsor visa for qualified candidates. Interested applicants may click the apply button or you may call us at (248) 936-0634 for faster processing. Thank you.

Posted By

Jerald Miranda

Dice Id : 10106616
Position Id : 33193
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

ETL / BI / DW / Big data Consultant
  • Reliable Software Resources
  • Northville, MI
ETL Developer
  • Ciber Global LLC
  • Mi
ETL Engineer
  • GalaxE.Solutions
  • Detroit, MI
IT Delivery Lead(Data Warehouse, ETL)
  • ePromptus Inc.
  • Detroit, MI
ODI Developer- With PL/SQL
  • nDimensions
  • Farmington Hills, MI
Data Developer
  • Sparq Solutions Inc.
  • Livonia, MI
ETL/ Hadoop Developer
  • Saanvi Technologies
  • Detroit, MI
Data Warehouse Analyst
  • Kforce Technology Staffing
  • Troy, MI
Database Developer
  • United Shore
  • Pontiac, MI
Dell Boomi Developer
  • Software Guidance & Assistance
  • Southfield, MI
Data Analyst
  • Blue Icy Water, LLC
  • Detroit, MI
Sr. Qlikview Developer
  • Systems Technology Group Inc. (STG)
  • Dearborn, MI
Data Warehouse Developer
  • DynPro Inc.
  • Ann Arbor, MI