SUMMARY

• 9+ years of IT experience with in depth knowledge in design, development, enhancement of Data Warehouse and Business Intelligence applications for Financial, banking, insurance, Retail and manufacturing industries.
• Strong development skills and ability to work through entire software development life cycle (SDLC) methodologies.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from different sources like Oracle, DB2, SQL Server, Flat files, XML data with various data formats.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Expertise in using Informatica Power center / Power Mart for data extraction, transformation and loading (ETL) from desperate data sources like oracle, SQL server, flat files, MS Access, JMS and XML files and load the data into different targets.
• Expertise in extracting the data from xml files and loaded into ODS, EDW using XML Source Qualifier, XML Parser Transformations.
• Extensively worked on ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator and created complex mappings.
• Extensively worked on slowly changing dimensions like SCD type-1, type-2 and type-3 to maintain the transactional data and historical data for the need of business process and change data capture (CDC) using Informatica applications.
• Solid Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs.
• Experienced in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schemas in implementing Decision Support Systems, followed Ralph Kimball and Bill Inmon methodologies extensively.
• Strong database experience with SQL, PL/SQL Programming skills like creating indexes, joins, functions, stored procedures, triggers and cursors using Toad and SQL*Plus.
• Hands on experience onTeradataV2R6, 12.0, 13.0,TeradataSQL Assistant
• Experience in using scheduling toolsTWS(Tivoli Job Scheduler),AutoSysand Control M to automate running of Informatica Workflows on a daily Batch Jobs.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1.1/8.0/ , Power Mart 6.2/6.1/5.1. x/4.7, Power Exchange, Power Connector,ErWIN

Reporting Tools: Cognos 10.x, 8.x, Report Net, Power Play, Cognos Query, Power Play Web reports, Crystal Reports, Meta Manager,Business Objects (BOBJ)

Databases: Oracle 11g/10g /9i/8i, SQL Server 2000/2005, MS SQL, MS-Access, IBM DB2 v9.5/9.1, UDB, Tera Data(14.1)

Other Tools: TOAD, SQL*Loader, Microsoft Office and Visio

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 9.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning,and code enhancements.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Involved in gathering information for various scenario for Change Data Capture.
• Worked with DBA to set up the DEV and QA environment and various users and roles
• Involved in Developing Unix script to load data to Teradata using FLOAD, TPUMP, MLOAD, BTEQ, etc.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Developed mappings, sessions and workflows (ETL) for SCD types I, II and III to meet the above requirements
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner
• Created Mapplet and used them in different Mappings
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
• Performance tuning using round robin, hash auto key, Key range partitioning
• Adhoc data requests and investigations
• Tier 3 support of EDW production processes including, but not limited to Issue investigation, root cause analysis, and defect resolution
• Design, develop and implementation of quality assurance and quality control processes
• Design and develop the semantic layer for the reporting purpose so that the end user reporting may not be affected.
• Captured the changes in the data field and analyzed the impacts on different systems with the introduction of Oracle’s off shelf product.
• Extract data from Oracle and upload to oracle tables using Sql Loader
• Derived the data mappings that could load all the information from sources to the targets.
• Designed the informatica source from mainframe system to target mappings to perform the initial load into the production server.
• Devised strategies of extracting data from UNIX to Staging and then from Staging to ORACLE RDBMS.
• Efficiently utilized Transformations including Expression, Router, Joiner, and Connected and Unconnected lookups, Filter, Aggregator, Rank, Sorter and Sequence Generator in the mappings.
• Implemented and extensively worked on slowly changing dimensions Type1, Type2 and Type3 for accessing transaction history of accounts and transaction information using Change Data Capture (CDC) corresponding to business requirements.
• Designed and Developed Relational and Dimensional Data Models in Framework Manager based on client’s reporting requirements.
• Designed and Developed List Reports, Crosstab Reports, Charts by using Cognos 10 Report Studio and Query Studio.
• Held sessions with business user and data analysts to gather requirements and associated different source systems for data integration process.
• Identified documented data sources and transformation logic required to populate data and maintain targets.
• Played key role in determining data feed extraction process, data analysis, and testing and project coordination.
• Designed conceptual design model to understand the base architecture of data integration process includes sources, transformations rules and target.
• Transformations logic implemented to support ETL (extract, transform, load) processes to load data into staging database using Informatica power center.
• Applied transformation logics by implementing transformations such as XML transformation, lookup transformations, Update strategy transformation, expression transformation, joiner transformation etc to extract, transform and load data into target.
• Designed re-useable transformations to quickly add new data sources and transformations related to business needs.
• Implemented change data capture mechanism using slowly changing dimensions type-II.
• Event wait, event raise, command task utilized to handle the execution of workflow sessions using Informatica workflow manager.
• Develop store procedure, packages to utilize in mappings using store procedure transformation..
• Gathered Business requirements by conducting meetings with business analyst, stake holders, development teams and data analysts on a scheduled basis.
• Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Created Mapplets using Mapplets Designer.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Captured source file/table definitions, target data, and data mart table definitions.
• Create and maintain metadata and ETL documentation that support business roles and detailed source to target data mappings.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Created and Scheduled Sessions and Batch Processes based on run on demand, run on time, run once, and run continuously.
• Interacted with business users, analysts for requirements, developed conceptual and logical data models.
• Wrote PL/SQL Packages, procedures, functions in oracle for business rules conformity.
• Utilized SQL loader, export/import utilities for data load and transformation.

Environment: Informatica Power Center 8.1.1, DB2, Oracle 10g, SQLSERVER 2005, UNIX, TOAD, Visio 2000, SQL*Plus, Core FTP & Windows XP.

Confidential

Data Base Developer

Environment: - SQL Server 2005, Oracle 8i, Erwin, UNIX and Shell Scripting

Responsibilities:

• Worked with business users to define and analyze problems and business needs by involving in sessions with the analysts.
• Created a bridge table for the numerous dimension groups and related them accordingly.
• Applied reusable tasks and work lets in informatica that can be helped for easier design of workflows to implement the transformations that help movement of data from diversified sources to the target.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations
• Written UNIX Shell Scripts and Pmcmd command line utility to interact with Informatica Server from command mode.