SUMMARY:

• 8 plus Years of IT experience in development, Implementation and Testing of various projects on DataWarehouse projects.
• Skilled in Planning, Designing, developing and deploying Data warehouses/Data Marts
• Strong experience in designing and developing Business Intelligence solutions in Data warehouse/Decision support systems using ETL tools.
• Extensivly worked on ETL tools using Informatica 9.6.5.1/8.6.1/8.6.5.1 (PowerCenter/ PowerExchange, Power Mart and IDQ), Oracle 11g/10g, Teradata 14/13 and BOXI R2.
• Experience in Informatica Big Data Developer Edition and Autosys.
• Knowledge of Informatica CDC.
• Experience in Information Lifecycle Management (ILM)
• Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables,Slowly Changing Dimensions (SCD).
• Involved in migration of Informatica from 8.x to 9.x.
• Extensively worked on Teradata queries and Utilities BTEQ, MLOAD, FLOAD, FEXPORT, TPUMP.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), Waterfall development process, Agile - SCRUM development methodology, RDBMS, OLTP, ETL, OLAP, and DW Concepts.
• Expert in PL/SQL Stored Procedures, Triggers and Packages.
• Experience in designing/developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer.
• Improved in performance tunning by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Hands on Experience in SQL, UNIX, Shell Scripting, Data Relationships, Data extraction & Validation.
• Sources worked various sources and targets included Flat Files, Excel files and Databases, xml and web services.
• Extensive experience developing complex mappings with Custom Transformations, XML Sources, Web Services Consumer.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching
• Resolving data issues, complete unit testing and complete system documentation for ETL processes
• Comprehensive knowledge in Dimension modeling concepts like Star Schemas and Snowflake Schemas.
• Experience on creating detailed project outlines and application design specifications.
• Experience in analyzing business specification documents, developing test plans, defining test cases, developing and xml test scripts.
• Involved in development of Test cases and executing the Test cases.
• Involved extensively in GUI, System Testing and Regression Testing.
• Good experience in AIX & UNIX working environment.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
• Ability to quickly analyze and -up with an efficient industry standard solution for a given proble come

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x, Informatica PowerExchanges 9.x/8.x, IDQ 9.6/9.1

BI Tools: OBIEE (10G, 11G), BOXI R2

Scheduling Tools: Control-M, Autosys

Languages: C, Java,C++

RDBMS: Oracle/Exadata/11g/10g, DB2V9, Green plum, Teradata 14/13, Pl/Sql, Sql Server 2008

Tools: /Utilities: Toad, Perl, UNIX Shell, Busniness Objects XI R1

Operating Systems: Windows, UNIX, Linux

Web Technologies: HTML, CSS, XML, JAVA SCRIPT

PROFESSIONAL EXPERIENCE:

Confidential, SFO,CA

Sr. Informatica developer

Responsibilities:

• Involved in meeting with Business to Gather, Designed the target load process based on the requirement documents.
• Provide technical leadership to other support team members and resolution of technical issues.
• Provide recommendations on database index strategies based on performance metrics.
• Reviewing data models and doing code reviews.
• Optimized the performance using Informatica performance and Informatica Life Cycle concepts.
• Converted stored procedures into infomatica with better performance.
• Enhancing the existing mappings where in the changes are made to the existing mappings.
• Testing and debugging the Enhanced mappings.
• Creating the ETL run book for prod support run.
• Worked on requirement gathering from B2B to XML’s feed (Customer and Product).
• Developed XML’s using XML parser Transformation for large scale data transmission.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed the CIM ETL Mapping by using Informatica power center to load the data from XML source to 48 staging tables in Green plum Database.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Oracle and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Created Informatica Data Quality mapplets and mappings for Data profiling, address validation, Data Standerdisation and data cleaning.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Worked on various phases of testing like UTC, UAT and SIT.

Environment: Informatica PowerCenter 9.6/9.1, PowerExchange 9.6/9.1, ILM IDQ 9.6/9.1, DB2 v9.1, Oracle 11g, pl/Sql, TOAD, Green plum, Quest Central, Flat Files,Teradata 14/13, BOXI R2, Linux, Windows XP, Unix

Confidential, NYC, NY

ETL Developer

Responsibilities:

• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Oracle and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Preparation of Test Cases and Executing the Test Cases UAT Tool
• Involved in System Testing, Regression Testing, Security Testing.
• Creating the ETL run book and actively participated in all phases of testing.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue.
• Extensively worked in the performance tuning for SQL and Pl/Sql code.
• Developing, Testing and debugging the mappings in informatica.
• Data validation testing. Preparing the documents for test data loading

Environment: Informatica PowerCenter9.1,Informatica PowerExchange9.1, Rally, Linux Oracle 11g, PL/SQL,IDQ9.1

Confidential, Indianapolis, IN

Informatica Developer

Responsibilities:

• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where in the changes are made to the existing mappings.
• Testing and debugging the Enhanced mappings.
• Develop Mappings and Workflows to generate staging files. Developed complex Informatica mappings and tuned them for better performance
• Created Workflows, Tasks, database connections using Workflow Manager
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Involving in extracting the data from Oracle and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source,target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements. Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Repository administration like creating folders and grant access to other users.
• Developing, Testing and debugging the mappings in informatica.
• Worked on Data quality like Data validation, Data Cleansing, profiling and standerdisation.
• Creating a CR request to move the code to production.Preparing CR documents like release notes and ETL and DBA SRR Documents.
• Writing scripts for generating parameter files, restart token, cleaning files and connections.
• Managing the control table to maintain load history.
• Developing, Testing and debugging the mappings in informatica.Preparing the documents for test data loading
• Created Pl/Sql Stored Procedures, Function, Package for control table load and report table load.

Environment: Informatica PowerCenter 8.6, Informatica PowerExchange 8.6, Oracle 10g, Db2 Main Frames, Sql Server 2008, PL/SQL,TOAD, Flat Files, Windows XP, Unix Sun Solaris 2.6, F-Secure, Putty

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Developed High Level, High Level and Unit Test documents for ETL process.
• Develop Mappings and Workflows to extract data from various sources like Files and Database.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created reusable components like UDF, Transfromations and active and passive Mapplets.
• Created Workflows, Tasks, database connections using Workflow Manager
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Setup audit and recovery for the failed Sessions and Batches.
• Involving in extracting the data from Oracle, DB2, CSV and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Preparing and performed the test data loading and tesing.

Environment: Informatica PowerCenter 8.1, Oracle 10g, DB2, Pl/Sql, Linux, Unix, Putty. Toad.

Confidential, Commack, NY

ETL/Informatica Developer

Responsibilities:

• As a Technical Team Member I involved in Development of different modules and PL/SQL procedures.
• Identifying the business user requirements and prepared HLD and LLD.
• Developed transformation logic and developed various mappings in Designer
• Extensively used ILM and Informatica Power Center 8.1 as an ETL tool to extract, transform and load data from remote sources to DW.
• Worked with various active & passive transformations.
• Developed complex Informatica mappings and tuned them for better performance.
• Used ODBC to connect to the target Oracle database.
• Extensive Use of SQL Overrides and substituted them in place of multiple transformations.
• Used transformations for data joins, complex aggregations.
• Responsible for improving query and session performance.
• Created complex mappings using Lookup, Aggregator and Router transformations for populating target table in efficient manner
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Sequence generator and joiner transformations.
• Created, launched & scheduled sessions and batches using Server manager.
• Define mappings slowly changing dimensions and slowly growing Targets.
• Performed Unit testing

Environment: Informatica PowerCenter 8.1, ILM Oracle 10g, PL/SQL, Win NT, UNIX, Flat Files, SQL loader, AIX, Toad

Confidential

ETL/ DB Developer

Responsibilities:

• Creating the PL/Sql code for Extraction, Transformations and Loading.
• Identifying the business user requirements and datamapping sheet.
• Developed transformation logic and developed various code in Sql++
• Extensively used Oracle as an ETL tool to extract, transform and load data from remote sources to DW through sql loader and store procedure.
• Developed complex sql and pl/sql and tuned them for better performance.
• Created, launched & scheduled sessions and batches using Server manager.
• Performed Unit testing, sytem testing and volume testing.

Environment: Oracle 10g, PL/SQL, Win NT, UNIX, Flat Files, SQL loader