PROFESSIONAL SUMMARY:

• Around 13+ years of experience in Information Technology and 6+ years at Onsite with a strong background in Data warehousing using Informatica Power Center/Data Integration Hub/IDQ/AXON 10.x/9.x/8.x/7.x/6.x.
• Hands on Informatica 10.x/9.x/8.x installation, configuration, debugging, tuning and administration.
• Systems implementation, operations and its optimization as Informatica admin
• Extensive experience in develop, maintain and implementation of EDW, Data Marts, ODS and Data warehouse with Star schema and snowflake schema.
• Proven experience as an Informatica Admin on monitoring resource utilization and proactively identifying Informatica job performance and resource issues network, disk usage, memory usage, server side limitation
• Experience on Node, Grid and High availability configurations
• Expertise in setup LDAP authentication security in Informatica/DIH.
• Strong experience in analyze in performance related issues at server/job level.
• Proficient in Operational and Dimensional Modeling, ETL Extract, Transform and Load processes, OLAP On - line Analytical Processing
• Highly experienced in working and managing projects in Onsite-Offshore models. Proficient in handling and meeting client expectations.
• Proven ability to manage multiple project modules simultaneously.
• Expertise in Informatica power center setup, configuration, user security and administration
• A personality with strong business acumen, excellent inter-personal relationship, possessing strong leadership and team building capabilities.
• Expertise on Service Now incident Management and Change Management process
• Hands on UNIX Shell Scripting and administrative commands including server lever activities automation
• Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Expertise in fine-tuning the mapping and sessions by identifying the bottlenecks to improve the performance.
• Expert in typical Admin jobs like Migrations, FTP requests, Performance tuning, Installation of patches, hotfixes and upgrading the tool.
• Followed and Implemented Best Practice methodologies
• Extensively used Informatica Designer for developing mappings, mapplets/Transformations, workflows and performed complex mappings based on user specifications
• Configured OS profiles in Integration services for workflows runs.
• Strong experience in Scheduling jobs using UNIX Shell Scripts and Unix Crontab
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels

TECHNICAL SKILLS:

ETL Tools: Informatica 10.2/10.1/9.6/9.1/8.6.1/7.1/6.2/6.1 (Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling.

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata

OLAP Tools: Hyperion and Business Objects

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic

Tools: Toad, SQL* Loader

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

PROFESSIONAL EXPERIENCE:

Sr. Informatica Developer/Administrator

Confidential, Franklin, TN

Responsibilities:

• Understand the business functionality and analysis of business requirements in terms of information management support services/systems.
• Interact with business community and gathered requirements based on changing needs, Informatica capacity planning and design
• Installation of Informatica power center 9.1 and setup services and client tools
• Configure and optimize all aspects of Informatica platform Server suit, including policies, control standards, procedures and dashboards.
• Involved in writing shell scripts to schedule, automate the ETL jobs.
• Administer projects, roles, user, and privileges across all three environments.
• Configure and setup LDAP security integration with Informatica
• Configured Master Node and Backup nodes under High Availability environment
• Informatica repository and domain backup/restore
• Monitor Informatica platforms Performance across all three Environments and taking necessary actions in case of File system/permission/space issues
• Expertise in fine-tuning the mapping and sessions by identifying the bottlenecks to improve the performance
• Involving in Supporting ETL Applications production jobs and changing existing code based on business needs.
• Perform monthly scheduled maintenance activities
• Extensively worked on multiple data management projects with onsite and offshore development Teams.
• Having hands on software upgrades in BIDW (ETL Informatica V 8.6/9.1) and Citrix/Windows servers which includes upgrades, patches, OS level upgrades etc
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Define standards and Processes to be followed by ETL technical Teams
• Address issues/requests from Application teams with answers for queries.
• Frequent (Informatica/Linux) health checkups across all Environments(Monitoring Informatica server for I/O Usage, Memory usage, CPU usage, storage usage)
• Informatica Migration activities from v.8.6 to 9.1
• Schedule daily backup of Informatica environment, restore Informatica environment when required
• Provided 24/7 production support to all the ETL Informatica applications and Projects
• License compliance maintenance and update as necessary
• Documentation of ETL server installations and migration including client components
• ETL Metadata analysis for user queries and business reports
• Address the new changes and ETL standards to ETL community group on regular basis
• Develop detail implementation and Roll-back plans for major releases.
• Track deployment of projects through status report and project plan updates.
• Manage schedule of production changes, forward schedule of change.
• Conduct reviews, identify gaps, and recommend and implement change to release and change management policies on a regular basis.
• UNIX shell scripting, for various functions such as maintenance, backup, and server health checks
• Documentation of all tickets with root cause analysis and review

Environment: Informatica Power Center,AXON,IDQ,DIH 10.2, Unix, Erwin, HP Service manager, Quality Center, Business Objects XI R2

Sr. Informatica Developer/Administrator

Confidential, Franklin, TN

Responsibilities:

• Involved in gathering requirements from the end users.
• Understand business needs and implement the same into a functional database design.
• Extensively used almost all of the transforms of Informatica for various types of data conversions and Sourced data from mainframe legacy systems
• Developed and test all the backend programs, Informatica mappings and update processes.
• Review code going into production for accuracy, maintain Informatica with multiple nodes
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• Schedule daily backup of Informatica environment, restore Informatica environment when required
• Extensively Worked on Informatica Server and Client components such as Informatica Admin Console, Repository Manager, Power Exchange Navigator, Designer, Workflow Manager, and Workflow Monitor for ETL Development and Administration activities.
• Responsible for configuring the workflow tasks like EMAIL task, Command task and make it reusable for other team members.
• Worked with various teams to plan, coordinate and implement system patches and minor upgrades to Informatica to maintain integrity of systems.
• Installed Informatica 8.6 and configured services
• Upgraded repository from 8.6 to 9.1
• Coordinated with Database Admin to create appropriate indexes for faster execution of jobs.
• Performed various system Installation, upgrades etc surrounding Informatica.
• Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Performed user and security administration.
• Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
• Stopping and starting the Informatica servers.
• Involved in installing Informatica client tools, changing license details.
• Analysis and design of ETL processes.
• Involved in loading huge volume of data from source to target.
• Created Test Plans for Unit Testing for designed jobs.

Environment: Informatica Power Center 9.6, IDQ, Oracle 10g, Mainframes, DB2, MS SQL Server 2005, Toad, PL/SQL, SQL, XML, AIX

Informatica Developer/Production support

Confidential

Responsibilities:

• Providing Production support for NNA RDW & NNA GDW applications (Both Informatica and Hyperion).
• Requirement Analysis and preparing Detailed design document.
• Provide interface analysis and development support.
• Development and unit testing of Informatica code to resolve production data issues and or to provide enhancements to production data.
• Issue analysis and issue resolution for ETL interfaces in production environment.
• Maintenance of existing interfaces - ticket analysis and ticket resolution.
• Co-ordination with System Admins, DBAs and other related teams to resolve issue in Informatica feeds if any.
• Interaction with Client for clarifications regarding requirements raised in enhancement tickets
• Preparing System test cases.

Environment: Informatica Power Center 9.1, DB2, Oracle 10g, SQL, PL/SQL, TOAD,, SQL SERVER 2005, Shell Scripts, AIX

Confidential

Informatica Developer/QA support

Responsibilities:

• Testing different applications involved in EDW
• Scheduling the Jobs for monitoring and checking with the logs
• Addressing issues and raising the defects in Test Director accordingly to the development team
• Writing and executing the Order Creation Test cases, Functional Test cases, Data validation test cases and verifying the quality of code and other deliverables
• Doing code reviews for the code changes
• Taking care of all In cycle and Out of cycle Change Requests
• Doing stress testing, Load testing, Performance Testing in TEST environment
• Contributed in preparing documentation on various subjects’ areas like Bookings, Revenue, Expense. Also developed Confidential CQA testing manual
• Developing and Implementation of Best Practices
• Communication to Onsite coordinators and to the Downstream.

Environment: Informatica 8.6.5, Toad 8.6, Oracle 10g, Sql Server 2005, SQL, PL/SQL

Confidential

Informatica Developer/QA support

Responsibilities:

• Testing different applications involved in EDW
• Scheduling the Jobs for monitoring and checking with the logs
• Addressing issues and raising the defects in Test Director accordingly to the development team
• Writing and executing the Order Creation Test cases, Functional Test cases, Data validation test cases and verifying the quality of code and other deliverables
• Doing code reviews for the code changes
• Taking care of all In cycle and Out of cycle Change Requests
• Doing stress testing, Load testing, Performance Testing in TEST environment
• Contributed in preparing documentation on various subjects’ areas like Bookings, Revenue, Expense. Also developed Confidential CQA testing manual
• Developing and Implementation of Best Practices
• Communication to Onsite coordinators and to the Downstream.

Environment: Informatica 8.1, $Universe, Toad 7, Teradata 7, Oracle 9i, SQL, PL/SQL, TOAD

Confidential

ETL Consultant

Responsibilities:

• Involved in developing mapping document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Worked with multiple sources such as Relational Databases, Flat files for extraction using Source Qualifier and Joiner.
• Developed various Mappings & Mapplets to load data from various sources using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to store the data in target table.
• Analysis, design, and implementation of Extraction, Transformation and Loading Methodologies.
• Posses’ in-depth knowledge in Informatica, Supporting the Onsite Production Team (MSO) to resolve issues.
• Created Informatica MOPs, CRs, Tec specs and IAF.
• Creating sessions, pre session commands, post session commands, worklets and workflows for carrying out test loads.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, Transformations and Loading using Informatica Power Mart 6.1
• Extensively used ETL to load date from Flat files which involved both fixed width as well as Delimited files and also from the relational database.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Environment: Informatica6.1 PowerMart, PeopleSoft EPM, Oracle 8i, SQL, PL/SQL, TOAD, AIX

Confidential

ETL Developer

Responsibilities:

• Involved in developing mapping document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Worked with multiple sources such as Relational Databases, Flat files for extraction using Source Qualifier and Joiner.
• Developed various Mappings & Mapplets to load data from various sources using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to store the data in target table.
• Performed various Performance Tuning techniques to improve the load; worked with Memory cache for static and dynamic cache for better throughput of sessions containing Lookup, Joiner, Aggregator and Rank transformations.
• Implemented Real time logic for carrying out incremental load.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 6.1
• Extensively used ETL to load date from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 8i
• Developed and tested all the Informatica mappings involving complex lookups and update strategies.
• Configured sessions with email when failure.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Environment: Informatica Power mart 6.1, Oracle 8i, SQL, PL/SQL, TOAD