SUMMARY

• 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica PowerCenter and OBIEE.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Extensively worked on Relational and Dimensional Data modeling (Star / Snowflake models), FACT & Dimensions tables, Physical & logical data modeling, Ralph Kimball Methodologies, Slowly changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in implementing the complex business rules by creating transformations, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup’s, Router, Rank, Joiner, Update Strategy etc) and developing complex Mapplets and Mappings.
• Experience on handling slowly changing dimensions to maintain complete history.
• Experience in Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Perform review of Session log files to trace causes of bottlenecks.
• Extensively worked with Informatica performance tuning involving source level, target level and mapping level bottlenecks.
• Actively involved in Performance SQL Tuning, ETL tuning and Error handling.
• Experience in Developing mapping design documents for ETL process.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Strong experience with Oracle, PL/SQL, Stored Procedures, Packages and Triggers.
• Experience using SQL* loader to load data from flat files to the database tables in Oracle.
• Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Experience with various domain areas such as Retail, Insurance & Banking.
• Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews.
• Created Drill down Hierarchies and implemented Business Logics and Facts.
• Implemented Siebel Analytics security Confidential the data and object levels.
• Developed reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).
• Designed Dashboards with links to websites, documents and embedded contents.
• Worked on ProductionsupportL1 and L2, Onsite-offshore model and on call support.
• Experience on job scheduling on multiple platforms, experience with UNIX command line and LINUX.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.5/9.1/8.6.1, OBIEE 11g/10g

Databases: Oracle 11g/10g/9i

Scheduling Tools: TWS (Tivoli workflow scheduler), Autosys, Crontab.

Programming Skills: Oracle SQL, PL/SQL

Scripting Languages: Unix, Shell Scripting

SQL Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD

Operating Systems: Windows XP/NT/2000/2003, AIX, Unix, Linux and Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr ETL Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, Look up, expression, aggregator, joiner, filter, rank and router transformations etc.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Responsible for Performance Tuning Confidential the Mapping Level and Session level.
• Extensively worked with both Connected and Unconnected Lookup Transformations with various lookup caches like Static Cache, Dynamic.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Used UNIX to create Parameter files and for real time applications.
• Monitoring workflows in workflow monitor and providing batch support and fixing failures.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Created and maintained Users, Groups, Roles and Privileges.
• Repository Service Backup, Recovery and Migration between Dev, UAT and Prod environments.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

Environment: Informatica Power Center 9.1.0/9.5, Oracle 11g/10g, SQL,PL/SQL, Toad, Putty, UNIX, Shell scripting, AIX, Crontab, AR client (capacity planning), Erwin.

Confidential, Jersey City, NJ

ETL Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents - BRD, explained business requirements in terms of technology to the developers.
• Developed ETL Mappings and Test plans.
• The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plans to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed Complex Informatica Mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Created UNIX Script for ETL jobs, session log cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor and Scheduler alert editor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.

Environment: InformaticaPowerCenter9.5/9.1, Oracle11g, Oracle Exadata, MS SQL Server 2008 R2, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Shell Scripting, AIX, Putty, OBIEE 11g.

Confidential

ETL Developer

Responsibilities:

• Used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions.
• Experience in Performance tuning and Optimization of Cache with Informatica and OBIEE.
• Experience in Development and maintenance of Informatica Repository and OBIEE repository.
• Worked on different transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence Generator, Rank, Union, Joiner, Source Qualifier etc.
• Developed number of Informatica Mappings, Mapplets and Reusable Transformations for loading of data.
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions.
• Designed and developed the OBIEE Repository(.rpd) using OBIEE Admin tool by importing the required database objects both facts and dimensions with integrity constraints into physical layer using connection pool.
• Created business facts, dimensions and defined logical relation between them Confidential the business model and mapping layer.
• Worked on Initialization blocks and variables development to achieve security.
• According to the Dashboard Mockup, identifying the required measures and attributes and sending the required dimensions and measures to the business team.
• Created OBIEE reports, filters and prompts and developing new dashboards according to the mockup.
• Created Catalog Groups and users and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Involved in testing of the reports.
• Checking the OBIEE incident tickets in remedy tool and troubleshoot issues based on severity of the issue.
• Handling the change requests.

Environment: Informatica PowerCenter 8.5, Oracle10g, PLSQL, OBIEE 10g,Unix, Shell Scripting, Toad, Putty, Remedy, Control-M, Erwin, Winscp, AIX, PLSQL Developer.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse .
• Used Informatica Designer Tool to develop mappings for Extracting, Transforming and Loading required data into data ware house.
• Extracting data from heterogeneous sources and loading into the staging table.
• Designed mappings using SCD I, SCD II techniques.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Joiner, Router, Sorter etc.
• Preparation of mapping specification documents for Informatica mapping.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Checked and tuned the performance of Informatica Mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing of Informatica mappings.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.

Environment: Informatica Power Center 8. 1, Oracle10g, PLSQL, Toad, Putty, UNIX,Shell scripting.

Confidential

ETL Informatica Developer

Responsibilities:

• Used Informatica Designer Tool to develop mappings for Extract, Transform and Load required data into data Mart.
• Extensively used ETL to load data from Flat Files, Oracle.
• Preparation of Mapping specification documents for Informatica mapping.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner etc.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Checked and tuned the performance of Informatica Mappings.
• Involved in the performance tuning of Database and Informatica mappings and stored procedures and the SQL queries inside the source qualifier.
• Involved in Unit Testing of mappings.
• Involved in Requirement Gathering and Business Analysis
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Created, launched & scheduled sessions.

Environment: Informatica Power Center 8. 1, Oracle10g, PLSQL, Toad, Putty, UNIX, Shell scripting, Autosys

Confidential

Application Programmer

Responsibilities:

• Involved in L1, L2 support for Oracle Applications.
• Involved in supporting and maintaining Unix shell script jobs
• Involved in Mailbox, Unix Batch Jobs and Remedy Incident Tool monitoring and trouble shooting.
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis
• Verify batch results in Autosys, log files.
• Record batch results as per standard procedures.
• Create remedy tickets in case of batch failures and assign to incident managers for resolution
• Have gained knowledge in the application
• Year End Activities - special processing such as Calendar updates, etc.
• Monthly manual run of customer statements to be sent out by mail
• Provide data fixes for known incidents (for online and batch)
• Provide clarifications to users on training issues for known issues

Environment: Informatica Power Center, Oracle 9i, PLSQL, Toad, Putty, Remedy, UNIX, Shell scripting, Autosys.