SUMMARY:

• Over 8+ Years of extensive experience on ETL Informatica Power Center with strong business understanding and noledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, Sybase, SQL Server.
• Extensively involved in ETL Data warehousing using Informatica Power Center 8.x/9, IDQ, CDC and Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations and B2B Data Transformation Studio.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Usage of Informatica mapping variables/parameters and session variables where necessary.
• Experience in implementing update strategies, incremental loads.
• Experience in coding using Oracle 10g/9i/8i, SQL Server /08, SQL, PL/SQL procedures / functions, triggers and exceptions. Good experience in Relational Database Concepts, Entity relational Diagrams.
• Experience in working with Teradata Utilities like Bteq, Muti - Load, Fast Load, Fast Export and Tpump through Informatica.
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins.
• Experience in scheduling teh batch jobs using workflow designer, Zena, Cron Tab.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing (SCD) Type1/2/3 dimension mappings using Ralph Kimball methodology
• Experience in Optimizing teh Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions, and Triggers.
• Data Modeler with strong Conceptual and Logical Data Modeling skills, TEMPhas experience for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Developed Batch Jobs using UNIX Shell scripts to automate teh process of loading, pushing and pulling data from different servers. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Zena.
• Expertise in OLAP/OLTP System Study, Analysis and E-R Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.
• Expertise in end to end software development life cycle execution including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter9/8.x/7.x, B2B Data Transformation

RDBMS: Oracle11g/10g/9i, DB2, SQL Server 2000/2005/2008, Teradata

Operating System: Windows NT/2000/XP/7, Unix, Linux

Job Scheduling Tools: Zena, Autosys, Cron Tab, Tivoli

Languages: SQL, PL/SQL, Unix Shell Scripting

Database frontend tools: Oracle PLSQL Developer, Teradata (Including Utilities), SQL Assistant, Oracle TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Irving TX

Sr. ETL Developer

Responsibilities:

• Extracting teh Portfolio Data from different Source systems like Oracle, SQL, and Flat files.
• Integrating teh Source Data to EDW Environment using Informatica based on Business Logic
• Used different Informatica Transformations to determine teh output for required reporting requirements.
• Worked on B2B DT Mapper, Serializer and Mapper.
• Involved in solving teh performance bottlenecks.
• Worked on Teradata Utilities like MLOAD, FLOAD, TPUMP and Bteq Scripts
• Working with Data Modeling team to address concerns on load related issues
• Migrating teh Data to Destination (Vendor Landing Zone) from different Business Units (Apps).
• Communicating with teh Application Team regarding teh Source Data files.
• Guiding Team Members for Deliverables
• Communicating with teh IT PMO’s regarding teh Delivery schedules.
• Onsite/Offsite Coordination

Environment: Informatica Power Center 9.1, B2B Data Transformation, Teradata Utilities( MLOAD, FLOAD, TPUMP Scripts) Shell scripting, MS SQL server 2010, Oracle 10g, File Zilla, HP Quality Center,Unix, Autosys, SharePoint

Confidential, Plano, TX

ETL Data warehouse Developer

Responsibilities:

• Requirement collection from Business users and Reporting team
• Giving work estimates for teh Informatica Development based on requirements
• End-to-End Development/Testing for teh Data warehouse using Informatica.
• Worked on Informatica Power Center 9.1 tool- Source Analyzer, Target designer, Mapping Designer, Transformation Developer, Mapplet Designer.
• Worked on Teradata Utilities MLoad, BTEQ Scripting, FLOAD, TPump with Informatica
• Involved in teh development of Informatica mappings and also tuned for better performance.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending teh error rows to error table so that they can be corrected and re-loaded into a target system.
• Extensively involved in testing teh system from beginning to end to ensure teh quality of teh adjustments made to teh source system up gradation.
• Extracted data from legacy systems and uploaded into Oracle Data warehouse.
• Assisting Data Model development team based on Informatica dev requirements
• Working with DB Team to address concerns on load related issues
• Coordinating Onsite/Offshore team for final delivery

Environment: Informatica Power Center 9.1/8.6, Informatica Change Data Capture(CDC), IDQ, Shell scripting, Teradata (Fload, MLoad, Tpump, Bteq), MS SQL server 2005, Oracle 10g, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages) and DB2

Confidential, Branchville, New Jersey Jan

Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model
• Worked on Informatica Power Center 9.1 tool- Source Analyzer, Target designer, Mapping Designer, Transformation Developer, Mapplet Designer.
• Used most of teh transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Joiner, Expression as per teh Business requirement.
• Developed procedures to populate teh customer data warehouse with transaction data, cycle and monthly summary data, and historical data
• Extensively used debugger to troubleshoot logical errors.
• Worked with teh Business analysts for requirements gathering, business analysis and testing.
• Requirement gatherings with teh Internal Users and sending requirements to our Source System Vendor.
• Used Teradata SQL Assistant to run teh SQL queries and validate teh data.
• Used Teradata and Oracle as sources for building teh datamarts to analyze teh business individually.
• Worked on Data Quality to proactively monitor and cleanse teh data for allapplications and maintain its cleanstate .
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor teh workflow run and statistic properties on Informatica Workflow Monitor.
• Involved in Unit testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
• Working in Agile methodologies and participating daily scrum meetings for providing status reports to team regarding project status, task and issues

Environment: Informatica Power Center 8.1, Teradata, Oracle10g, SQL Loader, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Confidential, Branchville, New Jersey

Developer

Responsibilities:

• Studied and understood teh warehouses, sources, and functionally analyzed teh application domains, involved in various noledge transfers from dependent teams understand teh business activities and application programs and document teh understandings for internal team referencing.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Study of detailed requirement of end users of system & their expectations from Applications
• Involved in teh data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Business process re-engineering to optimize teh IT resource utilization.
• Integration of various data sources like Oracle, SQL Server, Identify teh flow of information, analyzing teh existing systems, evaluating alternatives and choosing teh "most appropriate" alternative.
• Developed and tested all teh Informatica mappings, sessions and workflows - involving several Tasks.

Environment: Informatica 8.x, Oracle 8i, SQL, PL/SQL, SQL*Loader, TOAD, Windows 2000.

Confidential, Chicago IL

Informatica Module Lead

Responsibilities:

• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse.
• Experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables
• Designed and developed schema model for target database using Erwin Data modeling.
• Involved in pre and post session migration planning for optimizing data load performance.
• Setup teh data mart on Oracle database by running teh SQL scripts from ERWIN designer.
• Used packages to load teh base tables in teh Oracle database from teh flat file sources and XML sources.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Report generation using PERL and Microsoft Excel spreadsheet.
• Used SQL tools like TOAD to run SQL queries and validate teh data.
• Wrote stored procedures and triggers in Oracle for managing consistency and referential integrity across data mart.
• Tuning teh Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled teh batches to be run using teh Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing teh data flow, evaluating transformations and fixing teh bugs so that they conform to teh business needs.
• Have developed a level of competency, which halps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for teh Data issues Also he had to interact with teh business users to intimate and do teh recovery steps if there is any problem in teh process
• Deployment to various servers & Migration activities.

Environment: Informatica Power Center 8.1, Oracle10g, SQL Loader, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Confidential

Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Involved with business to understand Healthcare standards like HIPAA, HL7 and many other rules
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.x
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing teh deleted records in teh source systems.
• Worked extensively with teh connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Wrote UNIX scripts for teh business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Created Universes and generated reports on using Star Schema.

Environment: Informatica Power Center 8.1, Oracle10g, Teradata, Cron Tab

Confidential

Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop teh mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored teh results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server for data warehousing.

Environment: Power Center 8.6, UNIX scripting, MS SQL server 2005