Summary:

• 7 Years of IT industry experience including analysis, design, development, testing, and defect tracking of Data Warehousing and Client Server Applications.
• Highly proficient in Data Warehousing ETL using Informatica Power Center 6.1./7.1/8.1/8.6, Oracle 10g/9i/8.x/7.x, Business Objects 5.0, Cognos Impromptu 5.0, Transformer 6.5, Power Play 6.5.
• Expertise in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling using Erwin 4.2/4.0/3.5.5/3.5.2 , Microsoft Visio.
• Extensive work experience in the areas of Finance, Banking and pharmaceutical.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, unit testing, integration testing, regression testing and UAT in development.
• Actively involved in Performance Tuning targets, mappings and sessions, Error handling Product support on various Platforms.
• Excellent knowledge of studying the data dependencies using Metadata stored in the Informatica Repository and preparing batches for the existing sessions to facilitate scheduling of multiple sessions.
• Extensively worked on the ETL mappings Analysis, Design and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Experienced in various data sources like SQL Server, Oracle, DB2, Fixed Width and Delimited Flat Files, Informix and Sybase etc.
• Extensive knowledge in Teradata, SQL PL/SQL programming and Oracle 9i/8i/7.x.
• Expert in Unix Shell Scripting
• Excellent Analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Have strong inclination to get my career on the fast track by learning and implement new technologies.
• Ability to function both in a team environment as well as individual capacity.

Technical Skills:

Professional Experience:

Confidential

Sr.Informatica Consultant

Responsibilities:

• Responsible for developing several complex mappings for processing the feeds, re-defined existing process to accommodate batch schedule-using Worklets and developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Teamed together with client resources to design the to-be processes, applying standards and facilitating the industry best practices.
• Implementation of best practice integration methods based on Informatica framework.
• Responsible for the Design, Analysis implementation of the Interface Gateway for a global gateway process to handle multiple feeds from several different regions of Citigroup Europe, Asia-Pac rim, Australia North America.
• Responsible for identifying reusable logic to build several Mapplets, utilizing shared folders to incorporate them as shortcuts, which would be used in several mappings.
• Used informatica powercentre DVO for data validation and reconciliation testing which helps reducing the need to write time consuming and error prone testign scripts.
• Used DVO for joining multiple tables in target to verify data.
• Scheduled several jobs using Autosys tool, creation of Autosys jils, changing job definition handling scheduling issues.
• Responsible for installing Informatica 9.5 after migration from Informatica 8.6.
• Developed processes for automation of loading data to multiple instances using worklets, parameter driven sessions for batch schedule of processes, verification and re-conciliation of data stored in several different source systems.
• Involved in developing several UNIX scripts for performing validations.
• Involved in writing stored procedures PL/SQL programs GL interfaces built.
• Provided automation of the mentioned process for loading data into several different instances.
• Created Test cases by taking input from Business Analysts and Technical Manager.
• Tested the feeds regarding the functionality and Performance manually.
• Validated the feed processing in different stages like File Watcher conditions, PRE ETL, ETL, POST ETL and Oracle Apps Import/Post processes.
• Created parameter files in Informatica and passed them to Informatica Tasks.
• Responsible for troubleshoot performance of Workflows individually and validated the data.
• Execution of Test plan, Implementation Plans identified areas for process improvement of workflows, mappings in Informatica.

Environment: Informatica 9.5/8.6, Oracle 10g, Oracle Apps 11i, Hyperion Essbase 7.x, Autosys, TOAD, ERWin, UNIX.

Confidential

Sr. Data Warehouse Analyst/ETL Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access and Flat files.
• Working with Informatica Meta Data Manager in analyzing the production data issues.
• Working with Informatica Data Quality tool to build profiles and ensure data quality to the consumers.
• Involved in Data Profiling and Data cleansing process.
• Responsible for determining the Mapping bottlenecks with Informatica and fixing the issues by tuning the Mappings for better performance.
• Developed several complex mappings using mapplets to transfer data to target system.
• Coordinate production change requests and production releases.
• Troubleshooting load failure issues and data quality issues on a day to day basis.
• Used Informatica DVO for automated data testing and validation that lowers project risk and increase data accuracy.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.
• Using SQL Maintained and enhance the existing data warehouse, exports, and reports.
• Used Informatica Debugger to troubleshoot data and error conditions.
• Maintain documents for all the Development work done and error fixings performed.
• Involved in deploying and redesigning of several ETL processes for the existing research line of business
• Used Debugger wizard to troubleshoot data and error conditions.
• Experience in preparing reports on the performance of the UNIX operating systems and applications run on these systems.
• Worked on writing codes for languages such as C, Perl, Shell, etc
• Involved in training the users about working on various UNIX based applications.
• Responsible for Best Practices like naming conventions, and Performance Tuning.
• Developed Reusable Transformations and Reusable Mapplets.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used tools like TOAD and SQL navigator to run the queries and validate the data loaded into Marts and different other layers like Data Warehouse and Persistent Staging.
• Involved in taking Knowledge Transfer from a different vendor before two weeks of Go Live and handled different performance issues affectively.
• Responsible to Run Unix scripts to startup the Java Web Service to generate the Load confirmation emails to users.
• Coordinate with Offshore team on daily basis to handle production support issues and get daily updates from the team on the development work.

Environment: Informatica Power Center Repository Manger, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer , Power Exchange SAP , UNIX, oracle 9i, 11g ,SQL, PL/SQL, TOAD, Informatica Meta Data Manager, Informatica Data Quality, Erwin.

Confidential

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field user and support for production environment
• Extensively Designed, Developed, Tested Informatica mappings, mapplets and Reusable Transformations to load data from various sources
• Extensively Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Created workflow design document, mapping design document, Integration test plan document, Unit test plan document etc.
• Extensive experience in loading the data from multiple sources like flat files, other RDBMS databases.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Used the update strategy to effectively flag the data from source to target.
• used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created, Configured and Scheduled the Sessions and Batches for different mappings using workflow Manager and UNIX Scripts.
• Integrated various sources into the Staging area in Data warehouse.
• Created necessary Repositories to handle the Metadata in the ETL process.
• Created the Source and Target Definitions in Informatica Power Center Designer.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Provide production support as needed.

Environment: Informatica Power Center 8.1.1, Power Connect, Oracle 9i, PL/SQL, SQL, SQL PLUS, SQL LOADER, RDBMS, Teradata, Power Connect, Power Center, ERWIN 3.5, UNIX Shell Scripting.

Confidential

Informatica Developer

Responsibilities:

• Extracted data from different sources like DB2, Oracle, MS Access, Flat files and loaded into Oracle database.
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex business rules.
• Worked with Various transformations like Expressions, Lookups, Filters, Sequence Generator, Joiner, Aggregator, and Transaction Control were used to handle situations depending upon the requirement.
• Created Parameter file for session parameters and called in the sessions.
• Created Partitions to concurrently load the data into targets.
• Imported various Sources, Created Targets, and Transformations using Informatica Power Center.
• Performed Unit Testing and verified the data.
• Tuned mappings and sessions for better performance of the data loads.
• Performed Error Handling on Sessions.
• Written UNIX shell Scripts PMCMD commands for FTP of files from remote server.
• Performed Informatica Code Migration from development to testing and testing to production systems
• Involved in Full Life Cycle Development of the Project.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Implemented Slowly Changing dimension SCD methodology for accessing the full history of accounts and transaction information.
• Managed the Informatica sessions/batch and schedule them.

Environment: Informatica Power Center 7.1 Repository Manager, Designer, Workflow Manager , SQL server 2000, Oracle 8i, Toad, MS SQL server 7.0, DB2 5.1, Windows NT, 2000, HP- UNIX, Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions.
• Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, and Informatica Repository.
• Created reusable transformations and Mapplets to use in multiple mappings. Used debugger to test the data flow and fix the mappings.
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager.
• Responsible for verification of functional specifications and review of deliverables.
• Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 7.1.
• Involved in system study, analysis of the requirements and designing of the complete system.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Created repository, Groups, Users assigned privileges using repository manager.
• Developed mappings/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Worked with XML sources to get the data to Oracle to suite our environment.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager.
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Developed Unit test cases for all the jobs.
• Provided assistance during user testing.

Environment: Informatica Power Center 7.1, Oracle 9i, MS SQL SERVER, PL/SQL, SQL LOADER, UNIX Shell Script, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Used ETL using Informatica Power Center to load data from MS SQL Server6.5, Sybase to the target Oracle8i.
• Worked on Informatica Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Worked with different transformations like Stored Procedure, Filter, Expression, Aggregator and Joiner.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Created Catalogs, Filters, Calculations, and Prompts using Impromptu Administrator.
• Created different report files like IMR, IQD and Created Powercubes in Transformer.
• Created transformations like Stored Procedure, Aggregate, and Expression.
• Involved in Logical and Physical modeling using ERwin.
• Tuned the mappings for better performance maximum efficiency.

Environment: Informatica Power Center 5.1, Cognos Impromptu Administrator, Transformer, IWR, Oracle 8i, SQL, PL/SQL, IIS Server5.0, Microsoft Analysis Server 2000, JSP, XML, MS SQLServer2000, ERWIN 4.0, Microsoft PowerPoint, Visio, Word, Excel, UNIX-HP, Windows NT 4.0.