SUMMARY:

• Around 8 years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• 7+ years of experience in Informatica Developer/Administration
• 2+ years of experience in IDQ and Metadata Manager.
• Expert in all phases of Software development life cycle - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Expertise in data warehousing, ETL architecture, Data Profiling.
• Experience in working with various versions of Informatica Powercenter 10.x,9.x,8.x-Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts and Perl scripts.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.

TECHNICAL SKILLS:

ETL tools: Power Center 10.x/ 9.x, 8.x, SSIS, TDM, Tableau (Desktop/Server)

BI and Scheduler tools: IBM Cognos 10.x/8.x, SQL Developer, Control-M, SSRS.

Databases: Oracle 12.x/11g/10g/9i, MS SQL Server, Netezza, SQL Assistant.

Programming: SQL, SQL*Plus, Python,C, UNIX shell scripting.

Web Development: HTML, XML.

Operating Systems: Red Hat LINUX, IBM AIX, Windows XP/Vista/7, UNIX.

WORK EXPERIENCE:

Confidential

Lead Informatica Developer/Administrator

Responsibilities:

• Experienced with Informatica administration on Unix and Linux platform
• Informatica upgrade and performing end - to-end tasks
• Handled repository backups, restoration, failover Created the Analyst Service,DataIntegrationService,ModelRepositroy
• Installed and configured the following IDQ 9.6 components on Linux Servers
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Configured Master Node and Backup nodes under High Availability environment.
• Creating Relational Connection in Informatica Workflow Manager level
• Administration of Repository services and Integration services, Web services on Nodes with Grid concept.
• Created various Informatica connections to connect to the sources and targets.
• Creation and maintenance of Informatica users and privileges.
• Created Native Groups, Native Users, roles, and privileges and assigned them to each user group.
• Created Informatica Folders and assigning the permissions to the Folders.
• Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments.
• Handled outages when there is any maintenance in UNIX and DATA BASE.
• Collaboratively worked with Application Support Team, Network, Database Teams, and UNIX teams.
• Experience in DR planning and setup
• Provide support to team in performance tuning, troubleshooting, best practices and standards
• Informatica SCM(Folder Level migration/Object Level Migration)
• Informatica object Migration using Repository Manager
• Informatica Administration activity(by using Admin console)
• Hotfix Implementation
• Performance tuning of Informatica application
• Code review of mappings of various application across plant

Environment: : Informatica PowerCenter 10.x/9.x and 8.x, IDQ, Metadata Manager, Power Exchange, Oracle 11g and 10g, SQL, IBM AIX, UNIX Shell Scripts, Remedy, Control-M, Toad, MS Visual Source

Confidential

Informatica Developer/Administrator

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Designed various mappings using Informatica Designer to load Dimensions and Facts.
• Installed Informatica 9.x
• Upgraded Informatica 9.0.1 to 9.1.0, 9.1.0 to 9.5 and 9.5 to 9.5.1
• Handling the issues in the Informatica level
• Creation of folders/user permissions.
• Handling other Informatica administration activities.
• Created mapplets to use them in different mappings.
• Used existing ETL standards to develop these mappings.
• Created various Workflows, worklets and Sessions for the mappings to run.
• Used various transformations like Aggregator, Joiner, Expression, Filter and Router, Lookup, Update Statergy, Sequence Generator to transform the data.
• Modified existing mappings for enhancements of new business requirements.
• Worked with the DB team to put database changes in place for the mappings to run.
• Used the ETL standard’s to load the Dimension and Fact tables daily by scheduling the workflow using informatica scheduler.
• Extensively worked as production support developer to identify and fix data problems.
• Created technical support documentation for the team for production support.
• Worked on the three-tier model (DEV, TEST, and PRODUCTION).
• Followed standard procedures to migrate the mappings from Development to Test and Production environments.
• Used the email task in the Production to keep the team posted when session’s fail.
• Created store procedures to implement the logics and using them in Informatica.
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.

Environment: Informatica Power Center 9.1.0, Control-m, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2010.

Confidential

Informatica Developer/Administrator

Responsibilities:

• Worked as Informatica Administrator/Developer.
• Defined the naming standards and standard process for Informatica.
• Installed Informatica 8.6, 9.0.1,9.1.0.
• Upgraded Informatica 8.5.1 to 8.6.1,8.6.1 to 9.1 HF4
• Troubleshooting the issues in Informatica Server.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Provided, recommended solutions and change the process to minimize the cost for projects.
• Applied Informatica patches to the Informatica servers.
• Developed complex scripts to follow the business requirements.
• Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
• Migrating the ETL jobs reports from one environment to another environment.
• Used the email task in the Production to keep the team posted when session’s fail.
• Extensively used environments to create shell script and maintaining the logs of Informatica admin console.

Environment: Informatica Power Center 8.x/9.x, Control-m, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2010.

Confidential

Software Engineer - ETL

Responsibilities:

• Designed & developed ETL processes based on business rules, job control mechanism using Informatica Power Center 8.x and 9.x. Re-engineered on existing Mappings to support new/changing business requirements.
• Used Mapping, Sessions Variables/Parameters, and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Prepared SQL Queries to validate the data in both source and target databases.
• Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Automated the ETL deployment process integrated with UNIX and Power Center Repositories and reduced the cost of maintenance activities for future activities.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Tuned the performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing the run time of workflows.
• Extensively worked on Expressions, Source Qualifier, Union, Filter, Sequence Generator, sorter, Joiner, Update Strategy Transformations.
• Handling the issues in the Informatica level.
• Creation of folders/user permissions.
• Developed shell scripts to automate the update process.
• Executed Workflows and Sessions using Workflow Monitor.
• Involved and resolving the issues (Tickets) in Power center.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Environment: Informatica Power Center 8.x/9.x, Oracle, Mainframe, DB2, COBOL, UNIX, VSAM, SQL, PL/SQL.