Hi,
Hope you are doing well..
ROLE TITLE
|
Informatica Developer (Need local profiles only)
|
ROLE LOCATION
|
Need local profiles only
Preferred Locations: Purchase, NY; Morristown, NJ
|
|
|
|
|
ROLE SUMMARY
|
The Informatica Developer will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for an enterprise data warehouse.
|
ROLE RESPONSIBILITIES
|
- Develop new ETL and enhancements and modify existing code using Informatica PowerCenter.
- Work independently to develop, configure, and unit test programs from specs (source to target mappings).
- Work closely with data architects, reporting team and application team on ETL development efforts.
- Design and document ETL solutions for projects, estimate work effort and provide status of tasks.
- Provide technical support for the administration and production support of Informatica.
- Provide first and second level troubleshooting, and baseline and operational support.
- Adhere to best practices and methodologies for ETL development team.
- Present all work in design and code review sessions to senior team members.
- Prepare documents that describe, and support code developed.
- Identify improvements to the data warehouse environment. Work with the team to implement these solutions.
- Escalate issues to the right party when required.
- Work closely with the Informatica development team for code migrations on a daily basis, perform other admin activities.
|
TECHNICAL QUALIFICATIONS
|
- 10+ years of hands-on experience in ETL development for a data warehouse.
- 10+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
- Candidate should have hands on experience working on Informatica power center application upgrade or new installation of the application servers.
- Experience working with complex SQL.
- Expertise with integration technologies and processes.
- Experience working with Query Surge.
- Experience with window environment.
- Possess knowledge of testing tools and techniques.
- Working knowledge of Kimball design methodology.
|
|
|
|