Description
Pasadena, CA 91124
Position type: w2
Contact duration: 6+months-(strong possibility of extension)
Senior Informatica Web Developer
BASIC QUALIFICATIONS
1. Substantial and recent experience (3 years or more) and expertise in Informatica, up to 8.x.
2. Substantial Oracle/SQL Server database experience and with excellent SQL skills.
3. Excellent analytical and problem solving skills.
4. Experience in solutioning, designing, developing ETL and related reporting processes.
5. Demonstrated abilities to troubleshoot and tune Informatica workflows and complex SQL queries.
6. Team work focused and results oriented.
PREFERRED QUALIFICATIONS
1. Cognos reporting experience.
2. DB2 database experience.
3. Experience working in Agile Development teams
4. Health Insurance industry experience
JOB RESPONSIBILITIES
1. This resource will join an existing team to work on a major Datawarehouse project. This project integrates various internal and outside source data, some with millions of records, into the main database and dedupe/validate/transform data. The result has to be precise, and the processes must be reliable. Thus we are asking for a person who is highly skilled, detail oriented, accepts challenges and gets work done.
2. Performs software coding, testing, debugging, documentation, and installation tasks for on-line processes in accordance with industry best practices and specific internal procedures and standards.
3. Contributes to task identification, work effort estimates, and work schedules for development and maintenance activities.
4. Participates in the analysis and definition of efficient, cost effective application solutions which support client business processes and functional requirements. Specifically you will partner with both business clients, development team and inter-departmental teams within the KP-IT community (eg database development, network support, help desk, client training) to ensure deliverable commitments are met.
5. Conducts analysis of client business processes and functional requirements and prepares appropriate documentation to communicate and validate the information.
6. Provides on-call support as assigned
7. Works as project team member to develop applications for KP business users
8. Ensures compliance with industry best practices
9. Performs code review
10. Performs defect analysis
11. Collaborate with Data Architect/DBA to maintain optimal reporting tables and views
Top 3-5 required skills: ETL, Informatica, SQL
Top 3-5 daily responsibilities: Design, Development
Desired skills: Oracle, Cognos, DB2,
Type of background you are looking for: An ETL developer