PROFESSIONAL SUMMARY:

• Around 8 years of total IT Experience in analysis, design, development, implementationand troubleshooting in the area of ETL Tool Informatica.
• More than 5 years of experience in Data Warehousing Methodologies using Kimball and Immon to solve the business problems and 4 years in INFORMATICA DATA QUALITY (IDQ) and INFORMATICA DATA EXPLORER.
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Proficient in writing complex PL/SQL Packages, Stored Procedures, Triggers, Performance tuning, Application tuning and Query Optimization using Hints, Explain plan.
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Extensive experience in handling ETL using Informatica Power Center/Power Mart 8.X/7.x/6.x/5.x.
• Strong design and development experience in ETL tools/ processes using Informatica client tools like Designer, Server Manager, Workflow Manager, Workflow Monitor, and Repository Manager.
• Expertise in database concepts such as conceptual, logical and physical data modeling, and data definition, population and manipulation using RDBMS Databases not limited to Oracle 11g/10g/9i, IBM DB2 UDB 8.0, MS SQL Server 2000/2005/2008, Netezza, Sybase, Teradata, etc.
• Have good understanding of ETL/INFORMATICA standards and best practices, Confirmed Dimensions, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).
• Expertise in XML File Transformations and worked with in the Continuous Integration Framework.
• Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.
• Pertinent experience using heterogeneous databases such as Oracle 8i/9i/10g/11g, DB2/UDB, MS SQL Server 2005 (SSIS), Mainframes (vsam/Cobol files) DB2, XML, COBOL files and various Flat Files (Structured/Unstructured) systems for integration into Enterprise/Business Analysis DWH.
• In - depth knowledge and understanding of dimensional modeling (Star schema and Snowflake schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level with implementation of all transformations like sorter, Expression, Router, Joiner, Look up and stored procedures.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow. And strong knowledge on Data quality and Data Analysis.
• Strong knowledge in optimizing database performance
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures.

TECHNICAL SKILLS:

DATA WAREHOUSING: Informatica Power Center 9.x/8.x/7.x/6.x/5.x

DATABASES: Oracle, DB2, Sybase, Teradata, MS SQL.

TOOLS: SQL Plus, TOAD, PL/SQL

Web and Languages: HTML, XML and UNIX, MS-Office

Operating systems: Windows, Solaris.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Extensively worked on data extraction, Transformation and loading data from various sources like Teradata, SQL Server and Flat files
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes .
• Analyzing Source to Target mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Extract data from Teradata in to Informatica Power Center 9.5.1 version and develop the code using different transformations and Loading to Landing area Teradata.
• Parameterized the mappings and increased the re-usability.
• Created mappings using different transformations joiner, normalizer, expression,sorter, Aggregator, Filter, Router, lookup, update strategy.
• Migrate the data to QA Environment.
• Worked on both DEV and QA Environment.
• Create structures for new Work Lets in Power Center application.
• Created and Monitored workflows using Workflow manager and Workflow monitor.
• Develop reusable modules to transform data into a generic output.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Design and develop solutions for new strategic initiative
• Assist other developers and other groups in identifying and correcting issues with data and/or programming
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.6.1, Data Quality 9.5, Teradata, SQL Server 2008, DB2, SQL Loader, Flat Files, Unix.

Confidential, SFO

Informatica Data Quality Developer

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Extensively worked on Informatica IDE/IDQ.
• Analyzing Source to Target mapping Excel document.
• Coordinating the off-shore team and assigning dependencies tasks to team.
• Extract data from input files in Power Center and load to staging area.
• Extract data from source system(Raw Staging SQL Server) in DQ9.5 version and connect to output using different rules and export it to Informatica Power Center9.6.1 and Loading to Landing area(MDM HUB).
• Created Data Flow Mappings in DQ tool using business mapping sheet.
• Running MDM jobs till base objects whenever data needed and look at the issues, rejects in raw-staging to landing flow in DEV.
• Migrate the data to QA Environment.
• Worked on both DEV and QA Environment..
• Worked on Standardizer,Expression,Rank, Token Parser, Java, Input, OutputJoiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier.
• Implemented slowly changing dimensions - Type I, II &III in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.
• Tested different data load databases by comparing source and target table counts and tested Informatica data loads from database to database.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Interaction with the offshore team on a daily basis on the development activities.

Environment: Informatica Power Center 9.6.1, Data Quality 9.5, Oracle, SQL Server 2008, DB2, SQL Loader, MDM Hub, Flat Files, Unix.

Confidential, Virginia

Informatica Developer with IDQ

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Extensively worked on Informatica IDE/IDQ.
• Analyzing Source to Target mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analyzed the AR data and developed the code to extract the data for the AR module and implemented in the informatica.
• Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Worked on various tasks like Session, E-Mail task and Command task.
• Used mapplets, parameters and variables in mappings as per the requirement.
• Used Informatica Data Quality (IDQ) for data quality, integration.
• Worked on IDQ Admin Tasks and worked as both Admin and Developer.
• Involved in cleaning the data using IDQ in Informatica Data Quality environment 9.1 Environment.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Profiled the data using INFORMATICA DATA EXPLORER.
• Our job is to design ETL process, Intermediate schemas and SCD2 for each stage
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Used versioning and shared folders for better control on Informatica jobs among the team and across different projects.
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
• Tested different data load databases by comparing source and target table counts and tested Informatica data loads from database to database.
• Performed DATA MIGRATION enforcement tasks.

Environment: Informatica Power Center 9.5, Oracle, Teradata, Sybase, DB2, SQL Loader,IDQ,IDE.

Confidential, TEXAS

Informatica Developer

Responsibilities:

• Created mappings and session for jobs in Informatica.
• BI tools, MDM, Toad by various environmental sources.
• Designed work lets and workflows for jobs in Informatica.
• Implemented shell scripts to run the jobs in UNIX through Informatica.
• Worked in changing the existing development code according to the new requirement.
• Designed and Implemented data profiling, cleansing, name-address enrichment and matchingmerging solutions using Informatica Data Quality(IDQ).
• Profiled the data using Informatica Data Explorer (IDE) and performed proof of concept for Informatica Data Quality (IDQ) .
• Implemented shell scripts to capture the unique process ids for job which are initiated by informatica.
• Implemented shell scripts to kill the unique process ids for job which are initiated by Informatica.
• Accessed Informatica data director and DT Studio projects created well versed DT Studio scripts which are uploaded in server for usage of modifying existing Informatica schemas usingunstructured data transformation and did governance using Informatica data director tool.
• MDM to support data governance
• Created several Design patterns, Standards documents, ETL strategies explaining all above mentioned processes, used DT Studio Data transformation studio authoring and created scripts.
• Developed complex PL/SQL procedures and packages as part of Transformation and data cleansing
• Developed and used Informatica MDM Components for data governance projects and data integration projects and performed Dimensional modeling extracted reports using Cognos.
• Set up batches and also used Informatica MDM Components like Informatica data director and data.
• Performed unit testing by running Informatica sessions.
• Create structures for new Work Lets in PowerCenter application
• Develop reusable modules to transform data into a generic output
• Design and develop solutions for new strategic initiative
• Assist other developers and other groups in identifying and correcting issues with data and/or programming

Environment: Informatica Power Center 8.6/9.1,Oracle, Flat Files, UNIX, shell scripting, Cognos.

Confidential, Texas

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Worked with Data modeler, according to changes in the model worked on changes in the Informatica.
• Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica power exchange in the source analyzer.
• Imported the Target definitions into Target Designer from oracle and for DB2, VSAM files used Informatica power exchange in the Target Designer.
• Working with Business Analyst, Translating Business requirements into Functional requirements.
• Developed and Tested new mappings.
• Created and configured the sessions for work flow.
• Created and maintained parameter files for workflows in the UNIX and CVS.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier.
• Implemented slowly changing dimensions - Type I, II &III in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.

Environment: Informatica Power Center 8.1/8.5/8.6, Informatica Power Exchange 8.1/8.5/8.6, Oracle 10g, DB2, Flat files, UNIX, shell scripting,SQL Developer, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Worked on the installation and configuration of Informatica PowerCenter 7.1.
• Created and Documented ETL Test Plans, Test Cases, Test scripts, Expected results,Assumptions and Validations.
• Used most of the transformations such as the Source Qualifiers, Routers, Java, SQL,
• Transaction control, Sequence Generators and Expressions as per the Business requirement.
• Extraction, Transformation and Load was performed using Informatica 7.1 to build the data warehouse.
• Monitored and improved the performance of Sessions, Load Manager Properties, Parameter files, Mappings and documented the rectified issues in detail.

Environment: Informatica PowerCenter 7.1, Oracle 8i, MS SQL Server, SQL plus, UNIX, AutoSys, TOAD.