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.
• 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.
• 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, MS SQL.

TOOLS: SQL Plus, TOAD, PL/SQL

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

Operating systems: Windows, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Informatica Developer

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Involved in gathering the business requirements from Business Analyst.
• 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 and profiling.
• 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.

Environment: Informatica Power Center 9.5, Oracle, DB2, SQL Loader

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).
• 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.
• With a team of 10 developers created a test Data Warehouse.

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

Confidential

SQL developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including datafilefor counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: MS SQL Server Management Studio, SQL plus.