ETL Informatica Developer

Roles & Responsibilities:
This position requires somebody with a strong Informatica experience to be part of a Application support and maintenance project.
Requirement gathering from clients and working with Architects to propose design for ETL Solutions
Designed ETL via source-to-target mapping and designed documents that consider best practices and performance
Developed Source to target in Informatica  power center mapping
Expert skills in creating Informatica mapping sessions, workflow, mapplet and work lets.
Worked on error handling
Tested ETL and other technical components and support UAT/Test activities
Deployed and tested code from lower environments to production
Designed ETL via source-to-target mapping and design documents that consider best practices and performance
Expertise in ETL design, ETL and database code developments, scheduling, Data delivery and Reconciliation.
Experience in ETL code development, Database code developments, SQL writing.
Effective communicator, confident liaising with business / senior stakeholders.
Provide support L1/L2 support for Informatica Job failures.

Requirements
Experience and Qualifications:
6 + years of experience in ETL Informatica Power Center Development and production support.
Core skills in Oracle Database
Experience in design and development of Informatica mapping & workflows.
Experience working with enterprise job scheduler and monitoring tools.
Experience in working with SQL / PLSQL scripting.
Extensive experience to optimize the performance of mapping, workflows to match the assigned execution windows.
Team player and mentor junior support resource.
Experience in control-M scheduler tool preferred