Informatica Developer Experience 
- 7+ years of experience in ETL development using Informatica PowerCenter with minimum 2 years experience using PowerCenter 8.x

- 7+ years of experience in Data Warehousing, with thorough knowledge of star/ snowflake schemas

- 5+ years of experience in Oracle database development, using SQL and PL/SQL, with in-depth knowledge of analytical functions

- Experience with Informatica PowerCenter administration a big plus

- 4+ years of experience with Unix shell scripting

- Experience with real time data processing and web services in Informatica PowerCenter with knowledge of its XML components

- Requires 5+ years experience some of which is in business applications and/or operating systems.

- Strong analytical abilities required to interact with customers to evaluate work and provide technical assistance.

-Good interpersonal skills required to interact with customers and clients and provide technical assistance to resolve problems.

-Good organizational skills required to communicate effectively.

- Excellent documentation and communication skills

Requires a Bachelor's degree (or equivalent work experience) in one of the following disciplines: Computer Science, Information Management, or related field in order to provide consultative and technical expertise to customers. Requires 5+ years experience some of which is in business applications and/or operating systems. Strong analytical abilities required to interact with customers to evaluate work and provide technical assistance. Good interpersonal skills required to interact with customers and clients and provide technical assistance to resolve problems. Good organizational skills required to communicate effectively.

ETL Technical Lead Experience 
- 2 to 5 years experience leading a group of ETL Informatica developers.

-Experience with ETL resource management of a small to medium size team (5 to 10).

-Experience interfacing with Project Managers, Data Warehouse Architects and BI developers during the life cycle of a DW project to ensure that the ETL resources are productive and can meet their deadlines.

- Experience with creating / maintaining ETL development standards and code deployment processes.

- Good understanding of the overall Data Warehouse development methodology including dimensional concepts.

- Ability to produce accurate, timely and comprehensive status reports on a weekly basis.

- Experience with interviewing and performing technical screenings for potential ETL contract / permanent resources.

- Ability to manage multiple, concurrent ETL development projects.

- Ability to track ETL resources time / budget against projects to ensure on time, on budget project deliverables

ETL Developer - Level III

Reports to: Data Warehouse Manager

 Responsibilities:

 Perform data analysis on multiple source systems, as per project needs

• Design and develop mappings in Informatica PowerCenter to accommodate business requirements for data extraction, transformation and loading
• Design ETL workflow with job dependencies and scheduling
• Tune and optimize ETL jobs for performance and throughput
• Develop stored procedures using Oracle PL/SQL to extend PowerCenter functionality
• Design and develop exception and error handling
• Design and develop data verification and validation processes
• Design and develop test plans for unit testing, integration testing UAT
• Manage installation, configuration and upgrades of Informatica PowerCenter software
• Manage maintaining Informatica Power Center repository with ETL and metadata information
• Manage security in terms of developer and user access
• Manage production deployments and automation
• Manage monitoring jobs, job control and production support

Requirements

• 7+ years of experience in ETL development using Informatica PowerCenter with minimum 2 years experience using PowerCenter 8.X
• 7+ years of experience in Data Warehousing, with thorough knowedge of star/snowflake schemas
• 5+ yers of experience in Oracle database development, using SQL and PL/SQL, with in-depth knowledge of analytical functions.
• Experience with Informatica Power Center administration required
• 4+ years of experience with Unix shell scripting
• Experience with real time data processing and web services in Informatica PowerCenter with Knowledge of its XML components
• Experience with Embarcadero DS-Auditor a plus
• Excellent documentation and communication skills

Benefits 
You'll enjoy a competitive benefits package that includes: 
- Immediate eligibility for health and welfare benefits 
- 401(k) savings plan with dollar-for-dollar match up to 5% 
- Flexible schedules 
- Employee Assistance Program 

Recruiter: Roxy H.