SUMMARY

• 10+ years of IT experience in Analysis, Design, Development, Administration and Support of Data Wharehousing and Governance solutions using Informatica, IDQ, Teradata, Oracle, PL/SQL and Unix shell scripting along industry verticals like SCM, Banking, Financial Services.
• Worked with client facing environments for requirements gathering and drafting those requirements into design and estimation templates for effective project deliverables.
• 4+ years of experience in Informatica IDQ
• 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.
• Extensively worked on Customer & Supplier match analysis and Address standardization using IDQ transformations.
• Experienced in developing and maintaining Data Warehouse applications using INFORMATICA Powercenter with optimum design solutions.
• Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation
• Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor and Repository Server Admin Console with strong business understanding in different domains.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
• Excellent understanding of Software Development Life Cycle (SDLC).
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings and sessions.
• Hands on experience in tuning mappings, identifying and resolving performance in various levels like sources, targets, mappings, and sessions.
• Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
• Having knowledge on Data model Design (Conceptual/Logical/Physical) in Data Warehouse solutions using Erwin 9.x/8.x/7.x Data Modeler and SQL Developer Data Modeler 3.x Tools.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 9.x/8.x, IDQ9.6.1.

Databases: Teradata14.0, Oracle (8i/9i/10g)

Teradata tools: SQLAssistant, BTEQ, PMON, Visual Explain, Index Wizard, View point

Load & Export: FastLoad, MultiLoad, FastExport, BTEQ, OLE load, Oracle SQL Loader

Scheduler: Control M8, Crontab

Scripting languages: UNIXShell

OS: MS-DOS, Windows2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

IDQ/Informatica Developer

Responsibilities:

• Using Informatica 9.5.1 PowerCenter Designer and used transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Stored Procedure etc. for extraction, transformation and loading of data
• Installed and configure Informatica IDQ,B2B
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Created and ConfiguredWorkflows, Worklets, and Sessionsto transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created UNIX scripts to call Informatica workflow’s for number of times. Created different jobs usingUNIX shell scriptingto call the workflow by using Command tasks.
• Involved in creation ofFolders,Users, Import and export workflow from one folder to another folder from within or out of RepositoriesandDeployment Groupsusing Repository Manager.
• Used various cleanse functions to performs operations on the data.
• Worked on data profiling & various data quality rules development using Informatica Data Quality.
• Used IDQ for various standardizations and validations like Address, Names, Phone numbers, SSN data to deliver accurae data to end users.
• Hands on experience working on Analyst tool to create Rules, Scorecards, Reference tables and data profiling.
• Creates, validates and updates the data dictionary and analysing documentation to make sure that the information captured is correct
• Writing teradata sql queries to join or any modifications in the table
• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Involved in Enhancement,decommission of Contol M jobs, Adding new jobs in ControlM

Environment: Informatica PowerCenter 9.5.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), IDQ, Control M 8.0 Teradata, SQL Server 2005, SQL, PL/SQL, UNIX.

Confidential, Chicago, IL

IDQ/Informatica Developer

Responsibilities:

• Worked as ETL developer to integrate data ware house of acquired company to provide single-view to the business
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Perform the data profiling and Data quality solutions to the data sets to the business requirements.
• Extremely worked with DQ transformations like Standardizer, Labeler, Parser, Address Validator, Match, Key Generator, Association etc.
• Worked with the DQA for handling exception records by the business team and implemented the Postal address validation for the Supplier data sets.
• Extensively involved in Performance tuning of the mappings and then made performance improvements to the database by building the tables and using bit map indexes and push down optimizations
• Developed Mappings and Sessions based on user requirements and business rules to load data from source tables to target tables based on the design document.
• Developed Mappings and Sessions based on given requirements and business rules to load data from desired sources to targets.
• Developed several mappings using the transformations like Source qualifier, Aggregator,Expression lookup, Router, Filter, Joiner and sorter transformations.
• Extensively used various performance tuning techniques to improve the performance.
• Configured and executed sessions to load data into the target database.
• Created work lets and workflows for historical and incremental loads.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users
• Involved in unit testing and also in internal quality analysis procedures and reviews.

Environment: Informatica Powercenter 9.5 Repository Manager, Designer, IDQ, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), SQL Developer,UNIX

Confidential, Pennington, NJ

Informatica Developer

Responsibilities:

• Gather and analyze information on existing business processes in order to make recommendations that seek to improve business systems and processes.
• To prepare the detailed design document and requirement analysis document for the whole project execution phase by phase or module by module.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle into the Oracle target database
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Work as part of a project team, reporting progress and escalating issues to management as appropriate.
• Extensively worked with incremental loading mappings
• Extensively used rank, Lookup, aggregator, Update and Router Transformations.
• Developed reusable Mapplets / Transformations embedding business logic.
• Developed and run the workflows by using Workflow Manager.
• Resolving if any issues in transformations and mappings with the help of technical specifications

Environment: Informatica PowerCenter 9.1/8.6.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 10g, SQL Server 2005,SQL, PL/SQL, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Involved in analysis, coding and testing of various enhancements Analysis of new business functionality.
• Reusable Components Identification & Development.
• Control Framework Strategy for tracking and reporting purpose, Layer Creations
• Batch Schedule and Test Processes
• Various POC’s for obtaining best optimal solution.
• Created reusable mappings/mapplets, Sessions/command task, workflows/worklets.
• Modified shell scripts based on client requirements
• Created stored procedures for recreating the Table during deadlocks.
• Performance tuning in Informatica and oracle.
• Created parameter files and script for generating parameter files for different environments.
• Created Unix shell scripts.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Tuned the mappings to increase its efficiency and performance. Used Informatica Workflow Manager to create workflows, Workflow Monitor was used to monitor and run workflows

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

Confidential

Jr. Informatica Developer

Responsibilities:

• Analyzed the source data and unloaded source data into flat files
• Executed UNIX scripts to Merge the data and to run sessions and workflows
• Designed and developed mappings in Informatica
• Prepared UTRs for testing
• Helped other team members and POCs in resolving issues
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Managed users & roles for database security, Maintained system security, control and monitor user access to database.

Environment: SQL Server; Tools: Informatica 6.1 (ETL), SQL Query Analyser; O/S: WINDOWS XP, UNIX.