SUMMARY

• Seven plus years of experience extensively in data extraction, Transformation and loading data from various sources like Oracle, DB2, SQL Server and Flat files.
• Strong experience in Data Warehousing and ETL using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager
• Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Performed SQL tuning using Explain plans
• Worked on Incremental Loading, Type 1/2/3 dimensions, slowly changing dimensions etc.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center
• Well versed in developing the complex SQL queries, unions and multiple table joins and Views. Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
• Well versed in unix shell scripting.
• Worked on scheduling with Autosys and batch processing.
• Experienced with Oracle Fusion HCM Cloud.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Experience in documenting High Level Design, Low level Design, Unit test plan, Unit test cases and Deployment documents.
• Good communication skills, interpersonal skills and problem solving ability.
• Good team player as Lead/Consultant/Developer.

TECHNICAL SKILLS

Data warehousing Tools: Informatica Power Center 9.6/9.1/8.6

Databases: Oracle, MS SQL Server, DB2

Languages: PL/SQL, Unix-Shell Scripting, Java, C

BI Tools: OBIEE, BI Publisher

Tools: /Utilities: SQL Developer, TOAD, SQL * Loader, Putty, WinSCP, Utilities, Autosys

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Created various tasks like Session, Command, Timer and Event wait.
• Design complex mappings involving constraint based loading and target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and create mapplets that provides reusability in mappings.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with views.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices

Technologies: Informatica Power Center 9.5.1, Oracle 11g, DB2, SQL, PL/SQL, Unix, Flat Files,Putty, WinSCP, Toad 10.6, SQL Developer.

Confidential, Charlotte, NC

Informatica Engineer

Responsibilities:

• Created and follows a work plan and delivers it as per roadmap and cloud methodology
• Assumed responsibility to successfully perform tests for the solution developed, including the user acceptance test with users to validate the solution
• Provided information to the designated project manager to ensure detailed planning of the project and acceptance from other key stakeholders of the client.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Modified BI publisher reports.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with views
• Able to coordinate with Oracle for SRs, ability to coordinate upgrades/patches/fixes
• Worked on scheduling with Autosys and batch processing.
• Experienced with Oracle FusionHCM Cloud.
• Involved in integration of PeopleSoft and Oracle HCM Cloud Project

Technologies: Oracle Fusion HCM Cloud, OBIEE, BI Publisher, Informatica Power Center 9.6.1, Oracle, DB2, PL/SQL, Unix, Flat Files,Putty, Autosys, AQT

Confidential

Informatica Engineer

Responsibilities:

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Modeled the data warehousing data marts in Star join schema.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning at source, target,mapping and session level.
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.

Technologies: Informatica Power Center 9.1, Oracle 11g, DB2 9, SQL, PL/SQL, Unix, Flat Files, Crystal Reports, Mainframe, JCL, COBOL,Putty, WinSCP, Erwin,Autosys, Toad 10.6, Jira, MS Office Suite etc.

Confidential

Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using InformaticaPowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2 and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using InformaticaPowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have generated reports using Crystal Reports.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Technologies: Informatica Power Center 8.6.1, Oracle 11g, DB2 9, JCL, COBOL, Toad, Jira, Putty, WinSCP, MS Office Suite etc.