SUMMARY

• Total around 9 experience in the Information Technology (IT) industry with specialization and expertise in Data Warehousing which includes 3 years of development and 2 years application production support and around 4 year as Informatica ETL admin for AIX environment
• Extensive experience in development and production support of ETL using Informatica 9.1.0/8.6.1/8.1.1/7. X
• Experience in the Insurance and telecom industry.
• Extensive experience in Informatica Power Center systems administrator
• Manage and maintain existing Informatica interfaces: Power Exchange, Power center and etc. Install, configure, migrate and support new interface setup
• Responsible to manage Development, QA and Production environments
• Good understanding of RDBMS concepts and experience in writing queries using Oracle
• Excellent Client handling ability with good presentation skills.
• Proficient in SQL,ETL and Data warehouse concepts
• Extensive experience in data warehousing testing like UAT.
• Managed the evaluation of ETL recommended the most suitable solutions depending on business needs.
• Provided leadership roles including client mentoring

TECHNICAL SKILLS

ETL Tools: Informatica power center 7.1, 8.1, 8.6.1, 9.1.0

O.S: Windows, UNIX AIX

RDBMS: Oracle 11g

PROFESSIONAL EXPERIENCE

Informatica administrator

Confidential

Environment: INFORMATICA 9.1.0/8.6.0 , Oracle 11g,DB2, ORACLE 10g/11i and HP service Manager

Responsibilities:

• Responsible for installing, configuring, upgrading and maintaining a scalable and high performing Informatica solution (Informatica 9.x) in support of business processing requirements.
• Performs software installations and upgrades to Informatica software packages
• Perform Infomatica code migrations
• Trouble shoot informatica user access issues
• Tasks performed thru admin console, few examples:
• Set up new users and setting the roles for the users in Informatica Administration console
• Create new integration services, make changes to libpath and path
• Clearing locked jobs by clearing user sessions
• Review Domain logs periodically, to check on login violations
• Check for valid licensing options
• Responsible to manage Development, QA and Production environments.
• Setting a new relational connections, folders, assign permissions using Informatica Client tools
• Work with application areas to diagnose issues
• Maintain repositories by doing routine purge of deleted objects
• Open SR ticket with Informatica support as needed and follow up on the SR, Collect stats, logs etc. during crash
• Ensure deep pro - active monitoring of platform and systems to ensure there is minimal unplanned down time.
• Support informatica objects Production deployment and validation.

Informatica administrator

Confidential

Environment: INFORMATICA 9.1.0, Oracle 11g,Sql developer, ORACLE 10g/11i

Responsibilities:

• Responsible for installing, configuring, upgrading and maintaining a scalable and high performing Informatica solution (Power Center 8.6.1,9.x) in support of business processing requirements.
• Performs software installations and upgrades to Informatica software packages
• Handled the tasks of preparing project status report of the project and update the same to the manager/Delivery Manger for project work status
• Provide coaching and assistance to other team members on daily support activities as needed
• Identify opportunities for improvement, makes proposals and participates in the planning of new and enhanced technologies or services within area of expertise.
• Provide tier-3 production support for data warehouse/ETL wkf issues.
• Setup connectivity between the two systems
• Knowledge and understanding of Unix environment.
• Ensure deep pro-active monitoring of platform and systems to ensure there is minimal unplanned down time.
• Support informatica objects Production deployment and validation.
• Work with users and development team on escalated issues.
• Support the informatica admin activities for connectivity setup and restart/stop the integration services.
• Deploy the informaticacode across the environments.

ETL developer

Confidential

Environment: INFORMATICA 8.6.1, ORACLE 10g/11i, UNIX

Responsibilities:

• Created different transformations such as Expression, Aggregator, Lookups, Filters, Update Strategy and Sequence Generator.
• Involved in the Development of Informatica mappings and also tuned them for Optimum performance.
• Worked with multiple sources such as flat files, Oracle for extraction using Informatica
• Designing and Creating of Session and workflows.
• Reviewing the specifications and mappings.
• Provide the tier3 support for production issues.
• Making Unit Test Cases based on business logic and Testing of mappings and workflowsResponsible for send out the details report for project status about the issues and outages to leadership/clients
• Analyzing client’s requirements provided by the other teams.
• Take ownership for issues to reach resolutions to prevent recurrences
• Provide assistance with ETL design, development, and performance tuning
• Design and architect ETL solutions as part of a cross-functional team
• Coordinate and lead onsite and offshore delivery for team of 3-5 Tier3-Production Support, Handling user queries and release support.

Confidential

Informatica developer

Environment: INFORMATICA 8.6.1, ORACLE 9i, UNIX

Responsibilities:

• Initially responsible for requirement gathering for developing robust Interfaces via Informatica. Interacted with the Business and IT teams to existing systems and come up with a robust mechanism to Interface Sub Ledgers with the Oracle GL. Designed the ETL Architecture to load data to the GL confirming to the needs of the various Businesses.
• Worked on Informatica Power Center 8.6.1 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target.
• Created different transformations such as Expression, Aggregator, Lookups, Filters, Update Strategy and Sequence Generator.
• Involved in the Development of Informatica mappings and also tuned them for Optimum performance.
• Worked with multiple sources such as flat files, Oracle for extraction using Informatica
• Designing and Creating of Session and workflows.
• Reviewing the specifications and mappings.
• Making Unit Test Cases based on business logic and Testing of mappings and workflows.

Confidential

Developer

Environment: INFORMATICA 7.1.3 POWERCENTER, ORACLE 9i, UNIX (SUN SOLARIS)

Responsibilities:

• Created different transformations such Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Worked on Informatica Power Center 7.1.3 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target and Transformation Developer.
• Created Mappings and Workflows from Stage to ODS
• Created Parameter files.