SUMMARY:

• IT Professional with 8+ years of experience in Business Intelligence solutions using Data Warehousing/Data mart design, ETL and reporting tools.
• Highly skilled in Data Warehousing and ETL using Informatica PowerCenter 10.2/9.6.1/9.5/9.1.0
• Expert in requirement gathering, planning, analysis, design, implementation, unit testing, code migration, quality assurance testing, user acceptance testing, production support with expertise in developing business applications much based on RDBMS.
• Good experience working with scheduling tools like AutoSys, Control M and Informatica scheduler.
• Experience in analyzing the data to learn data characteristics.
• Experience in migrating the code between environments, with proper documentation (production turn - over document).
• Extensive experience in using Informatica to deal with heterogeneous source and target systems, which include leading RDBMS (Oracle, DB2 and SQL Server), Flat files, XML files.
• Experience in ETL Error Handling, Performance Tuning and Code Optimization.
• Experience in using shell scripting for automation (which involved integration of heterogeneous systems, Informatica, Oracle, SQL Server etc...), restart-ability for system in DW engagements and file movement and archival after data Load.
• Skilled in analyzing data for error records using Informatica mapping debugger.
• Good experience with troubleshooting, identifying and fixing Informatica job failures in Production.
• Experience in leading teams with good understanding of onsite-offshore environments and team management.

TECHNICAL COMPETENCIES:

ETL Tools: Informatica PowerCenter 10.2/9.6.1/9.5/9.1.0

Reporting Tools: Business Objects, OBIEE 11g/10g

Data Modeling: Erwin 7.2/4.5/4.0

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008 R2/2005, DB2, Sybase, MS Access 7.0/2000, IMS Data, T-SQLLanguages SQL, PL/SQL, T-SQL, Perl scripting, shell scripting C, C++, HTML

Tools: SQL plus, TOAD, AutoSys, CRONTAB, Control-M, Tivoli, HP service Manager, Putty, Microsoft Office, WinSCP

Quality Assurance: Mercury Test Director 7.2, HP Quality Center 10/9/8

Operating Systems: UNIX (Sun Solaris, HP-UX, AIX), Windows 2003/2000/XP/98

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr. Informatica, ETL Developer

Responsibilities:

• Responsible for gathering requirements by working with BSA’s and business users to integrate and load HR data for Confidential .
• Created mappings using Designer and extracted online user registration data from various sources like Flat file, relational sources, XML, Normalized data and transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of star schema and snowflake schema.
• Used Transaction control transformation to generate Flat files dynamically for downstream users.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.
• Worked on the Support to solve the existing Informatica mappings issues.
• Involved in data analyzing with data analyst to define the structure of dimension and facts.
• Moved Mappings, Sessions, Workflows from Development to Test, UAT and Prod environment.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used parameters/variables for PowerCenter mappings, sessions and workflows.
• Created process documents in case of job failures, and also documented failures to fix repeat issues.
• Worked with various teams like BSA, DBA, Business users and environment technical leads in case of job failures.
• Worked on enhancements like adding new columns, updating column datatypes and lengths both at Database and PowerCenter level.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Worked in L2, L3 support model.
• Worked with various teams on a bridge call to fix production issues.
• Used remedy (Incidents) as a ticketing system to initiate, track and resolve production issues.
• Used remedy to create PBI, KBA and CR (change requests).
• Responsible for performing validation checks on Database, PowerCenter and UNIX servers after upgrades and security patching.

Confidential, San Antonio, TX

Informatica / Production Support Analyst

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Involved in monitoring external data feed, Intraday and nightly batch load along with user issues.
• Responsible for monitoring, fixing, resolving various job failures and data issues by working with multiple teams.
• Did 24x7 production support, ETL executions, and resolved root causes
• Was working on Splunk alerts, site scope alerts, AppDynamics alerts and stability issues reporting to L3 teams.
• Used Secure CRT and FX tools, connect to UNIX servers to check the files, server health statistics and jobs monitor
• Provided on call support on 24/7 basis and available to the users in providing required information.
• Supported AutoSys batch processes involving Power center and perform troubleshooting by looking at UNIX scripts, stored procedures or database SQL processes, running database queries and reviewing data to determine point of failure.
• Fixed trade data related issues by writing SQL and using tools like Toad, Rapid SQL, and Microsoft SQL Server Studio.
• Involved in creating and documenting knowledge articles, to help with future failures. This reduced the time to fix future failures and paging out development teams.
• Worked with ticketing tool remedy by creating Incidents, Problem investigation (PBI), Change request (CRQ), KBA (Knowledge article).
• Worked with various teams to reduce repeat issues critical to the batch. This helped in meeting the SLA and getting the applications ready for business.
• Worked on user and application issues, by reaching out to users and working with them.
• Involved in emergency and weekend critical patching for UNIX, Windows and Database patching. Performed application check outs after patching to ensure the applications were ready for business.
• Worked with various teams to perform DRE (Disaster recovery exercise), twice a year. This was done to ensure all applications and servers run without any issue in case of hardware failure in production environment.
• Responsible for sending out business communication and alerts in case of job failures affecting nightly batch.
• Automated various reports for business, saving time and effort and reducing manual work.
• Used to send nightly batch status email to senior managers and directors with the batch status.
• Work with external vendors in case of missing files or bad data.

Confidential, Los Angeles, CA

ETL/Informatica Developer

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Prepared the Mapping Specification documents like Entity Level Mapping, Attribute Level Mapping.
• Assisted with establishing and administering the Informatica and UNIX environment.
• Used Informatica PowerCenter 8.6.1/9.1 to extract, transform and load data from multiple input sources like Oracle, flat files to target Oracle database.
• Integrate and managed workload of Power Exchange CDC
• Integrated Oracle EBS with Informatica PowerCenter and OBIEE
• Provided 24/7 Support for Informatica and OBIEE Reports
• Supported BI tools like OBIEE and QlikView
• Used Informatica PowerExchange (5.x/8.x) for loading/retrieving data from + system
• Created and configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager
• Used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from flat files
• Developed single and multiple dashboards and scorecards using business objects
• Documented the user requirements, translated requirements into technical specification for the development of end user reports (Business Objects reports) and developed implementation plan and schedule
• Developed and documented data Mappings using various Transformations like Lookups, Source Qualifier, Joiner Transformation, Expression, Filter, Router, Aggregator, Update Strategy, Rank, Sequence Generator and more as per the requirements.
• Designed and documented all the ETL Plans.
• Involved in Data Analysis, Data Validation and Data Cleansing.
• Created reusable transformations and Mapplets to use them in different mappings.
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Created sessions and batches and scheduled them on Success tasks like Email to the ETL team and Business Analysts.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Responsible for querying Informatica Metadata and managing the Metadata.
• Implemented efficient and effective performance tuning procedures.
• Worked extensively on SQL, PL/SQL, Perl and UNIX shell scripting.
• Used VB, net to create user define functions in SSRS
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Involved in Code migration to different Repositories (Dev/Test /Prod).
• Scheduled Jobs through JIL scripts using AutoSys scheduler.
• Extensively used Informatica Debugger to analyze/resolve the data issues.
• Involved o Production Support & Maintenance.
• Integrated data to the Moody’s Risk Frontier application and debugging the integration issues.

Environment: Informatica PowerCenter 9.1/8.6.1, AutoSys, SQL server 2008 R2, Oracle 10g, Flat files, TOAD 10.1, UNIX Shell scripting, Oracle EBS r12, Erwin 7.2

Confidential, Palo Alto, CA

ETL Consultant

Responsibilities:

• Implemented Type 2 Slowly changing dimensions to keep track of current and complete historical data.
• Used Informatica PowerCenter 8.6 to extract, transform and load data from multiple input sources like Oracle, flat files to target Oracle database.
• Worked on OBIEE configuration, documentation for OBIA and OBIEE components
• Involved in maintaining OBIEE, QlikView reports like providing access to Users and making sure the reports published the right data on time.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration, and user maintenance.
• Developed the Business Objects Universe for generating the reports and have done the administrator part to provide the access to end users and developers of the reports
• Managed workload of Power Exchange CDC
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created BTEQ (Basic Teradata Query) scripts to generate Keys.
• Developed and documented data Mappings using various Transformations like Lookups, Source Qualifier, Joiner Transformation, Expression, Filter, Router, Aggregator, Update Strategy, Rank, Sequence Generator and more as per the requirements.
• Created sessions and batches and scheduled them on Success tasks like Email to the ETL team and Business Analysts.
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked with NC Load to lead flat file data into Netezza tables
• Responsible for querying Informatica Metadata and managing the Metadata.
• Worked extensively on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions.
• Implemented efficient and effective performance tuning procedures.
• Involved in Data Analysis, Data Validation and Data Cleansing.
• Administered Workflow manager to run Tasks and Worklets.
• Interacted with DBA’s, Informatica Support team to resolve the issues.
• Worked on Production Support & Maintenance.

Environment: Informatica PowerCenter 8.6.1, Erwin4.5, Flat Files, Cobol files, CSV files, MS Excel, DB2, Oracle 10g, TOAD 7.4, UNIX Shell Scripting

Confidential, Chicago, IL

Informatica Consultant

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Prepared the Mapping Specification documents like Entity Level Mapping, Attribute Level Mapping.
• Responsible for tuning the ETL mappings in order to gain high performance.
• Responsible for unit testing the developed mappings and involved in UAT sessions.
• Involved in migrating the plans from Development to Production and automating the process.
• Developed many complex Informatica mappings and Mapplets to build key interfaces using various transformations (Joiner, Update Strategy, Lookup, Expressions, and Aggregator) for loading the data into Data Warehouse.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling jobs to run at specified time.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used SQL tools like TOAD and PL/SQL Developer to run SQL queries and validate data.
• Involved in writing UTP as per business Requirement.
• Extensively used Informatica client tools - Designer, Informatica Repository Manager, Informatica Workflow Manager and Work flow Monitor.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Optimal utilization of object-reusability features like reusable transformations, Mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Performance Tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.
• Involved in Code migration to different Repositories (Dev/Test /Prod).

Environment: Informatica PowerCenter 8.1/7.1, WIN SQL, UNIX Shell Scripting, Oracle 9i, DB2, Flat Files, CSV files, PL/SQL, SQL, Windows XP/2000