Professional Summary:

• Over 6 years' experience in IT industries and 6 years of Data Warehouse experience with domain knowledge of Finance/Banking, Telecommunications, Retail, Insurance and Healthcare.
• Expertise in Data Analysis, Data Profiling, Developing and Deployment for Data Integration.
• Experience in gathering requirements, creating Functional Design Documents and Functional requirements.
• Extensive experience in ETL and Data Integration for developing ETL mappings and scripts using Informatica Power Center 8.6.1/8.6/8.1/7.1 using Designer, Repository Manager, Workflow Manager Workflow Monitor. Exposure on Power Exchange functionality.
• Extensive experience in creating Transformations and Mappings using Informatica Designer to implement business rules and processing tasks using Workflow Manager to move data from Multiple Sources into Targets.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, XML, Stored procedure in Informatica PowerCenter Designer.
• Extensive expertise in Debugging, Performance Tuning and Optimization of the Sessions and Mappings.
• Proficiency in data warehousing techniques for Data Cleansing, Slowly Changing Dimension Phenomenon, Surrogate Key assignment, Change Data Capture CDC .
• Extensive Experience in integration of various RDBMS like Oracle 8i/9i/10g, DB2, SQL server and MS access into staging area.
• Experienced in Multi-Terabyte environments, solid experience in coding using SQL, SQL Plus, PL/SQL.
• Expertise in creating Stored Procedure/Functions, Triggers and Packages in Oracle 9i/10g.
• Profound knowledge of the principle of Data Warehouse using Fact tables, Dimensional Table, Star Schema Modeling and Snowflake Schema Modeling.
• Exposure knowledge of Informatica Migration and Upgrade.
• Experience working with SDLC and implementing, Waterfall and Agile methodologies.
• Experience working with Informatica in UNIX and LINUX environments.
• Involved on report creation using OLAP data source with strong knowledge in OLAP universe.
• Coordinate ETL and database development work with developers and conduct code reviews.

Technical Summary: Informatica Power Center 8.6.1/8.5/8.1/7.1,IDA,IDE,Business Object, Congo, Power Exchange, Erwin 7.0/5.1,Visio,Oracle PL/SQL, SQL Plus, T-SQL, SQL Server, Kern Shell Scripts, Oracle 8i/9i/10g, MS SQL Server 2000/2005, MYSQL, JAVA, PL/SQL, HTML, XML, Microsoft Windows NT/00/XP/03/07, Toad 8.6, MS Office Suit, Macromedia Dreamweaver.

Professional Experience:

Confidential

Informatica Developer

Responsibilities:

• Determined appropriate work procedure or approach to address technical challenges. Creates technical specification and performs technical analysis for multiple projects.
• Created Data Mapping, Service Mapping, Service Interface Design, Functional Design, profiling reports.
• Created technical specification and performs technical analysis for multiple projects.
• Took responsible for low-level application design, conducting code reviews and unit test reviews.
• Handled implementation of typically more than one IT project includes pre-implementation support, estimation of cost and effort, infrastructure needs, and post-implementation maintenance support . Works under general supervision. Typically works on multiple IT projects simultaneously.
• Participated in creation of deployment plan and cutover activities leading up to the deployment and in the actual deployment.
• Actively engaged in resolving development and production incidents and problems.
• Provided the Knowledge Transfer to production support team before deployment
• Created stored procedure, utilized the procedure in Informatica mapping.
• Designed and developed purge generic purge processing.
• Designed and developed automated creation of Health condition/Allergy and Medication xref file automated after research from the files provided by vendors like Medispan and First Data Bank.
• Designed and build for the new process of reconciliation process.
• Migrated codes from one environment to another environment based on different phase of project.
• Used Expression, Union, Connected/Unconnected Lookup, Aggregator, Sorter, Filter, Router, Stored Procedure, Sequence Generator, Update Strategy and XML Transformations.
• Participated during the Web services designed and it's publish /subscribe to or from different source system and impact on ODS.
• Involved data modeling for the cross walk tables and design of the new tables based on new business requirements.

Environment: Oracle 9g-10g-11g, MS SQL 2008, PL/SQL, MS Visio, Golden Gate, Data Power, Initiate MDM ,Informatica 9.0.1,Web Services, Share point, UNIX.

Confidential

Informatica Developer

Responsibilities:

• To analyze the sources data and did the entire source to target documentation for all kind of source.
• Review requirement with SMEs and changed some mapping script after review.
• Provide on and off hour production support of the ETL Jobs. Fix production issues and deploy.
• Create views in SQL Server according to business requirements including multiple joins.
• Create stored procedure to load the archive table after ETL.
• Create stored procedure, function, views and staging tables in SQL server to get result for the business requirement.
• Unit test for source analysis and target using SQL Oracle Developer
• Used PL/SQL to load some small and straight forward load using ODBC driver connection.
• Bio-repository data was in flat file via FTP so loaded using SQL loader to Oracle staging table then loaded to the sapphire using ODBC and some using Informatica directly from Flat file to Target.
• Export Informatica mapping from DEV to QA and QA to production using Deployment group method.
• Router transformation are used when need to load a table which have self Referential Integrity.
• Used multiple pipelines for parallel load and Partitioned the table to load for some table.
• Used PMCMD command to execute workflow. Wrote some Shell Script.
• Create Informatica Documents including all the information with mapping, session, workflow etc.

Environment: Informatica Power Center 8.6.1, Oracle 10g, MS SQL 2005, Oracle 10g/9i, Unix Shell Scripting, C5 LIMS,LIMS Online, Laboratory Intelligence LI , T-SQL, PL/SQL, Erwin 8.1

Confidential

Informatica Developer

Responsibilities:

• Worked with Data Analysts to identify business requirements for the ePayment. Worked with Business System Analyst to find out the tables that is need for the ePayment.
• Involved in Data Warehouse Technical Design Document for High Level load Strategy and ETL design.
• Applied business logic in the mappings for inserting and updating records in the database.
• Involved in designing Dimensional Data Modeling using Ms Visio as business requirements.
• Replicated data from EPayments Visa Net and Chesapeake T-recs applications to Consumer Operating DataStore and from ERP which is also required for reporting replicated to Operating DataStore.
• Populated data into staging tables, dimensions and fact tables using type-1 and type-2 SCD strategy from Relational Databases and ERP VCMG's tables.
• Worked with mappings using expressions, aggregators, filters, joiner, connected/unconnected lookup, update strategy and stored procedures transformations.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Created different kind of reporting for reconciliation depending on business requirements
• Developed PL/SQL Procedures, Functions, Packages, SQL scripts in Oracle 9i/10g.
• Create parameter and variables and called them whenever required.
• Wrote UNIX shell scripts to prepress data using PMCMD command.

Environment: Informatica Power Center 8.6.1, Informatica Data Quality 8.5, Oracle 10.2.0.4, 11i ERP, XML, Windows XP, Ms Visio, Approx., T-Recs, Business Object, UNIX, SQL Developer.

Confidential

Informatica Developer/Analyst

Responsibilities:

• Involved during the gathering of information from Alltel CRM, Call Centers, and Marketing Sources of each region during the development of the Data Model and Design.
• Compared all the data definition of the Verizon and the Alltel and mark where to change the data format during staging area.
• Extensively involved in data cleansing, duplications removal and data profiling.
• Participated in prepare documentation on all aspects of ETL processes, definitions and mappings.
• Designed Data Modeling using Erwin.
• Created various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer.
• Create Slowly Changing Dimension type 1 and type 2 depending upon the requirements.
• Created store procedure for creation and dropping of indexes and used in mapping.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time with required frequency.
• Created workflow daily, weekly and monthly data operations, workflows and scheduling processes.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels. Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length, and target based commit interval
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment.

Environment: Power Center 8.6, Control M, Erwin, UNIX, Oracle 9i/10g, XML, Flat File, Windows XP.

Confidential

ETL developer

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Extracted data from flat files, XML, oracle database and SmartPay to load them in the central oracle 9i database.
• Created various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Extensively used various Performance tuning Techniques like Optimized Query Performance, Session Performance, Reliability, Partitioning, etc.
• Extensively used Informatica tools - Informatica Designer, Workflow manager, Workflow monitor and Repository Manager.
• Successfully moved the Sessions and Batches from the development to production environment.
• Designed and developed several scripts for Extracting, Transformation and Loading of data using Informatica, UNIX shell scripts to load data from different sources.
• Involved with QA team for validation and verification of the development.

Environment: Power Center 8.1, Oracle 9i, Flat files, XML, SAP R/PL/SQL, Windows XP, UNIX, Toad