ETL Developer

TECHNOVIZ LLC; Madison (WI); On-site; USD 95,000 - 125,000; Full time

Job summary

TECHNOVIZ LLC in Madison, WI is seeking a BI/ETL Architect to design and build the data warehouse and all related ETL workflows for BI projects.

You will develop complex universes and dashboards using Webi, Xcelsius, Tableau, and other BI tools, while documenting specifications and performing thorough unit tests.

Qualifications

• Bachelor Degree in Computer Science, Engineering (any). Business, Science or Related plus 5 years experience as Computer Software Professional.
• Experience designing data warehouse and ETL processes for BI projects.
• Proficiency with SQL and BI tools (Informatica, Tableau, Webi, Oracle, SQL Server).

Responsibilities

• Design and create the data warehouse and all related ETL data functions.
• Design and create complex universes, Webi reports and Xcelsius Dashboards.
• Document technical specifications for all ETL processes and perform unit tests.
• Extract/Transform/Load (ETL) data for BI projects.

Skills

ETL design

Data warehousing

Unit testing

Documentation

Education

Bachelor's degree in Computer Science, Engineering, Business, or related

Tools

Informatica

Webi reports

Xcelsius Dashboards

Tableau

Oracle

SQL Navigator

SQL Server

Business Objects

SQL

Job description

Job Requirements

Designing and creating the data warehouse and all related extraction, transformation and loading data functions. Designing and creating complex universes, Webi reports and Xcelsius Dashboards.

Document all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.

Extract/Transform/Load (ETL) Data for Business Intelligence projects.

Utilize SQL and database skills, Informatica, SQL Navigator, Oracle, SQL Server, Business Objects, Tableau.

Other Experience and Qualifications

Requirements: Bachelor Degree in Computer Science, Engineering (any). Business, Science or Related plus 5 years experience as Computer Software Professional.

Jobs based in Madison, WI. No travel (US or Intl), but 40% chance of relocation to unanticipated locations throughout the U.S.