Job Description :
Title: Informatica Developer
Location: Madison, WI
Duration: Long Term

Job description:
The candidate will be a strong technical leader working on BI Data Integration projects, gathering & documenting requirements, performing analysis, designing solutions to meet business objectives, developing specifications, developing ETL mappings using Informatica PowerCenter, testing, and implementing solutions. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Seek continuous improvement in performance & tuning and ensure security of data. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Work with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 7 - 9 years experience or equivalent education.

Ideal candidate will have experience designing BI solutions, development experience in Informatica PowerCenter

DW & BI Knowledge areas:
1. Data warehouse/data marts design and development using Kimball & Inmon methodologies
2. Oracle, DB2 and SQL Server
3. Informatica PowerCenter V10.1
4. SQL
5. Dimensional Data Modeling - Star Schemas
6. Slowly Changing Dimensions
7. Requirements gathering and documentation
8. Test plan development and testing execution
9. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support
10. Excellent written and oral communications
11. Independent worker

Informatica (8+years experience):
PowerCenter - ETL
Real Time Engine
Data Profiling
DVO - Data Validation
Metadata Manager
Rapid Prototyping
Data Masking

Database Knowledge (8+years experience):
SQL Server

Client : Direct Client