SUMMARY

• Senior Informatica Analyst/Developer with 10+ years of IT experience in Data warehousing and Business Intelligence.
• Hands - on team leader, mentor and implemented projects successfully with Onsite/ Offshore resources.
• Extensive experience in ETL Design, Data Integrations, Change Data Capture and Data Migrations.
• Highly Proficient in using Informatica Power Center, Power Exchange, Power Connect and Informatica Metadata Manager.
• Expertise in implementing Data Warehousing methodologies and highly proficient in handling huge volumes of data.
• Implemented Data Warehousing in multiple business areas such as e-commerce, Supply Chain, Pharmaceutical, Health Care, Retail and Medical domains.
• Highly experienced in creating documentation to build and support the process and project activities.
• Hands on experience handling different formats of data such as Oracle, SQL Server, XML, SALES FORCE, Web services and data files.
• Extensive experience in Oracle 11g/10g in both SQL and PL/SQL.
• Expertise in implementing Error Handling Methodologies.
• Highly proficient in identifying performance bottlenecks and fine-tuned the processes in Informatica and at database level.
• Experienced in using UNIX commands and developing UNIX Shell scripts for file processing, data validations, data encryption and decryption, FTP process handling, Job executions, Data Archival and Purge processes.
• Hands on experience in Business Objects Xi and OBIEE reporting tools.
• Good hands on knowledge in Informatica Data Quality and Master Data Management.
• Excellent interpersonal and communication skills, and is experienced in working with managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/7.1 , Power Exchange for Sales force, Power Exchange for Web Services Consumer, Power Connect for SAP R/3, Informatica Metadata Manager, Informatica Data Quality 9.5. Informatica MDM.

Databases: Oracle 11g/10g/9i, MS SQL Server 2012/20xx, MS Access 7.0

Data Modeling: Erwin 4.0, ER/Studio

Reporting Tools: Business Objects XI, OBIEE 11.1.1.6

Programming Languages: PL/SQL, UNIX Shell Scripting, XML.

Software Tools: TOAD, MS Visio, SQL Developer, MS Visual Source Safe, PVCS, Perforce, Autosys, Appworx, FTP, Telnet, Edit Plus, Peregrine, Ultra Edit, Erwin 4.0, Remedy, Share point.

Environment: HP UNIX 10.7/11.0, Sun Solaris 7.0,Windows XP, 2000,NT.

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Sr. Informatica Analyst/ Developer

Responsibilities:

• Required to attend functional meetings to gather requirements and provide technical opinions about feasibility.
• Involved in project cycle plan for analyzing the source data, deciding the exact data extraction, transformation, loading strategy (Informatica 9.1.0) & Dimensional modeling.
• Participated in design reviews and provided input with design recommendations.
• Conducted and Led design sessions for implementation of various ETL requirements such as SCD types, Data Cleansing and Staging methodologies.
• Participated in understanding of data warehousing environment implementing dimensional surrogate key handling, exception data processing.
• Extensively used Informatica client tools - Source Analyzer, Mapping designer, Transformation developer,Informatica Repository Manager, Workflow manager to develop mappings, sessions and workflows.
• Responsible to tune ETL mappings, Workflows and underlying data model to optimize load and query Performance.
• Used debugger for identifying and fixing bugs in existing mappings by analyzing data flow, evaluating transformations and Creating mapplets, generic transformations and worklets that provides reusability in mappings and workflows.
• Prepared deployment groups for Promotion/migration of code to QA environments.
• Created and managed triggers, and stored procedures, views, SQL transactions.
• Implemented indexing and Data partitioning strategies that maximize query performance based on how users access the data.
• Maintained and improved integrity by identifying and creating relationships between tables.
• Created UNIX scripts to perform load runs, file handling, SCP process handling, defined dependencies and set up batches to create run schedules and schedules the loads at required frequency.
• Identified data quality issues and their root causes. Implemented fixes and design data audits to capture the issues in the future.
• Provided KT to QA team during QA hand off, handled QA defects effectively.
• Created Run time documents and provided KT to support group and provided support for a min period of time.

Environment: Informatica Power center 9.1, Oracle 11g, SQL Server 2012, Red Hat Linux 5.4, files, SQL Developer, Informatica Version Control, Visio, Putty and HP QC.

Confidential, Palo Alto, CA

Sr. Informatica Analyst/ Developer

Responsibilities:

• Worked closely with the Business users and data architect, revisited the business requirements, proposed design changes to the existing data warehouse design and implemented solutions using Informatica best practices.
• Designed new processes and enhanced existing processes based on requirement changes and load performance.
• Created new mappings for the incremental data processing and modified the existing mappings for historical data processing.
• Exacted the data from Oracle Financials, People Soft and Oracle and CSV file systems and processed them into STAGING area.
• Extensively used all transformations such as Source Qualifier, Expression, Filter, Router, Lookup, Update Strategy, Aggregator, Joiner, Normalizer, SQL and so ….
• Extensively used Informatica Metadata Manager to maintain and document metadata, data lineage and visibility into data objects.
• Developed SQL queries, performed Gather Stats, Created indexes, Synonyms, Views, table partitions and fine-tuned the sql queries to improve data extraction.
• Implemented SCD type2 Dated attributes for maintaining historical data.
• Created Interim tables to implement all business rules and performed minus operation on the target tables to identify the incremental data.
• Implemented Error handling and routed the error records to Validation Exception tables.
• Created Informatica partitioning, dropped and recreated indexes during pre and post processing of the target loads, increased commit intervals and performed bulk loading to improve the data loads.
• Maintained Informatica Versioning for all the objects.
• Created and scheduled Informatica jobs using Autosys scheduler.
• Extensively used Mapping, Session and Workflow parameters and variables.
• Created Email tasks, Command tasks, Decision tasks, Event Wait and Event Raise tasks to support data processing.
• Performed Unit testing and system testing for all subject areas and fixing the bugs raised during the testing cycle.
• Created RPD’s and reports using OBIEE for Salary Setting process.

Environment: Informatica Power center 9.1, Informatica Metadata Manager, Oracle 10g, Red Hat 4.1.2 Linux, CSV files, TOAD, Informatica Version Control, OBIEE, ER/Studio, Autosys, Visio and Fogbugz.

Confidential, Palo Alto, CA

Sr. Informatica Developer

Responsibilities:

• Designed end to end solution by participating in requirements discussion.
• Direct interaction with the business users in understanding the requirements and provided a quick and efficient solution to meet the business needs.
• Prepared Technical design documents using Informatica best standards.
• Implemented Data encryption and decryption process for the Data files and also implemented file handling techniques such as SFTP process, data archival, data cleansing.
• Extensively used all the transformations like Source Qualifier, Expression, Transaction Control, Web Services Consumer, Sorter, Aggregator, Router, Union, Joiner, Lookup, Update Strategy and so…
• Extensively used Power Exchange for Sales Force to load the data into Sales force applications.
• Experienced in using Web Services Consumer transformation and SOAP UI to pass the data to web services applications and to pull the results from the same.
• Hands on experience in using Sales Force tool to query the objects and the explorer to view the events and the objects.
• Created and modified UNIX scripts to process the informatica jobs, file handling, executing sql scripts.
• Implemented Error Handling identified performance bottlenecks and improved performance by adding indexes and partitions and query optimization techniques.
• Performed Unit testing, system testing. Responsible for bug fixes identified during testing cycle.
• Maintained Informatica versioning and prepared deployment document for code migrations.
• Provided production support on any job failures and KT sessions to Informatica Support team.

Environment: Informatica Power center 9.1, Power Exchange for Sales Force, SQL Server 2012, Sales Force Explorer, Red Hat 4.1.2 Linux, Flat files, MS Visio, SQL Developer, Informatica Version Control, TOAD and HelpZilla.

Confidential, Freemont, CA

Sr. Informatica Developer

Responsibilities:

• Used Agile approaches, including extreme programming, test driven development and weekly scrums.
• Direct interaction with the users in finalizing the requirements and provide a quick and efficient solution to meet the business needs.
• Prioritize the tasks based on weekly scrum list.
• Created a new Sandbox database environment to fulfill the user’s needs.
• Extensively worked on the design approaches, created Informatica code using Designer, Workflow Manager and supported the process.
• Extensively used all the transformations like Source Qualifier, Sequence Generator, Expression, Filter, Router, Sorter, Aggregator, Union, Joiner, Lookup, Update Strategy and so…
• Modified existing Informatica Code, PL/SQL procedures and packages for the new CO’s and SR’s.
• Created and modified UNIX scripts to process the informatica jobs, file handling, calling sql scripts and scheduling.
• Identified performance bottlenecks and improved performance in Informatica Code, Database SQL Queries by adding hints, indexes and partitions like wise...
• Performed Unit testing and system testing, identified and fixed the bugs on a priority basis.

Environment: Informatica Power center 9.1, Oracle 10g, CSV files, MS Visio, SQL Developer, Informatica Version Control and UNIX SSH Client.

Confidential, Palo Alto, CA

Sr. Informatica Developer

Responsibilities:

• Drafted ETL strategies and performed data migrations from Oracle to SFDC.
• Designed the process and implemented the end to end solution by using Informatica Best Standards.
• Analyzed the challenges across multiple systems to gather the source data to ensure data consistency.
• Extensively worked with business users to understand the requirements and prepared the technical specs for source to target mappings.
• Defined the table structures, file formats and details of the data files to be loaded to the target systems.
• Extensively used Informatica 8.6.1 version for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively worked on Power Exchange for Salesforce to extract the data from Salesforce applications.
• Extensively used all the transformations like Source Qualifier, Sequence Generator, Expression, Filter, Router, Sorter, Aggregator, Joiner, Lookup, Update Strategy and so…
• Performed Data Cleansing techniques, Fine tuned Informatica mappings, sessions, Lookup queries and caches, partitioning to improve the load performance.
• Created Unix Shell Scripts for FTP file processing, jobs execution, data validations, data archival and cleansing process
• Performed Unit Testing and resolved the bugs identified during the QA and UAT testing.
• Documented the support process, prepared release notes for code migrations.

Environment: Informatica Power center 8.6.1, Power Exchange for SalesForce, Oracle 10g, Sales Force, Flat files, MS Visio, TOAD, Perforce, TOAD, HelpZilla, PPM tool, UNIX.

Confidential, Mountain View, CA

Sr. Informatica Lead Developer

Responsibilities:

• Hands-on team leader, mentor and implemented projects successfully with the Onsite/ Offshore resources.
• Involved in designing a data model for RCHA project, worked closely with business analysts in identifying the requirements, documented end to end solution to derive the data across diverse systems.
• Played a key role as a team lead, well communicated with the Onsite / Offshore team in delivering the solutions with in the deadlines.
• Analyzed the challenges across multiple systems to ensure data consistency.
• Defined the table structures, file formats and details of the data files to be loaded to the target systems.
• Identified the gaps in the data available in Transaction systems and requirements and came up with alternate solutions.
• Extensively used Informatica 8.6.1 version for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively applied Change Data Capture to extract the data from relation and non-relational sources.
• Extensively used all the transformations like Source Qualifier, Sequence Generator, Expression, Filter, Router, Sorter, Aggregator, Joiner, Lookup, Update Strategy and so…
• Developed reusable components in Informatica such as re-usable transformations, mapplets and reusable tasks.
• Experienced in writing new and modifying the existing PL/SQL code in oracle to support the process.
• Extensively used mapping parameters and variables to support SQL override and reusability.
• Implemented Error handling methodologies to capture the data errors into Error tables.
• Fine tuned the informatica mappings, sessions, created partitions to improve the load performance.
• Extensively used collect performance data, push down optimization options, DTM buffer size, DTM Buffer block size, Commit Interval options at the session level.
• Good experience in using the Appworx scheduling tool to automate the process and to set the dependencies.
• Prepared Unit Test cases, performed unit testing, involved in peer reviews, and fixed the issues raised during the system and integration testing.
• Created and modified the existing UNIX Shell scripting for File Handling, Ftp process and scripts required in automating the process.
• Developed the data archival and purge process.

Environment: Informatica Power center 8.6.1, Oracle 10g, SQL Server 2005, Erwin 4.0, MS Visio, Flat files, MS Access, TOAD, Perforce, PVCS, TOAD, Remedy, UNIX and Appworx.

Confidential, Philadelphia, PA

Sr. Informatica Developer

Responsibilities:

• Involved in Oncall support for daily, weekly and monthly process on a rotation basis.
• Effectively applied all the business requirements and transforming the business rules into mappings for developing the new interfaces and to make changes to the existing interfaces.
• Used Power Center Connect for SAP R/3 to extract the data from SAP.
• Developed schedules to automate the process and Informatica Sessions/Batches in UNIX environment.
• Involved in developing the Mappings, Mapplets, Reusable Transformations, Tasks, Sessions, and Workflows as a part of ETL Process.
• Extensively used transformations like Source Qualifier, Filter, Router, Expression, Aggregator, Lookup, Update strategy, Sequence generator, Stored procedures and so..
• Experienced in using different options like mapping parameters, variables, compare, debugger and so...
• Experienced in optimizing the SQL queries to improve the performance.
• Implemented Informatica performance tuning techniques at the transformation level and Session level to increase the performance of the jobs as per the demand.
• Responsible for Unit testing, system and integration testing.
• Responsible to resolve the open tickets raised by the customers which includes in database fixes, Informatica fixes and the fixes related to the PeopleSoft application.

Environment: Informatica Power center 7.1, Power Connect for SAP R/3, Oracle 10g, HP UNIX 11.0, FTP, MS VISIO, Peregrine, Ultra Edit, TOAD for Oracle and MS Visual Source Safe.

Confidential, Philadelphia, PA

Informatica Developer

Responsibilities:

• Involved in gathering the requirements from business users, and also involved in preparing design documents to support the process.
• Developed the Technical specifications for building the interfaces.
• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Responsible for decision making in building the applications.
• Performed Data conversion from SQL Server 2000 to Oracle database.
• Experienced in using the shell commands and writing shell scripts to automate the process and to schedule the jobs on a timely basis.
• Developed complex Mappings, Mapplets and Reusable Transformations for ETL Processing.
• Extensively used Workflow manager for Workflow and Session Management, Database connection management and create tasks to support the process.
• Created stored procedures, Functions, Triggers, Materialized views in implementing the business requirements.
• Implemented Optimization Tuning Techniques in Oracle to improve the performance of the jobs.
• Looking at the performance of the jobs, tuning has been done to improve the performance of those jobs, which are running for a long time.
• Worked on different tasks in workflows like Sessions, Event raise, Event Wait, Decision Task, Command and Email tasks.
• Experienced in partitioning the data to improve the load processing in Informatica.

Environment: Informatica Power center 7.1, Oracle 9i, SQL Server 2000, UNIX, Telnet, FTP, MS VISIO and TOAD.

Confidential

Responsibilities:

• Evaluated Business Requirements and prepared technical specification to develop Informatica mappings.
• Involved in production support which are scheduled to run on a daily and weekly basis and to resolve on the issues based on the priorities assigned.
• Responsible for completing the loads on a timely basis.
• Developed new mappings and enhanced the existing mappings using performance tuning techniques.
• Identifying and tracking the slowly changing dimensions, heterogeneous Sources and determining the hierarchies in dimensions.
• Extensively worked on PL/SQL to create stored procedures, functions, Triggers and exception handlers.
• Optimized Query Performance, Session Performance and Reliability.
• Wrote Pre-session and Post-session shell scripts and Email tasks.
• Automated the process using AUTOSYS tool, which involved in writing the UNIX shell scripting and using UNIX commands.

Environment: Informatica Power center 6.0, Oracle 9i, Flatfiles, SQL Navigator, Autosys, Remedy, Edit plus, UNIX and Windows 2000.