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.
• 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 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.
• Experience in import/export of data using Data loader, Informatica cloud connector from legacy CRM database into Salesforce.com.

TECHNICAL SKILLS:

Data Warehouse Tools: Informatica Power Center 9.6/9.5/8.x/7.x

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

Databases: Oracle 11g/10g/9i, MySql, SQL Server 08/05, TeradataReporting Tools: SAP BO, SSRS

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

Reporting Tools: SSRS, SSAS, SAP BO

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

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Plantation, 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.
• Worked with various salesforce.com objects Lead, Account, Contact, Opportunity, Campaign, Cases, Solutions Standard objects and Custom Objects.
• Created Custom objects to build new application functionality in the Salesforce.com.
• Responsible for understanding the data migrating requirements and analyze data to be loaded from legacy systems to Salesforce.com.
• Worked on various Salesforce.com standard objects like Accounts, Contacts.
• Customized page layouts for Opportunity, Contacts, and Accounts depending upon user roles, and groups.
• Responsible for all the activities related to configuring Data Loader, uploading data in CSV files intosalesforce.com, checking for integrity of the data.

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, Lotus Note, Quality Center.

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, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

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 Power Center 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 Power Center 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, Windows XP

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, SQL Server 2008, Oracle SQL 9i, PL/SQL, Erwin, Enterprise Architect,, ER studio, UNIX Shell Scripting, Putty, WinScp.

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 Power Center, Power Exchange, Windows, IBM DB2 8.x, Mainframes, SQL Server 2007, Enterprise Architect, ER studio, O racle, SQL Plus, PL/SQL, Windows 2007