SUMMARY

• 7+ years of IT experience in various phases of IT projects such as analysis, design, coding and testing, deployment and production support
• 5+ years of extensive experience with Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.x/8.x/7.x/6.x
• Extensively worked with different Data sources ranging from Salesforce, Postgres, Flat files, Oracle, Teradata, SQL server, and DB2.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, and implementation
• Experience with various domains of data warehouses like Financial, Healthcare, Insurance, Investment Banking, Telecommunication and Retail Domains.
• Good experience in Dimensional Data modeling techniques such as Star/Snowflake schema
• Extensively developed complex mappings and implemented Slowly changing dimensions of Type1/Type2/Type3
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re - usable transformations, Mapplets and PL/SQL stored procedures
• Experience in Pipeline partitioning to optimize the performance of mappings.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Well versed with Installation, Configuration & Administration of Informatica Power Center on Client/Server environment.
• Experience on upgradation of Informatica Power Center from version 7 to 8 and version 8 to 9
• Experience in UNIX shell scripting and configuring Cron jobs for Informatica job scheduling, backup of repository and folder
• Expertise in the QA process of ETL mappings like Unit, Functional and Integration testing.
• Expertise in End-User training, Designing documentation and Application/Product Demos.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x, Power Exchange, IDQ

Languages: SQL, PL/SQL, C, C++, XML, HTML, Visual Basic 6.0

Operating Systems: UNIX, Windows NT/ 98/2000/2003/2007, Sun Solaris

Tools: Erwin, TOAD, SQL Navigator, SQL Developer, Teradata SQL Assistant, SQL Loader, Salesforce, PG Admin, DB Solo, ER Studio

Databases: Oracle 11g/10g/9i/8i, T-SQL, MS SQL Server 2000/2005/2008, TeradataV2R5/V2R4, MS Access, DB2, Postgres

Job Scheduling: Autosys, Tidal, Control-M

BI Tools: Cognos 6.5, Business Objects XI R3, Crystal Reports 8

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. ETL/Informatica Consultant

Responsibilities:

• Responsible for Requirement Gathering, Project Co-ordination and Analysis of source data
• Translated business rules and functionality requirements into ETL procedures
• Implemented extraction/transformation/load (ETL) interfaces to facilitate transitioning from old legacy Postgres and Salesforce systems to Oracle systems.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Implemented best practices in ETL Design and development and ability to load data into highly normalized tables and star schemas.
• Performance tuning has been done to increase the throughput for both mapping and session level and SQL Queries Optimization as well.
• Successfully implemented Type 1 and Type 2 dimensions for inserting and updating slowly changing dimension tables in target for maintaining the history
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data to optimize the performance of mappings.
• Prepared unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Worked extensively on SQL, PL/SQL and UNIX Shell Scripts.
• Automated the jobs thru scheduling using Built in informatica scheduler, which runs every day by maintaining the data validations
• Prepared deployment documents, user guides, coding standards, and other technical documents
• Performed data profiling and data cleansing in order to remove inconsistent data to increase the performance.
• Involved in the Defect analysis call for UAT environment along with users to understand the data and to make any modifications if suggested by the user
• Prepared Change Request's, Work Order's, Problem Ticket's, and Work Request are for the deployment process.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Provided end user training and Production System Support.

Environment: Informatica Power Center 9.1/9.5, Postgres, Salesforce, DB Solo, ER/Studio Enterprise 8.5, WinSCP 5.1.4, UNIX, Oracle 11g/10g, Toad10.5, SQL Developer, JIRA, Quality Center

Confidential, Jersey City, NJ

Sr. ETL/Informatica Consultant

Responsibilities:

• Involved in the design, development and implementation of Customer Analytics Datamart.
• Involved in Dimensional modeling to design and develop Star Schema, using Erwin to design Fact and Dimension Tables
• Translated business rules and functionality requirements into ETL procedures
• Used Informatica client components like Designer, workflow Manger and Workflow Monitor
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, flat files and loaded into target.
• Performed data migration and data cleansing using various transformations such as Expression, Filter, Joiner and Lookup.
• Performed Performance tuning at the Mapping level as well as the Database level to increase the data throughput
• Successfully implemented Type 1 and Type 2 dimensions for inserting and updating slowly changing dimension tables in target for maintaining the history
• Responsible for implementing Incremental loading of mappings using Mapping Variables and Parameter Files.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Managed metadata associated with ETL processes used to populate the data warehouse
• Developed and modified PL/SQL, procedures, functions, triggers, reports as per business requirements
• Configured and ran the Debugger within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow
• Extensively involved in parameterization of the workflow objects.
• Have identified and resolved performance bottlenecks at various levels like sources, targets, mappings, and sessions
• Created UNIX Shell Scripts for pre/post session commands for automation of loads using Autosys
• Provided end user training and Involved in Production support for session failure and recovery, and monitoring informatica ETL jobs.
• Worked in cooperation with BI team which used Business Objects for reporting
• Responsible for maintaining ETL technical documentation and in building the ETL Source to Target specification documents by understanding the business requirements

Environment: Informatica Power Center 9.0.3/8.6, Power Exchange 8x, Erwin 4.2 Win 2003, UNIX, Oracle 11g/10g, SQL Server 2008, Teradata, Toad8.5, Autosys, Business Objects

Confidential, Madison, WI

ETL Developer

Responsibilities:

• Worked closely with a project team for gathering the business requirements and interacted with business analysts to translate business requirements into technical specifications
• Extracted data from different sources like AS400/DB2, SQL Server and flat file sources as per the requirement of ETL processes.
• Developed complex mappings in Informatica to load data from various sources using transformations like update strategy, lookup, Router, Filter, sequence generator, joiner, aggregate, expression transformation.
• Developed reusable transformations and mapplets to avoid duplication of metadata, reducing the development time.
• Creating /Running Sessions & Batches to load the data into the target Database.
• Design mappings involving Target load order and Constraint based loading.
• Configured and Used the Debugger to troubleshoot the mappings
• Extensively used SQL and PL/SQL scripts for transformations.
• Set up batches and sessions to schedule the loads at requested frequency.
• Configured the sessions in workflow with various dependency’s using Decision, Command, Event Raise and Event Wait Tasks.
• Performed data profiling and data cleansing to remove inconsistent data.
• Involved in Testing and Test Plan, Test Cases and Test Scenarios Preparation and Process Improvement for the ETL developments.
• Responsible for tracking and maintaining change requests, defects, and risks
• Used Control-M job scheduler to call the Informatica workflows.
• Improve performance of mappings by identifying source, target and mapping bottlenecks.
• Efficient documentation done for all phases like Analysis, design, development, testing and maintenance.

Environment: Informatica 8.x, Oracle10g, SQL server 2005, SQL Plus, Toad, Flat Files, UNIX, Windows 2003/2008, AS400, Control-M

Confidential, New York,NY

ETL Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Analyzed data flow requirements and developed a scalable architecture for staging and loading data.
• Translated business rules and functionality requirements into ETL procedures
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, Teradata,flat files and SQL databases and loaded into target
• Extensively used Informatica client components like Designer, workflow Manger, Workflow Monitor.
• Used various Transformations like Stored Procedure, Router, Expressions, source qualifier, aggregators and filters in order to implement complex business logic to populate data warehouse efficiently.
• Extensively used both Connected and Unconnected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Configured and ran the Debugger within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow
• Have identified and resolved performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Performed Pipeline partitioning to optimize the performance of mappings.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Responsible for Unit testing and Integration testing of mappings and workflows
• Extensively used SQL and PL/SQL scripts.
• Extensively used SQL*Loader for uploading data.
• Actively involved in end user training and support
• Efficient Documentation was done for all mappings and workflows.

Environment: Informatica PowerCenter 8x, Teradata,Oracle 9i, UNIX Shell Scripting, SQL, PL/SQL, SQL Loader, TOAD, Erwin 3.5.5, Sun Solaris UNIX, Windows 2003

Confidential, Alpharetta, GA

ETL Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Designed the ETL processes using Informatica tool to load data from DB2 into the target Oracle 10g database.
• Wrote triggers and stored procedures for cleaning up data and providing underlying structure for reporting.
• Developed mappings/sessions using Informatica Power Center 7.5/6.2 for data loading.
• Scheduled batch and sessions within Informatica using Informatica scheduler
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Involved in Fine tuning SQL overrides and Look-up SQL overrides for performance Enhancements.
• Implemented Error Handling Strategy in all dimension mappings.
• Created reusable worklets and maplets transformations.
• Extensively worked with mapping parameters and session parameters.
• Created Partitions to concurrently load the data into targets.
• Configured the sessions in workflow with various dependency’s using Decision, Command, Event Raise and Event Wait Tasks.
• Tuned mappings and sessions for better performance of the data loads

Environment: Informatica Power Center 7.5/7.1, PL/SQL, Oracle, DB2, Windows XP/NT, UNIX

Confidential

Oracle developer

Responsibilities:

• Normalized of database to remove data redundancy.
• Prepared Entity Relationship diagrams.
• Created tables, views, synonyms and sequences.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Created front end applications using forms and reports.
• Extensively used Database Triggers, procedures, functions and packages.
• Used SQL * Loader and Export, Import utilities to load / Extract the data.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms and reports.

Environment: Oracle8i, PL/SQL, Developer 2000 and Windows98/00