Job Description :
Role: Datawarehouse Developer
Location: Madison, WI
Duration: Long Term
Locals Preferred
This position is needed for advanced business analysis, database design, ETL design, and data warehouse support for enabling UI reporting and data-driven decision making. Best-qualified candidates will have strong experience using Oracle, Erwin, Informatica and Business Objects in a data warehouse environment. Knowledge of Tableau, Python and other business intelligence tools is desirable.
This position will do the following: work with advanced-level accountants and other business customers to understand their data analysis and reporting requirements; design data warehouse table structure to satisfy business requirements, identify data source, develop strategies for data extraction from source systems, design transformation and loading into data warehouse target systems; develop, implement, and follow technical and process standards; develop strategies for system fault tolerance, data recovery and purge; work to improve the efficiency of data warehouse applications through the use of indexes, compression, and other techniques; work within both formal and “agile” application development project management methodologies; function as a database liaison on the business intelligence team.
Qualified candidates must have prior experience in data warehouse design and construction. Preference will be given to qualified candidates familiar with State of Wisconsin application systems, procedures and development standards. Preference will also be given to candidates with experience with insurance and accounting data and data warehouses
Hardware/Software Environment:
Oracle 11g or 12c
Business Objects XI (Designer, Deski, WebI)
Informatica
PL/SQL
ERWin
SQLNavigator
MS-Team Foundation Server
Distributed Control-M job scheduler
Visual Studio
Information Technology - Databases
Data flow and structure modeling 0 years
Data Warehouse - Experience in data warehouse design and development 6 years
Data Warehouse - Experience in requirements gathering for data warehouse 6 years
Data Warehouse - Performance tuning 6 years
Data warehousing 6 years
DB2 6 years
Experience in extract, transform, and load coding using Informatica 6 years
Oracle 6 years
Oracle SQL tuning 6 years
SQL Client tools 6 years
Information Technology - Design
Data modeling 6 years
Information Technology - Languages/Tools
Business Objects 6 years
SQL 6 years
Information Technology - Network/Infrastructure
Experience with Oracle PL/SQL 6 years