SUMMARY:

• Over 8 Years of IT experience with more than 7+ years of experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center 8.6, Power Exchange MQ (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administrator Console and Server Manager), Data Warehouse Builder, Kimball methodology. Experience in Installation, Configuration of Informatica Power center 7.x/6.x Client, Server in Windows and UNIX.
• Highly experienced in Extraction/Transformation/Loading of the legacy data to Data warehouse using ETL Tools.
• Designing and executing test plans and gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Involved in developing mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Mapping Designer & Transformation Developer.
• Used various Transformations such as Expressions, Filters, aggregators, Lookups, Routers, Normalizer, and Sequence Generator etc. to load consistent data in to Oracle, SQL, Sybase and Teradata databases.
• Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Experience in Integration of various data sources like Oracle, Teradata, SQL Server, DB2 and Flat Files in various formats like fixed width, CSV and excel.
• Have in depth knowledge and experience in implementing the best practices for design and development of data warehouses using Star schema & Snowflake schema design concepts.
• Experience in Informatica IDQ and IDE.
• Involved in Data modeling techniques like normalization, demoralizations, physical database design, relational models, star schemas, snowflake schemas, etc.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
• Worked on data analysis and data validations and preparing Unit Test Cases.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: InformaticaPowerCenter:7.1,8.6,9.1,PowerExchange:8.6,9.1,IDE Client.

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling

RDBMS: Oracle 11g/10g/9i/8.x,: SQL Server 2008/2005/2000, MySQL, DB2, MS Access

Database Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Teradata SQL Assistant

Reporting Tools: OBIEE, Business Objects 5.1

Web Technologies: HTML, XML, DHTML, PHP

Languages: SQL, PLSQL, Shell Scripting, C, C++

Operating Systems: MS - DOS,Windows7/Vista/XP/2003/2000/NT, UNIX, AIX, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential MI

Informatica Consultant

Activities and Responsibilities:

• Involved in complete SDLC process, through all phases of project life cycle - analysis, design, development, testing, implementation and post-production activities.
• Developed High Level Technical Design specification and Low-level specifications based on business requirements.
• Conducted meetings on full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Worked closely with business analysts to gather functional specifications and turn them into technical specifications.
• Worked on ETL processes using Informatica 9.1.
• Designed and developed Informatica code to extract, convert and load data for the reporting feeds as per the business requirements.
• Involved in the full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Designed and developed full load & incremental load mapping.
• Created mapplets which provides reusability in mappings.
• Involved in debugging the failed mappings identify the root cause and developing error-handling methods.
• Resolved Source system data issues by performing Data profiling and providing workaround techniques.
• Worked with different source & target systems like XML, flat file, relational tables.
• Worked with Direct and Indirect Flat Files.
• Identified long running jobs and implemented various performance tuning techniques to mitigate the bottlenecks.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA, Prod environments.
• Deployment of Informatica Mappings/Sessions/Workflows into Production environment.
• Worked with DBA’s to tune long running SQL queries.
• Used Variables and Parameters in Mappings, Workflows and Sessions.
• Documented the Unit Test Cases & Integration Testing Steps and captured the results. Prepared release notes for migrating the objects from DEV to INT to UAT environments.
• Informatica Production Support, including off hours and weekends.

Environment: Informatica Power center 9.1,Informatica Data Explorer Client 9.1, Power Exchange, Flat Files, PL/SQL, Oracle 10g, UNIX, Toad, SQL Developer.

Confidential, TN

Sr. Informatica Developer

Activities and Responsibilities:

• Member of the TN VIP Conversion Module development team. Involved in Requirement gathering, analysis of requirements and solution design.
• Understanding the business needs and implement the same into the functional database design.
• Development of informatica mappings, mapplets, workflows and worklets according to the design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Source qualifier, Filter, Connected& Unconnected lookups, Joiner, Update strategy, Sequence Generator etc, for developing mappings,
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Performed data cleansing, troubleshooting, debugging and cache optimization.
• Implemented Error handling logic to capture the invalid data.
• Experience in all phases right from requirement gathering for the data to develop the code, Unit testing and Documenting.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target oracle tables using Informatica Workflow Manager.
• Building the necessary staging tables and worktables on oracle development environment.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects. Partitioned the sessions to reduce the load time.
• Created and run sessions and Batches using server manager to load the data to the target Database.
• Conducted a lot of research to check the accuracy of data in Teradata database tables and the possibility to use Teradata tables instead of tables created by different vendors.
• Sourced the data from XML files, flat files, SQL server tables and Oracle tables.
• Created, scheduled and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Involved in conducting Informatica powercenter, Informatica PowerExchange, Teradata.
• Created ETL components for data conversion using informatica 8.6.0 Analyze Source, Target schema.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin.
• Designed and developed UNIX shell scripts to automate the entire process.
• Responsible for monitoring all the session that are running, scheduled, completed, failed and Debugged the mapping of the failed session.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Implemented Error handling logic to capture the invalid data.
• Designed and developed Oracle PL/SQL Procedures.
• Create root cause analysis and resolution to fix defects.
• Involved in On-site/offshore coordination.

Environment: Informatica Power Center 8.6.0, PL/SQL, Oracle, Teradata, Java, TOAD, Shell Scripts, SQL * Loader, UNIX scripting.

Confidential, PA

ETL Developer

Activities and Responsibilities:

• Involved in design, development and implementation of ETL process in power center.
• Extracted data from Oracle, SQL Server, Flat files and DB2 source systems.
• Extracted data from VSAM files to ASCII source files using Informatica Power Exchange.
• Used Informatica Designer to create complex mappings using different transformations to move data from the source to the Data Warehouse.
• Developed the transformation/business logic to load data into data warehouse.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Transformation Developer to create the filters, lookups, and stored procedure, Joiner, update strategy, expressions and aggregations transformations.
• Developed reusable mappings using Mapplets, parameters and Variables.
• Developed Fast export scripts to extract source Flat files.
• Involved in Dimensional modeling (star schema) of the Data warehouse and using ERwin to design the business process, dimensions and measured facts.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Joiner, Source Qualifier, Aggregator, Filter, Sorter, Update Strategy transformations.
• Designed Complex mappings for Slowly Changing Dimensions using Lookup (connected and unconnected), Update strategy and filter transformations for retaining consistent historical data.
• Utilization of Informatica IDE to complete initial data profiling and analysis work.
• Involved in production implementation of Teradata system upgrades as part of maintenance.
• Work with system Analysts to prepare detailed space from which program will be written.
• Wrote Triggers, PL/SQL Procedures, and Functions to validate the complex mappings.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Developed Workflows with various Tasks and Sessions.
• Developed Shell scripts for Job Automation.
• Responsible for managing, scheduling and monitoring the workflow sessions.
• Responsible for Error handling, bug fixing, Session monitoring, log analysis.
• Performance tuning of the process at the source level, target level, mapping level, session level.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Responsible for migration of Informatica mappings, workflows between different environments.
• Effectively communicated with Informatica Support team on Informatica bugs & issues.

Environment: Informatica Power Center V8.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Power Exchange 8.1, SQL, PL/SQL, Oracle 11g/10g, DB2, Flat files, Shell Scripting, UNIX, Mainframes, Windows.

Confidential, CT

Informatica Developer

Roles and Responsibilities:

• Interacting with the end users to get all the incomplete requirements and developed client satisfied code.
• Performed Source System Data analysis as per the Business Requirement. Distributed data residing in heterogeneous data sources is consolidated onto target Enterprise Data Warehouse database.
• Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
• Identify the Fact tables and slowly changing dimensional tables.
• Building the necessary staging tables and worktables on oracle development environment.
• Sourced the data from XML files, flat files, SQL server tables and Oracle tables.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects. Partitioned the sessions to reduce the load time.
• Experience designing and developing in the informatica IDQ environment.
• Lead an offshore team of six members.
• Performed data cleansing and cache optimization.
• Developed complex mappings in Informatica to load the data from source files using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, normalizer, Router and Mapplets.
• Change Data Capture for Incremental Aggregation.
• Developed Mappings that extract data to Data Warehouse and monitored the Daily, Weekly, Monthly and Quarterly Loads.
• Created High level/detailed level design documents and also involved in creating ETL functional and technical specification.
• Documented ETL development standards as per client requirement.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
• Extensively worked in performance tuning of programs, ETL procedures and processes.
• Performed Unit, Systems and Regression Testing of the mappings. Involved in writing the Test Cases and also assisted the users in performing UAT.
• Extensively used UNIX shell scripts to create the parameter files dynamically and scheduling jobs using AutoSys.
• Created integration services, repository services and migrated the repository objects.
• Written PL/SQL procedures for processing business logic in the database.
• Query based optimization, Cost based optimization.
• Used heterogeneous data sources Oracle, DB2, and XML Files, Flat Files as source also imported stored procedures from Oracle for transformations.
• Provided production support and maintenance for all the applications with the ETL process.

Environment: Informatica Power Center 8.3, Oracle 10g, SQL, PL/SQL, TOAD, Shell Scripts, UNIX (AIX).

Confidential

Informatica Developer

Roles and Responsibilities:

• Created the mappings according to the design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented Error handling logic to capture the invalid data.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Performance tuning of Oracle PL/SQL Scripts.
• Designed and developed UNIX shell scripts.
• Developed mappings for policy, claims dimension tables.
• PL/SQL statements performance tuning.

Environment: Informatica Power Center 8.6.0, PL/SQL, Oracle, Java, FTP, TOAD, Windows 2000, Shell Scripts, SQL * Loader, Unix scripting.

Confidential

SQL Developer

Activities and Responsibilities:

• Created and maintained Windows NT user profiles
• Installed and configured MS SQL Server 7.0 on NT machines
• Created and managed tables, functions, indexes using T-SQL in development and Production environment
• Created stored procedures and triggers using T-SQL in Query Analyzer
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins
• Responsible for setting up the monitoring performance counters and alerts on Windows NT for SQL Server database

Environment: MS SQL Server 7.0, T-SQL, and Windows NT 4.0