Job Description :
Title: Data Warehouse Developer II Position.

Duration: Long Term Contract.

Location: Madison, WI.

Rate: $59/hr on C2C.

OPT, CPT, H4, H1B, H1Transfer, GC, Citizens are Accepted

Telephonic + F2F Interview Mandatory.

Client: State of WI: Dept-DWD.

Preferred Employment

· Corp-Corp

· W2-Permanent

· W2-Contract

· 1099-Contract


The person in this position will be functioning as a lead Informatica developer and data modeler, working with the BI team and business customers to model BI structures and define and build ETL processes for new and existing BI environments. This person will also function as a Business Objects and Tableau Developer as needed.

Hardware/Software Environment:

Informatica 8.1.1


Business Objects 4.2



Oracle Client

SQL Navigator

Ultra Edit

Beyond Compare

Control-M Job Scheduler

ERWin Model Manager


Additional Comments:

Previous work experience in government, insurance, accounting, or case management systems a plus, and experience with DWD's Business Intelligence environments will be especially valuable.

The ideal candidate will have extensive experience with Informatica and data modeling, some experience with Business Objects and Tableau, be a quick learner, very much a team player, and able to function as a lead developer on a challenging, high profile development projects.

All candidates submitted with inconsistencies or falsifications in their credentials will be disqualified and DOA Purchasing will be notified. An in-person or live video interview will be required as part of our review process.


Must Have

Administration - Project Management

Change management and 5 years

Methodologies - Understanding of project management methodologies and experience with 'agile' and 5 years

General Competencies

Analytical/problem solving skills 5 years

Excellent oral and written communication skills and 5 years

Information Technology - Commonly Used Software

Excel (MS) and 5 years

Information Technology - Databases

Data Warehouse - Experience in data warehouse design and development 5 years

Data Warehouse - Experience in requirements gathering for data warehouse 5 years

Data warehousing and 5 years

Experience in extract, transform, and load coding using Informatica 5 years

Oracle and 5 years

SQL Client tools and 5 years

Information Technology - Design

Data modeling and 5 years

Information Technology - Requirements

Documenting requirements and 5 years

Experience as a developer in large, very complex organization and 5 years

In-Depth Knowledge of System Development Life Cycle Deliverables for each Phase of Development 5 years

Requirements analysis and 5 years

Requirements gathering and 5 years

Information Technology - Testing

User test, System test, and User Acceptance test plans and 5 years

Nice to Have

Information Technology - Commonly Used Software

Outlook (MS) 5 years

Word (MS) and 5 years

Information Technology - Languages/Tools

Team Foundation Server 5 years

Information Technology - Network/Infrastructure

Experience with Oracle PL/SQL and 5 years

Information Technology - Software

SAP Business Objects Development 5 years

Tableau Development 2 years

Information Technology - System Monitoring/Automation

Control M