PROFESSIONAL SUMMARY:

• 9+ Years exposure in all phases of SDLC including Requirement Gathering, Design, Development, Testing, Debugging.
• Professional experience in Data Warehousing with progressive knowledge in Informatica for implementing large - scale applications with loading data warehousing technologies.
• Extensively worked on Informatica Power Center tool to build Data warehouses.
• Worked on complex transformations like Upgrade Strategy, Aggregations, Lookup, Connected and Unconnected transformations, Stored Procedure Transformations.
• Ability to design and develop complex mappings like SCD Type I and II
• Proficient in the integration of various data sources such as Oracle11g/10g/9i, SQL Server 2000/2005/2008 , Flat Files to ODS and Data warehouse.
• Excellent knowledge in working with SQL Server 2008, Oracle 11g/10g
• Proficient in troubleshooting, problem solving, testing & Debugging errors using Informatica Debugger
• Tuning the Performance and identifying bottlenecks at Sources, Targets, Mappings and Sessions levels for better efficiency.
• Closely worked with business SMEs on developing the business rules for cleansing and performed data profiling & various data quality rules development using Informatica Data Quality.
• Interacted with end users to resolve Informatica Power Center issues and coordinated with Informatica support for patches and bug fixes.
• Identified and fixed errors before deployment, and migrated mappings and workflows from development to testing, testing to QA and QA to production
• Extensively used AutoSys, Active batch and Control-M for scheduling workflows.
• Excellent analytical, problem solving skills and a motivated team player with good inter-personal skills
• Proven ability to quickly learn and apply new technologies and have creativity, innovation, and ability to work in a paced environment.
• Highly result-oriented and driven for success and have the ability to identify explicit business requirements
• Flexible and versatile to adapt to any new environment and work on any project with good communication and documentation skills

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, IDQ, Informatica Power Exchange 8.1, PowerMart 6.2/5.1/5.0.

Data Modeling Tools: Erwin & Microsoft Visio

Database: Oracle 11g/10g/9i,Teradata V2R6/V2R5,IBM DB2 UDB 8.0/7.0, SQL Server 2008/ 2005/2000 & MS Access

Database Tools: Toad, SQL * Plus, WinSQL, SQL Developer

Scheduling tools: Autosys, Active batch, Control: M

Operating systems: MS Windows 98/ NT/2000/XP/7, UNIX (Sun Solaris 8.0), LINUX

Programming Languages: UNIX, SQL, PL/SQL, VB, C, C++ & Java, XML, Infogix Assure

WORK EXPERIENCE:

Confidential, Madison, WI

Sr. Data warehouse Developer/Tech Lead

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from various source systems.
• Analyzed the existing business rules and understood the client’s new reporting requirements by interacting with the users in the LOB (Line of Business).
• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Laid hands on translating logical models to Physical models with the support of the data architect and data modeler using ERWIN.
• Extensively used Informatica PowerCenter to develop several Informatica mappings for Extraction/Transformation, data cleansing and loading of data into staging areas and data marts.
• Exclusively developed PLSQL procedure to handle numerous requirements and strong working experience in handling SCD’s (Slowly Changing Dimensions).
• Implemented Change Data Capture (CDC) using dynamic lookup in several mappings.
• Involved in Performance Tuning which included creating indexes and modifying tables, collecting stats with the help of the explain plan utility.
• Worked on setting up the batch control process (generating parameter files dynamically with real time financial timestamps).
• Developed standard and re-usable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, Connected/Unconnected Lookup, and filter.
• Created various tasks, arranged related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Identified and eliminated duplicates in datasets through IDQ components of Edit Distance, Mixed Field matcher, it enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Used various cleanse functions to performs operations on the data.
• Worked on data profiling & various data quality rules development using Informatica Data Quality.
• Performed DATA PROFILING for two or more data objects through Join analysis.
• Used pmcmd commands to communicate with the Informatica server.
• Worked with AUTOSYS team to schedule the jobs and manually trigger them if any job abends and misses the look back time.
• Used debugger in Informatica Designer to resolve the issues regarding data and reduced project delay.
• Established Pipeline Partitioning to improve performance.
• Writing PL/SQL and T-SQL statements, queries, stored procedures and triggers for MS-SQL Server, Oracle databases.
• Worked as System Analyst and as a LEAD to offsite team and coordinated with onsite management and supported as a primary point of contact.
• Closely worked with the production support team to recover from issues and various defects that encounter while running the jobs. Always been a primary call on support to handle the unexpected failures that occurred at run time.

Environment: Informatica PowerCenter 9.1.0/8.6.1 , Oracle 11g/10g, SQL Server, Informatica Data Quality (IDQ 8.6.1), Informatica Data Director (IDD),WINSQL,SQL Developer, PL/SQL,T-SQL,DB2, UNIX, ERWIN, AutoSys, Infogix Assure

Confidential, WI

Sr. Data warehouse Developer/Tech Lead

Responsibilities:

• Designed various mappings for extracting data from various sources involving flat files, XML files and relational tables.
• Created different transformations for loading the data into Sql Server .e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.
• Used Parameter files to define values for parameters and variables used in the mappings and sessions
• Created and Monitored Informatica sessions using Active Batch.
• Analyzed and communicatedETLdevelopment issues, including problems with data integrity, data design, and functional and technical issues.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Performed data analysis and write SOP documents which clearly specify the purpose and transformation logic of each mapping, following applicable standards and conventions.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Ensured the data quality through partnering with the data steward in identification of Key Performance Indicators (KPI’s).
• Worked on Informatica MDM where data Cleansing, De-duping and Address correction were performed.
• Identify/understand detailed business requirements, developing specifications for data sources, and providing subject matter expertise.
• Hands on experience in Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server & Data Modeling.
• Developed an ETL framework to ftp files from different server/shared drives to land on Informatica server.
• Involved in performance tuning of the mappings such as implementing partitioning techniques
• Involved in documentation of Test cases and reviewing.
• Made use of post-session success and post-session failure commands in the session task to execute scripts needed for cleanup and update purposes.
• Identify/understand detailed business requirements, developing specifications for data sources, and providing subject matter expertise.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections

Environment: Informatica Power Center 9.1/8.6, MS Sql Server 2008, IDQ, Active Batch, Windows XP

Confidential, Philadelphia, PA

Sr. Data warehouse Developer

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from various source systems.
• Extensively used Informatica PowerCenter to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Used ERwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Developed technical design specifications to load the data into the data mart tables confirming to the business rules.
• Worked with Repository Manager for managing of repositories, creation of users, creation of user groups and folders.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed Informatica SCD Type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed mapplets and worklets for reusability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Implemented partitioning and bulk loads for loading large volumes of data.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process.
• Created UNIX Shell scripts and called as pre session and post session commands.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Involved in scheduling the workflows through AutoSys using UNIX scripts.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica PowerCenter 8.6.1/8.1.1 , Oracle 11g/10g, Flat Files, TOAD for Oracle, PL/SQL, ERwin, Windows XP, UNIX PERL scripting, AutoSys.

Confidential, Cleveland, OH

Informatica Developer

Responsibilities:

• Worked closely with business stakeholders and technical team members to gather and analyze application requirements.
• Used Informatica PowerCenter for data extraction, transformation and loading data from heterogeneous sources.
• Developed mappings, workflows to extract data from multiple sources like Oracle 11g/10g, AS/400, DB2 and Flat files and loaded into target Teradata.
• Extensively used ERwin for data modeling and Dimensional Data Modeling
• Created and managed repositories and users.
• Responsible for providing first level operational support for development and production database systems.
• Providedwritten status reports to management regarding project status, task, and issues/risks
• Developed complexInformaticamappings using different types of transformations like Connected and Unconnected, LOOKUP, Java, XML, Aggregator, Expression, Union and Update strategy transformations forLarge volumes of Data and also involved in constraint based loading, target load order.
• Worked on creating entity relational & dimensional relational data models using Kimball Methodology.
• Worked on Teradata BTEQ scripts to extract data and Teradata SQL Assistant to interface with the Teradata.
• Worked on reusable-transformations and used them in Start-to-end data flow mappings.
• Tested and troubleshot mappings and workflows.
• Involved in creating Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor.
• DefinedMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues.
• Database query Performance and Tuning expertise for better performance.
• UsedVersion controlprovided byInformaticaon each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
• Using of SQL tools likeTOAD to runSQL queriesto validate the data.
• Responsible forUnittesting of theInformaticaMappings created according to the business requirements.
• DevelopedUnix Scriptsfor updating the control table.
• Used Control M to schedule UNIX shell scripts, PL/SQL scripts and Informatica jobs.

Environment: Informatica PowerCenter 8.1.1, Oracle 11g/10g,DB2,AS/400, Flat files, Teradata V2R6/V2R5, TOAD, Control M, Visio,PL/SQL,SQL,UNIX, Unix Shell Scripting,Windows XP.

Confidential, Chicago

ETL Informatica Developer

Responsibilities:

• Designed ETL process using Informatica Tool 8.5 to load from Sources like Oracle 10/11g and Flat files to Targets through data Transformations
• Designed and developed various Mappings using Active & Passive Transformations.
• Implemented Slowly Changing Dimensions Type 2 to update the dimensional schema
• Used various Transformations like Expression, Filter, Joiner and Lookups for better Data messaging, migrate clean and consistent Data.
• Created workflows, worklets, tasks and reusable tasks to load the data into target systems.
• Used Debugger for debugging Mappings
• Extensively worked on various Lookup caches like Static, Dynamic, Persistent and shared caches.
• Designed and configured sessions with effective caching and logging
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Resolved session locking issues using Informatica repository manager.
• Fixed problems related to repository, reader process and external procedure.
• Used SQL Tools like TOAD to run SQL queries to validate the data.
• Implemented performance tuning of the process at mapping level, session level, and source and target level.
• Worked on session logs, Informatica debugger and Performance logs for error handling for workflow and session failures.
• Monitored workflows and collected performance data to maximize the session performance.
• Tested by using Informatica workflow manager and monitor etc and extensive testing on log files to detect errors.
• Developed Unix scripts for updating control tables.

Environment: Informatica PowerCenter 8.1, Oracle 10g/9i, Flat files, PL/SQL, Quest Toad

Confidential, CA

Informatica Developer

Responsibilities:

• Involved in analysis of business requirements and keeping track of data available from various system houses and loaded into Target Tables using Informatica Tool 8.1.
• Prepared documentation for ETL strategies, source versus destination system mappings. Involved in building and supporting the extraction flows.
• Identification and documentation of various data sources including the detailed Table/File/Field level mappings between the source and target systems.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
• Experience in backup and restoring of Repository.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, and Update Strategy.
• Created many reusable queries and used them in many mappings.
• Extracted data using Power Center and loaded into Oracle tables. Scheduled sessions and batches. Used “pmcmd” command to execute sessions.
• Used parameter files to pass variable values.
• Involved in the implementation of Performance Tuning for better performance.
• Corrected rejected data and loaded into targets using Reject Loader utility.
• Created the reports (Master/Detail, Cross tab, Chart templates) in Business objects
• Used Informatica Scheduler to schedule all the workflows.

Environment: Oracle 9i, Informatica PowerCenter 7.1,PL/SQL, TOAD, Windows NT, Unix

Confidential

Informatica Developer

Responsibilities:

• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Defined Target Load Order Plan for loading data into Target Tables.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Used shell scripts for post session operations.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created new mappings and mapplets and also tuned them for better performance.
• Involved in checking and comparing data between Source files and database.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively worked in the performance tuning on Informatica mappings
• Prepared Unit and Integration test cases and tested as per requirements

Environment: Informatica PowerCenter 7.1, Oracle 9i, UNIX, Flat Files, Toad, Putty

Confidential

Oracle/Software Developer

Responsibilities:

• Design, Coding using Forms, PL/SQL, and PL/SQL cartridges.
• Wrote triggers and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using forms.
• Involved in building, debugging and running forms.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Designed and developed all the tables, views for the system in Oracle.
• Designing and developing forms validation procedures for query and update of data.
• Review, Testing - Unit testing & integration testing.
• Provided error free codes in short deadlines.

Environment: Oracle 7, SQL*Plus, SQL*Loader, PL/SQL,