SUMMARY

• Over 6 years of Information Technology experience as an Informatica Developer in Data warehousing and Business Intelligence with emphasis on Data analysis, Application Design, Development, Implementation, Testing, Maintenance, and Documentation.
• Expert level Data Integration skills using Informatica Power Center to design, develop, implement, and optimize ETL workflows and transformations to move data from multiple sources including flat files, RDBMS tables into Operational Data Store (ODS), Data Warehouse and Data Marts.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy, SCD’s Type1 and Type 2.
• Main area of experience includes oracle, Informatica, UNIX and strong knowledge of Data warehousing concepts.
• Experience in all phases of Data warehouse development from requirements gathering for Data warehouse to develop the code, Unit Testing and Documenting.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mapping and sessions.
• Excellent experience coding PL/SQL packages, functions, procedures, triggers, views, bulk loading using collections, SQLLDR, partitioning tables.
• Good experience tuning SQL Queries.
• Worked extensively with Dimensional modeling, Star Schema, and Snowflake modeling, Physical and Logical data modeling using Erwin, Data migration, Data cleansing, Data masking, ETL Processes features for data warehouses.
• Extensive work experience with Database programming in Oracle 11g/10g using PL/SQL.
• Experience in writing UNIX shell scripts
• Experience in working with Data Vault.
• Effective working relations with client team to understand support requirements, and effectively manage client expectations.
• Proficient at Software Programming and Data Warehousing.
• Proven communication skills, both written and oral.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.6.1, 9.1, 8.x., Informatica Developer.

Dimensional Modeling: Erwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Physical and Logical Modeling, Oracle Designer 9i/6i.

Databases: Oracle 11i/10g/9i, MS SQL Server 2008/2005, Teradata, MS Access

Programming /GUI: SQL, PL/SQL, T/SQL, C, C#, UNIX Shell Scripting.

Operating Systems: UNIX, Sun Solaris 8, Windows 98/NT/XP/2000/2003, IBM AIX.

Tools: TOAD, Visio, SQL*Loader, Rapid SQL, Oracle SQL Developer, SQL Navigator, and Autosys.

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

• Worked closely with the business team in gathering requirements.
• Developed ETL mappings to extract data from source system to the ODS (Operational Data Store) and the Data Warehouse.
• Implemented SCD Type 1 and Type 2 dimensions.
• Identified repeatable logic within ETL processes and created mapplets so that they can be used instead of creating redundant code.
• Extensively used Expression, Joiner, Lookup, Aggregator, Update strategy, filter Transformations etc. in various mappings.
• Optimized SQL queries by analyzing the query plan generated by Explain Plan
• Optimized ETL mappings using Informatica best practices for performance tuning
• Used Informatica Repository Manager for deployments.
• Developed UNIX shell Scripts to Unzip the source data files, Execute an Oracle PL/SQL Package Procedure, Move the source data files to an archive directory, Send an Email Notification regarding the Job’s status
• Coded several SQL queries, functions and procedures incorporating complex business rules and functionalities
• Implemented PL/SQL bulk operations to load high volume data into the Data Warehouse Table.
• Participated in team code reviews and provided feedback.
• Involved in production support.
• Target database build in oracle database.
• Co-ordinated with the Testing and Deployment teams for deployment across various environments.
• Validated production deployments when required based on team schedule.
• Created a PL/SQL tool for dropping and recreating indexes on target tables while data refresh.
• Worked on production issues related to ETL processes and data, identified root cause, and resolved issues.

Environment: Informatica Power Center 10.1, Oracle 11g, Teradata, SQL Loader, SQL, PL/SQL, SQL Developer, Clear Case/ClearQuest, Erwin Data modeler 9.5, IBM AIX 6.1.

Confidential, Palm Beach, FL

Informatica & PL/SQL Developer

Responsibilities:

• Implemented slowly changing dimensions type 1 and type 2 .
• Extensively worked with various transformations like Sorter, Aggregator, Router, Joiner and Lookup transformations .
• Created Oracle SQL, Stored Procedures, Triggers, Packages and sequences in the Data Warehouse database .
• Wrote shell scripts to load the data coming from data files.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Implemented PL/SQL bulk operations to load high volume data into the Data Warehouse Table.
• Created Oracle External Tables and used it to load fixed width and delimited data from ASCII f iles.
• Created a PL/SQL tool for dropping and recreating indexes on target tables while data refresh.
• Have written several PL/SQL code snippets to insert, update or delete selective data from tables of very large sizes, containing 50 million records or more.
• Worked on creating and maintaining Partitioned tables and scripting PL/SQL package to load data into partitioned tables.
• Developed scripts to create the DDLs and migrate data from one schema to another, ensuring data integrity and accuracy.
• Needed to maintain Version Control of the code by Check-in and Check-out of ClearCase, baseline the code and link it to ClearQuest and Remedy.
• Performed error handling of sessions using session logs .
• Involved in data quality checks, resolving data issues, and ensuring timely updates.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL/PLSQL, TOAD, Teradata, Clear Case/Clear Quest, Remedy, UNIX Shell Scripting

Confidential

ETL Developer

Responsibilities:

• Analyzed the source data coming from various databases and files and working with business users and developers to develop the data Model.
• Worked with Data modeler in developing STAR Schemas and Snowflake schemas.
• Prepared the source to target mapping specification documents ie., source tables to Staging, Staging to Data Warehouse or Data Mart.
• Developed a number of Informatica Mappings, Mapplets, and reusable Transformations to load data from relational and flat file sources into the data mart.
• Performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
• Pro-actively monitoring production logs, troubleshoot, perform sanctity checks on data, find and resolve data issues and performance issues.
• Have written a number of Shell Scripts to provide server-to-server automation. Shell Scripts to invoke/schedule ETL processes,
• Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets, and Workflows.
• Have worked on Datavault for database modeling.

Environment: Informatica Power Center 9.1, Oracle 10i, SQL/PLSQL, TOAD, UNIX Shell Programming, UNIX server, and Windows NT, TOAD.

Confidential

ETL Developer

Responsibilities:

• Develop slowly changing dimensions (SCD).
• Redesigned the existing ETL processes, suggesting suitable improvements, making ER-model changes and designing the star schemas for the container shipments.
• Developed mappings using Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure and Joiner Transformations.
• Experience in creating parameter files and using mapping parameters in mappings.
• Configured and execute the Debugger within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Worked with pmcmd command line program.
• Involved in pre and post session migration planning for optimizing data load performance.
• Performed SQL tuning by creating appropriate indexes, redesigning SQL and using explain plan.
• Scheduled the workflows at a specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.

Environment: Informatica Power Center 9.1, Oracle 8i/9i, Business Objects 6.1, Erwin, SQL Server2000, UNIX (Solaris).