SUMMARY:

• 8+ years of total IT experience in Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co - ordination, interpersonal skills
• 6+ years of experience wif Informatica power center (Rep Manager, Power Center Designer, Workflow Manager and Workflow Monitor)
• Strong experience in designing/developing complex mappings from varied transformations like Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Unconnected and Connected lookup etc.
• Proficient wif Data warehousing concepts like Dimensional Data Modeling, Star Schema, SnowFlake schema, OLTP and OLAP, dimensions and facts
• Good experience in extracting data from multiple source systems like Oracle, Sql Server, DB2, Flat Files and loading them wif business transformation logic to datamarts/data warehouse
• Experience in creating mappings wif SQL override in Source Qualifier, Indirect loading of multiple Flat files into same target
• Experience in using Informatica Scheduler for scheduling jobs
• Experience in documenting Low level Design, Unit test plan, Unit test cases and worked wif other developers in preparing the High Level Design document, Deployment documents.
• Ability to create complex mappings for SCD’s (SCD1, SCD2) and complex workflows depending on business requirements
• Proficient in using SAS Enterprise Guide and Enterprise Miner

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.5.1/9.1.0/8.x (8.6.1/8.6.0/8.5.1/8.1.0)

Databases: Oracle 11g/10g/9i/8i/7.x, Teradata, DB2, SQL Server 2005/2008/2008R2

Business Intelligence Tools: Business Objects, Cognos

Scheduling tools: InformaticaSchedular, Autosys

Sql Tools: TOAD, Sql Developer, SqlPlus

Operating Systems: Windows 7/Vista/XP/2003 Server/2008/R2 Server/Unix/Linux

Programming Languages: C, C++, HTML, PL/ SQL, UNIX Shell Scripting

PROFESSIONAL SUMMARY:

Sr. ETL Developer

Confidential, CT

Responsibilities

• Worked wif business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data
• Designed the ETL processes using Informatica to load data from Oracle and Flat Files to target Oracle Data Warehouse
• Involved in creating new table structures and modifying existing tables to fit into the existing Data Model
• Performed data manipulations using various Informatica Transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Connected and Unconnected Lookup
• WrittenSQL overrides in Source Qualifier to push load onto the database for which the source database is same (Coming from same database)
• Created mappings to load multiple Flat files using Indirect loading
• Created sessions and workflow for designed mappings
• Created session link constraints in the workflow based on the business requirements
• Redesigned some of the existing mappings in the system to meet new functionality
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time wif required frequency
• Extensively worked in the performance tuning of the programs, ETL Procedures and applied PDO (Push Down Optimization where ever necessary)
• Created unit test documents to validate the data while development in progress and also to ensure the business requirements are met
• Used Informatica Scheduler to schedule jobs
• Involved in managing and updating the metadata components present in the shared folder

Environment: Informatica9.5.1/9.1.0 ORACLE 11g, Oracle Exadata, UNIX

Informatica/DW Consultant

Confidential, Morris Plains, NJ

Responsibilities

• Correlate the business to technical aspect and involved in the development of high level design document to create the informaticamappings.
• Creation of Informatica Workflows, sessions and Run dat Sessions to load into Target and Debugging, Unit Testing of Mappings
• Integrating the Work Flows to the Autosys jobs to schedule the run of the mappings
• UsedInformatica Designer to create mappingsusing different transformations to move data to a Data Warehouse. Developedcomplex mappingsin Informatica to load the data from various sources into the Data Warehouse, using different transformationslike Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Good understanding about the data ware house concepts
• Involved in creating new table structures and modifying existing tables to fit into the existing Data Model
• Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions, and Target Data
• Prepared SQL Queries to validate the data in both source and target databases
• Maintained metadata, naming standards and warehouse standards for future application development
• Worked on preparing documents for migration of developed objects to from Dev to QA environment
• Perform User Acceptance testing and ensure dat all issues are resolved and an official sign off is obtained from the users regarding the same
• Involved in writing test plan, Unit, System integration, user testing and Implementation of the System
• Assisted in noledge transfer regarding the developed components in Informatica to the QA team and worked wif them to resolve any issues

Environment:Informatica Power Center 8.x, Flat files, Oracle 9i, UNIX

Data Warehouse Developer

Confidential

Responsibilities

• Managed and updated the Metadata associated wif the ETL processes used to populate the data warehouse
• Worked under direct supervision to identify the source tables dat contain the necessary data
• Worked wif the Lead developer on optimizing mappings for better performance and efficiency
• Involved in understanding business requirements for development of data marts in SQL Server
• Documented required technical metadata such as source and target definitions
• Create unit test cases to ensure the data integrity, data correctness and the record count of the data migrated
• Involved in checking the target tables for datatype mismatches and correcting them where necessary
• Assist the QA team to perform the testing of the migrated data

Environment: Informatica Power Center 8.x, Flat files, Oracle 9i, UNIX

Informatica Developer

Confidential

Responsibilities

• Worked wif other users in understanding business requirements for development of data marts in Oracle
• Managed the Metadata associated wif the ETL processes used to populate the data warehouse
• Identify the tables for migration required for providing the data for the new database
• Optimizing mappings for better performance and efficiency
• Created source and target definitions in the shared folder
• Create test cases to ensure the Data integrity, data correctness and the record count of the data migrated
• Checked the output according to the specification by writing various SQL queries

Environment: Informatica Power Center 8.x, Oracle, UNIX