PROFESSIONAL SUMMARY:

• Over 9 years of IT experience in Data Warehousing using ETL tool Informatica Power Center 9.6.1/9.1/8.6 in Healthcare, Banking & Financial domains.
• Extensively worked on Requirement gathering, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support and Maintenance of various Data Warehousing Applications.
• Involved in the complete life cycle of project development: Analyze, Design, Development, Deployment and support of application.
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Filter and Update Strategy.
• Good knowledge on Data modeling, data conversions, data integrations and Reporting tools like Micro Strategy and Web FOCUS.
• Strong Knowledge in ETL design document and mapping sheet creation.
• Proficient in understanding Functional Requirements and Design documents.
• Extensive expertise in designing, developing and executing test scenarios and test cases.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes.
• Experience in writing and troubleshooting Stored Procedures, Functions, Cursors and Triggers at Database level using PL/SQL.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Experience in Teradata Utility scripts like FastLoad, MultiLoad and BTEQ to load data from various source systems to Teradata.
• Experience in 24X7 production support, ETL executions, Data analysis and root cause analysis.
• Hands on experience in fixing issues related to Informatica, Unix and database.
• Involved in Informatica Performance tuning and SQL Query optimization.
• Able to understand and work flexibly in high paced environments and adapt quickly to different business organization needs.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripting

ETL Tools: Informatica Power Center 9.x/8.x

Reporting Tools: Micro Strategy, Web FOCUS

Operating Systems: Windows 7, Microsoft Windows 98/NT/XP

Databases: Oracle 10g/11g, DB2, MS SQL Server, Teradata, Netezza

Database Tools: TOAD, Aginity Workbench

Other Tools: Control - M, Autosys, Service Now (Incident/Problem/Change Management)

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sr. Informatica Lead/ Developer

Responsibilities:

• Responsible for feasibility analysis of the requirements from ETL perspective, Client Interaction, Design, Testing, support and Documentation.
• Design scheduling structure of Informatica jobs to be executed within operational calendar.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Proactively worked to analyze and resolve all Unit testing and UAT issues.
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked with database operations and Informatica admin teams to fix performance issues.
• Proactively worked on analyzing the data and data management activities.
• Worked on developing and troubleshoot Stored Procedures, Functions, Cursors and Triggers at Database level using PL/SQL.
• Extensively worked on Change management to promote codes to different environment.
• Validate data in the reports using Micro strategy and provide update on business queries.
• Created Informatica mappings as part of enhancement to fix production bugs.
• Written UNIX shell scripts to automate manual tasks.
• Worked on scheduling jobs in Control-M tool.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Involved in code walkthroughs and documentation.
• Involved in database migration from DB2 to Netezza and fixing post migration issues.
• Involved in Informatica uplift activities from version 9.1 to 9.6.1 and fixing post migration issues
• Provided on-call support to resolve critical production issues.
• Mentor offshore team on new code implementations/migrations.

Environment: Informatica Powercenter 9.1/9.6.1, Power Exchange, UNIX, Oracle, DB2, Netezza, Micro Strategy, Control-M

Confidential, Phoenix, AZ

Sr. Developer/ Onsite coordinator

Responsibilities:

• Worked on Requirement gathering, Analysis, development, testing and deployment.
• Developed Informatica mappings and mapplets to implement the business rules as per table specification documents.
• Worked on developing reusable transformations, mappings and sessions, custom session variables and workflow scheduling.
• Extensively worked on Informatica performance tuning involving source level, target level and mapping level bottlenecks.
• Worked on ETL optimization, troubleshooting and debugging Informatica mappings.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Worked on database performance tuning, troubleshooting and capacity estimation.
• Worked on developing and troubleshoot Stored Procedures, Functions, Cursors and Triggers at Database level using PL/SQL.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Developed various Mappings to load data from various sources using different Transformations.
• Tuned performance of Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Work with System Testing and UAT teams to analyze and resolve opened defects.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad, FastExport and BTEQ utilities of Teradata.
• Development standards are closely followed and adhere to the team’s SDLC process to ensure all technical solutions have the best quality in mind and prevent any impact to our production systems.
• Provide operational support on complex/escalated issues to diagnose and resolve incidents in production systems.
• Worked on scheduling jobs in Autosys scheduler tool.
• Acted as subject matter expert in my area.
• Provide support during the warranty period for applications that have been deployed to Production.

Environment: Informatica Powercenter 8.6/9.1, UNIX, Oracle, SQL Server, Teradata, Micro Strategy, Autosys

Confidential

Sr. Programmer Analyst

Responsibilities:

• Provided L2 production support for IAS suite of applications. Investigate the jobs failures by checking the Control-M Logs and Session logs in Power Center and follow escalation procedures to resolve the issue.
• Identifying and implementing operational and technical improvements.
• Build Informatica mappings and transformations to fix design gaps and production issues.
• Applied Innovative/Problem Solving techniques in supporting this project.
• Validate data in the reports using Micro Strategy & Web FOCUS and provide an update on business queries.
• Worked on Server issues related to high CPU and database reorg for better performance.
• Extensive use of incident management for Problems, Incidents & implementing changes.
• Assist Data Architects and ETL Developers to build and modify data movement and storage solutions in support of new and existing data-oriented systems.
• Involved in Production Assurance for all applications before production deployment and suggested changes need to be done before rollout.
• Worked with DBA’s and Informatica admin team on performance tuning.
• Developed UNIX shell scripts as part of the ETL process to automate the process and alert mechanism.
• Extensively worked on Incident, Problem and Change management.
• Involved in database migration from DB2 to Netezza.
• Involved in writing complex SQL queries to pull the required information from Database.
• Handling Bridge calls with different teams & Stake holders in resolving issues in a timely manner.
• Provided application and server support during outages and migration activities.
• Extensively worked on Root cause analysis, Troubleshooting on Informatica and database level.
• Worked on Incident Management, Problem Management, Change Management, Release Management, Configuration Management IT Infrastructure and Business Analysis.
• Provide operational support on complex/escalated issues to diagnose and resolve incidents in production systems.
• Worked on SQL queries to pull reports as per business users request.
• Post Validation of data during outages at database and reporting level.
• Mentor and provide necessary support to offshore team.

Environment: Informatica PowerCenter 8.1/8.6, UNIX, SQL Server, DB2, Netezza, Micro Strategy, Web FOCUS, Control-M

Confidential

ETL Developer

Responsibilities:

• Source systems data from the distributed environment was extracted, transformed and loaded into the Data warehouse using Informatica.
• Involved in the Design, development and implementation of mappings using Informatica Power Center designer and creating Design Documents.
• Extracted Data from flat files and various relational databases and loading to Warehouse.
• Worked on different Transformations like Source Qualifier, Joiner, Router, Aggregator, Lookup, Expression and Update Strategy to load data into target tables.
• Worked extensively on fixing invalid Mappings, and performing Unit and Integration Testing.
• Used transformations like Aggregator, Filter, Router, Sequence Generator, Update Strategy, Rank, Expression and lookup (connected and unconnected) while transforming Data according to the business logic.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Developed various Mappings to load data from various sources using different Transformations.
• Worked on scheduling production jobs in Autosys.
• Involved in production deployment.

Environment: Informatica Powercenter 8.1/ 8.6, UNIX, Oracle, Autosys