SUMMARY:

• Over 7 years of experience in the field of Information Technology, with experience in analysis, design, development, Data Warehouse, Unit testing and Documentation.
• Strong experience in using ETL (Extraction, Transformation, Loading) utilizing Informatica Power Center 7.1/8.6/9.6.
• Experience in Extraction, Transformation and Loading of data directly from different heterogeneous source systems like Oracle 10g/11g, DB2, Flat files, Excel and Microsoft SQL Server.
• Experience in Informatica PowerCenter - Mapping designer, Workflow manager, Workflow monitor, various transformations such as Source qualifier, Expression, Joiner, Normalizer, Router, Aggregator, Lookup, Filter, Sequence Generator and Update strategy.
• Worked on Oracle 11g/10g (PL/SQL) to write procedure for computation and of data and loaded into data warehouse/flat files.
• Strong Data Warehousing ETL experience of using Informatica 9.6/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Extensively worked on Informatica Power Center (9.1/8.6) Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, XML Source Qualifier, External procedure.
• Experience in creating Informatica mappings for push down optimization in order to load Teradata tables.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2,ESB/ERP Implementation, Teradata and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Participated in Design team and Requirement gathering meetings.
• Experience in developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS), developing reporting solutions using SQL Reporting Services (SSRS), creating cubes for analysis using SQL server Analysis Services (SSAS).
• Experience in handling “Slowly Changing Dimensions” to maintain the complete History.
• Hands-on Experience in development, maintenance and enhancement projects and to create solutions according to customer requirements.
• Knowledge and experience in UNIX commands.
• Knowledge in Star Schema, Snow Flake Schema, Dimensions and Fact tables.
• Solid experience in writing SQL queries.
• Extensively involved in using Quality Center, Clear Quest, and Test Director to report bugs.
• Prepared Daily status reports and Weekly status reports.
• Involved in the migration of Informatica Powercenter v 9.1 to v 9.6.
• Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.

TECHNICAL SKILLS:

ETL TECHNOLOGY: Informatica Power Center 9.6/9.6/8.6/8.1/7.1, Informatica Power Exchange 9.6.5/8.6

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development

DATA MODELLING: Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin

DATABASES: Oracle 11g/10g/9i, MS SQL Server7.0/2000,MS Access, Sybase, DB2,MySQL,Teradata 13/V2R6

PROGRAMMING: SQL, PL/SQL, UNIX Shell scripts, C, C++, Java, VB Script

REPORTING TOOLS: Business Objects XI, OBIEE 10g.

OPERATING SYSTEMS: Sun Solaris, UNIX, LINUX, MS-DOS

APPLICATIONS: MS Office, MS PowerPoint, MS Project, FrontPage, Toad 9.2/8.6

MANAGEMENT TOOLS: MS-Office 2007, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Extensively worked with Informatica Power Center.
• Analyzed the source data and Worked with multinational users to identify the gaps in available source data and business requirements.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• 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/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Created reusable transformations and mapplets and used them in mappings.
• Worked on Performance tuned Interfaces , queries through use of indexes, ranks, Oracle hints.
• Wrote detailed design specs for ETL . Converted the functional specs written by Data Modelers into the detailed design spec for ETL
• Created both Inbound/Outbound interfaces to keep the Oracle Cloud Fusion and the legacy systems in sync using SSIS.
• Built a Framework to upload data files between on premises and cloud-based Oracle systems using SSIS.
• Working on creating SSIS packages using BIML script.
• Created the SSIS packages to load the Staging environment.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources.
• Created SSIS packages to extract/write data to Flat Files.
• Written command line scripts and embedded them into SSIS package to merge/zip files.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files, ESB/ERP Implementation etc.
• Implemented Full/Source/Target push down optimization techniques in Informatica in order to extract and load high volume tables.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Created variables in OBIEE to streamline administrative tasks.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Used Change Data Capture to implement incremental load.
• Used CDC mechanism to extract data which has changed at source since last extract and load it in Data marts.
• Developed Interfaces to load the data from Flat Files , SQL Server to stage and from stage to Oracle Data warehouse .
• Migrated from Informatica Powercenter v 9.1 to v 9.6.

Environment: Informatica 9.1/9.6, Informatica 8.6.1,OBIEE 11.1.1.6.0, SQL Developer 1.5.5, Oracle 11g, Rapid SQL, FileZila, Erwin, Unix Shell Script.

Confidential, Irving, TX

Informatica Developer

• Involved in designing the process for getting the data from all systems to Data Warehousing systems.
• Extensively Designed, Developed, Tested complex Informatica mappings, Mapplet and Reusable Transformations to load data from various sources.
• 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.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Designed and developed complex mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter and Router transformations.
• Extensively created Mapplet for reusable business rules.
• Used the update strategy to effectively migrate data from source to target.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Created tasks, workflows and worklets using workflow manager.
• Used Workflow monitor to monitor workflows.
• Experience in writing branching and merging methodologies in Python.
• For update and manipulation of file, Python scripts were used.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Performed Unit Testing and validated the data.

Environment: Informatica Power Center 9.1, Business Objects 5.1.3, Oracle 10g, PL/SQL, SQL*Plus, SQL Server, MS Access, XML files, UNIX Shell Scripting, Windows NT/2000.

Confidential, PA

Informatica Developer

• Interacted with users to capture and analyze business needs requirements.
• Involved in designing technical specifications for building Data warehouse and data mart
• Worked extensively on Informatica Designer to create and manipulate source and target definitions, mappings, mapplets and transformations
• Created mapping specifications and documents based on the mapping logic and business rules
• Created several mappings to load dimension and fact tables and implemented type1 and type2 slowly changing dimensions
• Used Informatica Designer to create complex mappings using various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse and Data Marts.
• Created reusable transformations and mapplets for better reusability.
• Worked with mapping variables, parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable.
• Involved in data validation and cleansing in the staging area.
• Actively worked on Performance Tuning of sessions and mappings.
• Created and monitored workflows using workflow manager and workflow monitor.
• Scheduled all the Informatica jobs to run into production using AutoSys scheduling tool
• Worked on migrating the code to higher environments.
• Performed production support after the project went live into production.

Environment: Informatica PowerCenter 8.1, Oracle 11g, PL/SQL, SQL*Plus, TOAD, UNIX Shell Scripts, AutoSys, SVN.

Confidential

ETL/Informatica Developer

• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked with Re-useable Transformations, Mapplets and Aggregate Functions like Avg, Min, Max, First, last in Aggregator Transformation.
• Experienced working with both Connected and Un-Connected Lookup.
• Identified the bottlenecks and fixed them with Performance Tuning.
• Followed the client security policies and necessary approvals to move the code from one environment to other.
• Used SQL Override function in Source Qualifier Transformation.
• Extensively used PL/SQL programming Functions, Procedures packages to execute business rules.
• Worked on Unit Testing of Mapping and Workflows.
• Experienced working on extracting data from different sources like SQL Server, Oracle, MS Access, Flatfiles and Teradata.
• Implemented different Loads like Daily, Weekly and Quarterly loads using Incremental Load Strategy
• Worked on Standard and Custom Model in Informatica MM (Meta Data Management)

Environment: Informatica Power Center 8.1, SQL Server, Oracle 10g, TOAD, UNIX, Flatfiles.

Confidential

Informatica Developer

• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center 6.x/7.0 tool.
• Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
• Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
• Used command line program pmcmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created and populated the intermediate aggregate tables to make the reporting efficient and fast.
• Designed processes to extract, transform, and load data to the Data Mart.
• Performed impact analysis, remedial actions and documented on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Environment: Informatica PowerCenter 7.x, ETL, Oracle 10g, SQL Server2005, MS Access, SQL, PL/SQL, Windows XP.