PROFESSIONAL SUMMARY:

• 7+ years IT experience in Data Warehouse applications using Informatica power center tool 9.6/9..5/8.6/7.5, Oracle, DB2, Teradata, MS SQL server on Windows, IBM and UNIX platforms.
• Excellent understanding of ETL(Extract, Transform and Load) design principles and practical knowledge of performing ETL design processes through Informatica Power Center Tool.
• Excellent understanding of Business Intelligence and Data Warehousing Concepts mainly emphasis on ETL and SDLC (Software Development Lifecycle) methodologies like Waterfall and Agile methodology which includes requirement gathering, designing, implementing and testing.
• Solid understanding of ETL design process and principle, development and maintenance using Oracle SQL, PL/SQL, Informatica Power Center.
• Extensively worked in Repository configuration using transformation, creating Mapping, Mapplets, Workflow, Sessions, Worklets, and processing tasks using Designer/ Workflow Manager to move the data from multiple Source system to Targets.
• Solid understanding of Data Warehousing concepts and Dimensional modeling (Star schema and Snowflake schema) and Relational Data Modeling and Slowly Changing Dimensions.
• Expertise in creating Unix shell scripts like file validations, file downloads, workflow executions
• Excellent understanding of OLAP (Online Analytical Processing) concepts and challenges, with large data sets.
• Participated and understanding business requirements, discuss with Business Analyst to gathering and analyzing the requirements and to prepare business rules.
• Experience in writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.
• Good underrating of BI tools (Business Intelligence) tools such as Cognos, and Micro strategy, SSRS and SSAS.
• Good understating in Relational and Dimensional Data Modeling Techniques and existing data model of the Data Warehouse to design ERWIN data models.
• Excellent interpersonal skills, technically proficient, decision making and detailed - oriented with problem solving skills and also ability to work independently.

TECHNICAL SKILLS:

Data Warehouse Tools: Informatica Power Center 9.6/9.5/8.x/7.x, Data Stage, Informatica Power Analyzer/Powermart 9x

Operating System: Windows XP/Vista 08/07, Unix, Linux, IBM Mainframes, Putty, Winscp

Databases: Oacle 11g/10g/9i, MySql, Sql Server 08/05, Teradata, MS Access

Reporting Tools: Cognos, SAP BO, SSRS

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Erwin.

Reporting Tools: SSRS, SSAS, Cognos, SAP BO

Data Base Tools: Oracle SQL Developer, SQL Plus, Toad, MS office, Microsoft Visio

Languages: SQL, PL/SQL, XML, Unix Shell Scripting, Cobol

Dimensional Data Modeling: Dimensional Data Modeling, Star & Snow Flake modeling, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

ETL/Informatica Developer

Responsibilities:

• Interacted with Business Analyst to identify the process and requirements gathering, implementing designs process, development and preparing business rules.
• Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.
• Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment.
• Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.
• Developed Mapping using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and runs of workflows based on changing variable values.
• Implemented Slowly Changing Dimensions (SCD Type 1 & 2) in Mappings.
• Worked on complex mapping for the performance tuning to reduce the total ETL process time.
• Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.
• Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables discussing with Data Modeler.
• Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM’s), Test cases and Code migration report.
• Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica Power Center 9.6.
• Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.
• Checked Sessions and error logs to troubleshoot problems and also used debugger.
• Created Unix Shell Scripts to automate pre-session and post-session processes.
• Created shortcuts for reusable transformation, source/target definitions, mapplets in Shared folder.

Environment: Informatica Power Center 9.6/9.5, Oracle 11g/10g, Power mart, Pl/SQL, Teradata, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), Erwin, Putty, WinScp, Linux, XML, Sharepoint, Quality Center.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Interact with business analysts, Analyzed, inspected and translate business requirements into technical specifications.
• Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.
• Involved Creating Fact and Dimension tables using Star schema.
• Extensively involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Design and developed complex informatica mappings including SCD Type 2 (Slow Changing Dimension Type 2).
• Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Environment: Informatica Power Center 9.5/8.6, SQL server 08, Oracle 10g/9i, Oracle11g/10g, PL/SQL, Cognos, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

Confidential, Washington DC

Informatica Developer

Responsibilities:

• Work closely with project managers, business analysts, DBA’s to achieve business and functional requirements.
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Assisted in the design and Maintenance of the Metadata environment.
• Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations.
• Extensively used Source Qualifier Transformation to filter data at Source level
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Performed unit testing, Integration testing and Functional testing of the mappings.

Environment: Informatica Power Center 8.6/7.1, Oracle Oracle10g, SQL, Teradata, DB2, Oracle 9i, Windows NT, UNIX (AIX 5.2), Flat files (delimited), UNIX Shell Scripting, ERwin, TOAD, Mercury Quality center, Windows XP

Confidential, Newark, DE

Informatica Power Center Developer

Responsibilities:

• Responsible for designing and development, testing of processes necessary to extract data from operational databases, Transform and Load it into data warehouse using Informatica Power center.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Worked Extensively on Informatica tools like Designer, Workflow monitor and Workflow Manager.
• Worked on all the Transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.
• Created connected and unconnected Lookup transformations to look up the data from the source to ETL target tables.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used the update strategy to effectively migrate data from source to target.
• Created test cases and completed unit, integration and system tests for Data warehouse.
• Involved in debugging and validating the mappings and Code Review to rectify the issue.
• Extensively used various Performance tuning Techniques to improve the session performance.
• Developed, implemented and enforced ETL best practices standards.
• Worked on all the Transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.
• Debugging and validating and executing mappings and Involved in Code Review and rectify the error.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• The load ready files are loaded into Teradata Tables using Teradata ODBC/Fastload, Multiload connection. The Load Date and Time are also captured in the teradata table.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Extensively worked on correcting and reloading rejected files.
• Configured and used FTP by the Informatica Server to access source files.

Environment: Informatica (Power Center 8.6/7.1), Power Exchange, Windows, IBM DB2 8.x, Mainframes, COBOL, SQL Server 2008, Oracle SQL 9i, PL/SQL, Erwin, Enterprise Architect, Meta data Manager, ER studio, UNIX Shell Scripting, Putty, WinScp.

Confidential, Los Angeles, CA

Informatica Power Center Developer

Responsibilities:

• Maintaining the data coming from the OLTP systems.
• Developed and maintained complex Informatica mappings.
• Involved in analyzing and development of the Data Warehouse.
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,
• Perform data validation tests using complex SQL statements.
• Worked with data warehouse staff to in corporate best practices from Informatica.
• Worked with Business Analysts, using work sessions, to translating business requirements into technical specifications, including data, process and specifications.
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created database structures, objects and their modification as and when needed.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Testing for Data Integrity and Consistency.

Environment: Informatica Power Center 7.1, Informatica PowerCenter, Power Exchange, Windows, IBM DB2 8.x, Mainframes, SQL Server 2007, Enterprise Architect, Meta data Manager, ER studio, O racle, SQL Plus, PL/SQL, Windows 2007