PROFESSIONAL SUMMARY:

• 9+ years of experience in Design, Development and Business intelligence and Maintain ETL process using Informatica 9.6.1 and lower versions across Healthcare, Automotive, Financial and Insurance sectors..
• Expert knowledge in working with ETL tool Informatica Power Center 9.x/8.x
• Extensively used Informatica Repository manager, Power center Designer, Workflow manager, and Workflow Monitor.
• Proficient in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
• Experience in designing and developing complex mappings applying various transformations such as Expression, Aggregator, Lookup, Source qualifier, Update strategy, Filter, Router, Sequence generator, Rank, Normalizer, Sql, Union, Java, Salesforce lookup, Stored procedure, Joiner and Sorter.
• Extensive experience in performance tuning and resolving performance bottlenecks of sources, transformation, targets, mappings and sessions.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica PowerCenter.
• Expertise in Data warehousing concepts like OLTP/OLAP System, Star schema and Snowflake schema used in relational, dimensional modelling.
• Working Experience in UNIX commands, DOS Scripts
• Extensively Worked in Performance of SQL Queries
• Experience in using Oracle 11g/10g/9i, SQL (DCL, DML, DDL, TCL), PL/SQL, and SQL Editor (SQL*Plus, TOAD).
• Automation and scheduling of Informatica jobs using AutoSys.
• Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica PowerCenter 9x/8x, Informatica Power Exchange.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling, Entities, Attributes, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, MS Access, IBM DB2, Teradata

Programming: C,C++,SQL, PL/SQL,HTML,JAVA, Unix Shell Scripting

Other Tools: SQL Plus, TOAD, SQL developer, SQL server 8,12, AutoSys

Environment: UNIX, Windows (XP, / 2003/2005/2008 ).

Other: MS Office 2003/2007/2010/2013 : Word, Excel, Outlook, PowerPoint, Notepad ++, Notepad, MS Visio, OneNote, Adobe Acrobat

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Used Informatica PowerCenter 9x and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Participated in Logical and Physical data modeling and designed Star Schemas.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, and mapplet designer, transformation developer in Informatica Power Center 9.6.1/9.5.
• Handled slowly changing dimensions (Type I, Type II and Type III) based on the business requirements.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Worked along with the DBA to resolve performance and tuning issues.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.

Environment : Informatica Power Center 9x, Oracle 11g, DB2, XML, Flat files, SQL, PL/SQL, TOAD, SQL*Plus, Windows, UNIX.

Confidential, Philadelphia, PA

Informatica developer

Responsibilities:

• Worked with business analysts, data modelers and database to help identify data sources.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Involved in implementing the Land Process of loading the customer Data Set into InformaticaMDM from various source systems.
• Collaborated with the data modelers to perform mappings and organize the data using the Erwin tool for data modeling.
• Worked with Informatica power center 9x to extract the data from Oracle into Data warehouse.
• Developed complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Developed connected and unconnected Lookup transformations to lookup the data from the source and target tables.
• Created Context Groups and variables to run jobs in Dev, Test and Production environments
• Responsible for making suitable changes in the development environment as per the business requirement and also tuned for better performance
• Created Mapplets and used in different Mappings.
• Used designer debugger to test the data flow and fix the mappings. Involved in Unit testing of mappings, workflows and debugging mappings for failed sessions.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Created Schema objects like Indexes, Views, and Sequences.
• Created several complex PL/SQL Packages, Procedures, Triggers and Functions to implement business logic at front end and also perform validations on the imported data from legacy system.
• Designed and developed table structures, stored procedures and functions to implement business rules and used application development tools like TOAD (Oracle) to develop SQL queries and stored procedures. Teradata as backend database.
• Designing and creation of complex mappings using SCD Types involving transformations.
• Developed UNIX shell scripts, commands to implement ETL process
• Involved in creating best practice documents for ETL Process.
• Collaborated with development and testing team to support end to end testing.

Environment: Informatica Power Center 9x, Oracle 11g, SQL Developer, TOAD, PL/SQL, Unix, Windows XP/7, SQL Server.

Confidential, Danville, PA

Informatica Developer

Responsibilities:

• Involved in requirement gathering with business users and converted them into mapping documentation.
• Extensively word on Informatica Power Centers tools like Designer, Workflow Manager and Repository Manager.
• Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Union, Rank and etc.
• Developed complex mappings and involved in tuning for better performance.
• Designed and executed error handling process using Informatica Debugger.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Developed number of Complex Informatica Mappings and Reusable Transformations based on the business rule.
• Involved in creating SQL overrides in source qualifiers for extracting only the required rows for ptimal performance.
• Created complex transformations using connected/unconnected Lookups.
• Created Reusable Transformations and Mapplets based on the business rules.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts to implement ETL process.
• Involved in creating best practice documents for ETL Process.
• Involved in coordinating with DBA to increase performance of ETL process by creating indexed on target tables as required.
• Collaborated with development and testing team to support end to end testing.

Environment: Informatica Power Center 8x, Oracle 10g, SQL Developer, TOAD, PL/SQL, Unix, WindowsXP/7, SQL Server.

Confidential, IL

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse
• Involved in moving data to Staging, staging to Data warehouse.
• Worked with Informatica power center 8.6 to extract the data from Oracle, flat files into Data warehouse.
• Worked with various Informatica client tools like PowerCenter Designer, Workflow Manager, Workflow monitor, repository manager.
• Used Informatica Designer to create complex mappings using different transformations like Sequence Generator, Filter, Lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to move data to a Data Warehouse.
• Worked with various Connected/unconnected lookup, Static lookup, Dynamic lookup, Persistent lookup, Shared lookup.
• Designing and creation of complex mappings using SCD Type II involving transformations such as Expression, Source Qualifier, Joiner, Aggregator, Connected and Unconnected Lookup, Update strategy, Sequence Generator, Router and Filter Transformations.
• Used mapping variables and mapping parameters in the mappings.
• Responsible for troubleshooting the Informatica tasks and data issues using the session logs, debugger.
• Created reusable mapplets using Mapplets Designer and used them in different data Mappings.
• Involved in Unit testing & System testing of all the jobs and performance testing.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs.

Environment: Informatica Power Center 8x, Oracle10g, SQL, PL/SQL, TOAD, Windows, UNIX Shell Script.

Confidential

Informatica Developer

Responsibilities: -

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Created ETL design and mapping documents for the change requests and developed several Informatica mappings (Aggregator’s, lookup, sorter, filter, joiner etc.).
• Responsible for making suitable changes in the development environment as per the business requirement and also tuned for better performance.
• Created Mapplets and used in different Mappings.
• Used designer debugger to test the data flow and fix the mappings. Involved in Unit testing of mappings, workflows and debugging mappings for failed sessions.
• Tuned Informatica mappings and sessions for maximum efficiency and performance.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Created Schema objects like Indexes, Views and Sequences.
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.
• Created several complex PL/SQL Packages, Procedures, Triggers and Functions to implement business logic at front end and also perform validations on the imported data from legacy system.
• Responsible for Backup recovery to all the mappings, sessions and workflows at the repository server
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies

Environment: Informatica Power Center 8.5.1/8.5, Informatica Power Exchange 8.0.1, TOAD, SQL, PL/SQL, Windows, UNIX Shell Script.