Informatica Powercenter, Informatica Cloud Resume

PROFESSIONAL SUMMARY:

Around 6 of experience in the field of Information Technology with extensive experience in data warehousing, analysis, design, development, testing, documentation and implementation of Business application systems using BI ETL tools.
Extensive ex perience in Informatica Power Centre and Cloud data integration with SFDC and SNOW
Designed and developed Workflows, Mappings, Sessions, Transformations using Informatica Powercenter and Mappings, Mapping configuration tasks, Task flows using Informatica Cloud services. Thorough knowledge in creating ETLs to perform the data load from different data sources such as Flat files, Oracle, SFDC and Service Now to various target systems.
Strong experience with Informatica Power Centre client tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor and Informatica Power Centre Services - Integration services and Repository services
Good Knowledge on Data warehousing and Business Intelligence Concepts. Extensively used Slowly Changing Dimension (SCD) technique.
Experience in UNIX Operating System, Shell scripting and SQL queries.
Experience in Informatica development and support projects.
Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Module Lead for review.
Provide assistance and training to developers regarding the use of ETL development standards as necessary
Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

ETL: Informatica Power Centre 9.6,10,2, Informatica Cloud

Database: Oracle 11g, DB2

Languages: SQL, Unix Shell Script

Tools: SQL Developer, Toad

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Powercenter, Informatica Cloud

Responsibilities:

Managing a team and involving in providing knowledge transfers for new resources to understand the end-to-end environment and the process to adhere.
Lead and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations.
Involved in all phase of SDLC, i.e. Design, Development, Testing and Implementation of ETL processes end to end using Informatica Powercenter and Informatica Cloud.
Responsible for projects estimates, design documents, resource utilization and allocations
Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
Worked on shell scripting to trigger Informatica Workflows and for file management and FTP process.
Work closely with DBAs, application and ETL developers, change control management for migrating developed mappings to QA and PROD.
Support system and user acceptance testing activities, including issue resolution.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship