SUMMARY

• Around 6 years of IT experience with extensive Data Warehousing implementations across Financial and Health Sectors.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Good understanding of software development process like SDLC (Software Development Life Cycle).
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Good understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL server and non-relational sources like Flat files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank)
• Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Extensively worked on Developing Debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter 10/9.X (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, Metadata, DataMart, FACT & Dimensions tables.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

Databases: Oracle 11g/10g/9i/8.0 Sql Server, Tera Data.

Programming: SQL, PL/SQL, Unix, Shell Scripting, C, HTML, Java.

Tools: TOAD, SQLDeveloper, SSMS, Notepad++

Environment: UNIX(IBM AIX,Sun Solaris), Windows XP, Linux

PROFESSIONAL EXPERIENCE

Data Conversion, Informatica Developer

Confidential

Responsibilities:

• Understood the welfare requirements and developed code in Informatica for converting Mainframe to Target Sql Server.
• Developed reusable components in Informatica that can be used to reduce the time and effort for future requirements.
• Developed and executed Unit test cases for the code.
• Supported Functional specific testing and Technical acceptance testing.
• Understood end-to-end technical architecture of the client’s environment and proposed performance improvement options in the project.
• Worked on performance tuning of Informatica ETL code and Oracle Queries.
• Reconcile data migrated to Staging with Extract.
• Worked on performance tuning at various levels like mapping level, session level, and database level.
• Developed UNIX script to launch the Informatica workflow from the command line in Linux.
• Involved in gathering the Business requirements to code the mappings.
• Extensive experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Index Cache and Data Cache in cache using transformation like Lookup, Joiner, and Aggregator Transformations.
• Developed Packages, stored procedures making use of Functions to optimize the query as a part of Extract, Transform and Loading in staging areas.
• Worked on the Indexing the necessary columns in a table, while the tuning the Informatica queries at database level.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement
• Generated parameter files dynamically with the data from database table.
• Created objects like Mapplets, reusable transformations, shortcuts for ease of enhancement by facilitating reusability.
• Developed mapping parameters and variables to support SQL override.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.

Environment: InformaticaPowerCenter, Oracle, SQL Server, DB2, Files, Flat Files, Autosys.

Informatica Developer

Confidential, IL

Responsibilities:

• Working on a migration project where I have to design and decommission the existing Oracle to a Teradata db.
• Interact with Business and have to create the data models, design them and create the ETL components.
• Worked on dimensional modeling to design and develop STAR Schemas, identifying Fact and Dimension tables for providing a unified view to ensure consistent decision making.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables. Involved in data modeling Using Erwin.
• Worked with heterogeneous sources from various channels such as Oracle, SQL Server, flat files, and web logs.
• Worked onInformatica Tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used transformations such as Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• UsedInformaticaRepository Manager to create repositories and users as well as give permissions to users.
• Developed mappings reading source through Power Center Connect from Web services.
• Developed interfaces using UNIX Shell Scripts to automate the bulk load, updated processes/batch processes, scheduled sessions and batches using Server Manager.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Created effective test cases and did unit as well as integration testing to ensure the successful execution of data loading process.
• Analyzed session log files in case the session failed to resolve errors in mapping or session configurations
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Has experience working in an Agile Environment.

Environment: Informatica Power Center, Oracle, Shell scripting, Crystal Reports, Linux.

Informatica Developer

Confidential

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle.
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Used Power mart Workflow Manager to design sessions,
• Created parameter based mappings, Router and lookup transformations
• Created mapplets to reuse the transformation in several mappings
• Used Power mart Workflow Monitor to monitor the workflows
• Has experience working in an Agile Environment.
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Created daily and weekly workflows and scheduled to run based on business needs
• Created Daily/weekly ETL process which maintained 100GB of data in target database
• Involved in Unit Testing, Integration Testing, and System Testing

Environment: Informatica Power Center, Oracle 10g, Cognos 8, Shell scripting, Windows 2000