ETL Informatica Professional

Job Description

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. 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