PROFESSIONAL SUMMARY:

• 9 Years of IT Experience in Designing, Development, Administration, Implementation of Data Warehouse Data marts with Informatica Power Center 9.x/8.x/7.x/6.x/ and IBM DataStage 8.x/7.x as an ETL tool.
• Hands on Informatica 7.x/8.x/9.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
• Strong experience in Informatica DR activities
• Expertise in setup LDAP authentication security in Informatica.
• 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 , dashboard designs and various other technologies.
• Highly experienced in working and managing projects in Onsite-Offsite-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 incidents, IMR Incident Management Record , CMR Change Management Records process and management.
• Expertise in IBM datastage 7.x/8.x install, setup, configuration and administration
• 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, applets/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 TIDAL, AUTOSYS and using UNIX Shell Scripts and Unix Crontab
• Proficient in PL/SQL Stored Procedures, Triggers, Packages along with tools like TOAD, Rapid SQL and PL/SQL Developer.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels

TECHNICAL SKILL SET

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Admin/Architect

Roles and 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
• Load balancing of the ETL services
• 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
• Review File/project Migration policy and procedures across the Environments.
• Assist the team in resolving individual adhoc requests
• 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
• SOX control audit documents prepare and involve compliance with outside team
• Perform Disaster Recovery of ETL systems
• 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 9.1/8.6, Oracle, SQL Developer, UNIX, Sun Solaris, Autosys, ServiceNow, Reflection-X

Confidential

Informatica Administrator

Responsibilities:

• Involved in Datacenter migration including new installation
• Understand business needs and implement the same into a functional database design.
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• Removing unwanted files with frequent file system cleanup.
• Hands on Service Now incidents, IMR'S Incident Management Record , CMR Change Management Record process and procedure.
• Involved in Informatica servers migrations, repositories setup in new environment
• Configure different data source system at server level as well as in Informatica power center
• Admin accounts change on regular basis and user audit report generation
• Coordinating with all different groups UNIX SA, DBA etc. in case of any issue with respect to Domain/Server and repository database
• Guide/support application team in terms of implementation of Informatica best practices while code development process by being proactive.
• Assist the application team, while performance tuning of existing code.
• Coordinate Informatica Product support through SR process.
• Expertise in Disaster Recovery DR of Informatica components
• Users training and documenting training manuals
• Admin account password changes on regular basis and user audit reports generation
• 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.
• Assist in the preliminary planning discussions to determine the objectives, scope, constraints, risks, and deliverables of the project.
• Unix scripting on cleanup log files subject area level ,space alerts and inactive user sessions terminate
• Deployed ETL code to higher environments

Environment: PowerCenter 9.5, Flat files, Oracle, SQL Server, UNIX, Windows, VM Linux, Windows, Remedy, Service center, Tidal

Confidential

Informatica Administrator/Developer

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 stages and 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
• Understanding of Meta Data and Data Quality needs on ETL and Data Warehouse processes
• 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 Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Responsible for configuring the workflow tasks like EMAIL task, Command task and make it reusable for other team members.
• Responsible for writing stored procedures to increase the performance of Load Strategy.
• Worked with various teams to plan, coordinate and implement system patches and minor upgrades to Informatica to maintain integrity of systems.
• Installed Informatica 8.1 and configured services
• Upgraded repository from 8.1 to 9.1
• Responsible to performance-tune ETL procedures and STAR schemas to optimize load and query Performance.
• 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.
• Documented the entire process for future maintenance and support.
• Performed user and security administration.
• Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
• Production on call support.
• 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.
• Written UNIX scripts to run the datastage jobs from UNIX.
• Monitoring the logs in the Director and troubleshooting.
• Used bulk load to insert huge volume of data into target
• Created Test Plans for Unit Testing for designed jobs.

Environment: PowerCenter 8.1/9.1, Flat files, Oracle, SQL Server, UNIX, Windows, Control-M, USD

Confidential

ETL Admin/Consultant

Roles and Responsibilities:

• Participated in the entire requirements engineering process right from requirements elicitation phase where we gather the requirements from the retail business owners and marketing people to the phase involving documenting of the requirements.
• Involved in designing, developing, and maintaining the data in the ODS data warehouse and then building the EDW using the data from ODS.
• Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population, maintenance, reorganization, security, and recovery of databases.
• Project creation and uses setup at server level in 8.1
• Informatica 8.1 installation and configuration on a distributed environment.
• Responsibilities include installation and configuration of Informatica 8.1 on DEV, UAT and PROD environments.
• Migrated developed DataStage Jobs from DEV to UAT and UAT to PROD.
• DataStage PROD support and trouble shooting.
• Involved in planning and implementation of DataStage 8.1
• Installed Informatica Clients on end user desktops/laptops and troubleshooting daily issues.
• DataStage and Informatica DR back up activities.
• Prepared documentation for DataStage 8.1 installation and configuration.
• Informatica repository upgrade from 7.1 to 8.1
• Co-ordinate with all the dependent teams like Infrastructure, WINTEL, STORAGE, UNIX, Identity Management team upon any planned maintenance and upon the impact on the same on Informatica.
• Continually worked towards improving and stabilizing production environment through shell scripts using Informatica command line utility and deploying them as part of release management
• Involved in support of ETL application batch processes on a rotational, on-call basis
• Developed jobs according to specifications, revising as necessary to meet the desired quality.
• Prepared Unit test cases for the jobs and Performed Unit testing
• Involved in unit, performance, Regression and integration testing of DataStage jobs and prepared documentation
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Resolved issues occurred during regular testing.
• Informatica applications support and server maintenance
• Installed Informatica power center 8.1 and setup, configure and administration
• Informatica projects creation, users setup and access control
• Trouble shooting Database connectivity problems and Created documentation for various Administration activities.
• Assist in the preliminary planning discussions to determine the objectives, scope, constraints, risks, and deliverables of the project.
• ETL code review and enhancements before Prod deployment

Environment: Informatica 7.1/8.1, Datastage 8.1,Oracle, SQL, PL/SQL, and SQL Loader, Flat files, Linux, Unix, windows, Autosys, Peregrine, Toad

Confidential

Informatica Developer/Production support

Responsibilities:

• Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Worked with Informatica mapping Designer to develop jobs for Extracting, Transforming and Loading the data into Target database. The data mart was built using Star Schema data model to look at the invoice amounts from various dimensions.
• Created mapping specifications and documents based on the mapping logic and business rules
• Created several mappings to load dimension and fact tables
• Worked with various transformations such as Source Qualifier, Aggregator, Update strategy, Filter, Router, Expression, Look-up, Sequence Generator and Joiner
• Implemented slowly changing dimensions techniques while developing the mappings
• Created Informatica mappings along with PL/SQL Procedures/Functions to build business rules to load data.
• Data analysis through Informatica metadata repository database
• Resolve Informatica technical issues including opening cases with the vendor and tracking them.
• Excellent Analytical, Critical thinking, and Creative Problem solving skills with ability to quickly master new applications
• Performed error handling of sessions by using terse, normal, verbose initialization and verbose data tracing levels. Performed error handing using session logs.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Providing internal training and knowledge-transfer and producing deliverable documentation.
• Responsible for Managing restricted access control to Informatica
• Folder creations, permissions and user access control
• Configuring the Databases connections in Informatica. Verify the connection to the Databases.
• Production Support that involves performance tuning/enhancement, rectification of errors.
• Trouble shooting the aborted jobs. Jobs migration from one server to the other.
• Compiling the jobs. Adding and deleting the Informatica projects/jobs.
• Project migrations to/from various environments. Code deployment to higher environments
• Shutdown and Bringing up the Informatica servers
• Repository backup and restore. Monitoring the Informatica jobs and Troubleshooting.
• Running the scripts for loading the data to database.
• Exporting and importing the jobs.
• FTPing the files from one server to the other.

Environment: Informatica 7.1, Oracle, Linux, Solaris, Sql server 2000, WinSCP, Windows, Control-M