SUMMARY

• 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) and 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

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