• Participated in business requirement review meetings with BA’s, Solution Architect and users
• Involved in developing complex Informatica mappings using transformations like, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter,Router, Joiner, SQL Transformation etc
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data
• Developed Informatica mappings for TYPE 1, 2 Slowly Changing Dimensions
• Used Star Schema approach for designing of database for the data warehouse
• Involved in developing mappings to load data from Flat files which includes fixed width files, Delimited files and also the relational database
• Used various Tasks like Control, Assignment, Timer, Event-Wait, Event-Raise, Email as a part of Workflow Logic as per the requirements
• Involved in Configuring sessions for incremental aggregation, pipe-line partitioning etc.
• Created Sessions, Reusable Worklets, Reusable mapplets and workflows in Workflow Manager and Scheduled workflows and sessions
• Worked on the teradata stored procedures and functions to confirm the data and have load it on the table
• Involved in troubleshooting the load failures and Performance tuning by determining bottlenecks in sources, mappings and sessions
• Worked with complex SQL queries to test the data generated by the ETL process against the target database
• Experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata
• Involved in identify the relationship between tables according to the requirements
• Analyzed the transformation logic as per the Source to Target mapping document and source file workbook document to develop Informatica workflow mappings
• Prepared Technical Design, Production Support Doc, Deployment Documents
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations
• Performance tuned and optimized various complex SQL queries
• Worked on data warehouses with sizes from 30-50 Terabytes
• Used TOAD to run SQL queries and validate the data in warehouse
• Involved in Unit testing and providing support to the QA for testing the target data against the source data
• Worked in Agile environment for rapidly changing or highly emergent requirements and following parallel development and testing

Environment: Informatica PowerCenter, Oracle 11g, Windows, Jira, Maestro, Teradata,SQL Server

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets
• Created Design Specification Documents including source to target mappings
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema
• Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files
• Designed and developed complex mappings using various transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more
• Created and scheduled Sessions, Jobs based on on-demand using Workflow Manager
• Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Experienced in designing and integrating the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
• Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues
• Used SQL tools like Teradata SQL Assistant to run SQL queries and validate the data.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse
• Provided 24x7 production support for business users and documented problems and solutions for running the workflows

Environment : Informatica PowerCenter 9.0.1, Teradata, MS SQL Server, Flat Files,UNIX, Windows,

CA workload Automation,SQL Server.

• Involved in requirements gathering and analysis for the entire application
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations
• Used Star Schema approach for designing of database for the data warehouse
• Involved in complete SDLC of the application
• Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, mapplets ,dynamic lookups and reusable transformations in ETL maps
• ETL performance (Data base and ETL jobs) by optimizing back end queries, by implementing techniques like index drop and re-create, table partition, parallelism etc
• Experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata
• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to Teradata RDBMS using BTEQ, MultiLoad and Fast Load
• Performed Database/ETL migrations from Dev environment to Test/Training/UAT/Staging and PROD environments

Environment:Informatica, Power Center, Oracle 9i, PL/SQL Developer,TWS Toad, ER-Studio, UNIX,Autosys,SQL server,Teradata.