SUMMARY:

• 11 years of experience in ETL Informatica Power Center 9.61, 9.5.1, 9.5.1, 8.6.1, 8i, 7i, 6i and Power Exchange . Experience in OBIEE 11g report development for 3 years. Worked in various domains like Banking, Home loan Banking, Manufacturing, Airlines, Cruise lines Retail, Insurance, Banking.
• Certified in Oracle IZ0 - 007 for SQL.
• Worked in Agile and Water fall Methodology.
• Strong in Data warehousing methodologies of Star /Snow Flake schemas of Ralph Kimball, Bill Inman.
• Experience in DataWarehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Actively involved in Performance Tuning, Error handling, Oracle query optimization, Product support on various Platforms.
• Experience in working with PDO Push down Optimization and Partitioning.
• Used Power Exchange to source copybook definition and then to row test the data from data files, VSAM files.
• Developed SCD Type1 and Type2 ETL mappings to load history data using Informatica
• Experience in UNIX working environment, writing UNIX shell scripts.
• Documentation: Expertise in preparing the ETL Design Documents like High Level, low level Design documents, Technical design documents and Source to Target Mappings.
• Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
• Worked with Teradata DB (Fast load, Multiload, Tpump and Fastexport), T-SQL, SQL and PL/SQL Scripts through various procedures, functions, and packages, Triggers to implement the business logic.
• Worked with Netezza, GreenPlum PostGreSQL Data base.
• Experience in Oracle Business Intelligence Enterprise Edition 11g and Oracle BI Apps.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher and iBots within OBIEE Suite.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Experience and hands on with Big Data Edition of Informatica9.6.1 and Hadoop components like Hue, Impala, Pig, Scoop.
• Managing and tuning Hadoop cluster.
• Experience of managing clustered services.
• Experience in designing the logics to be implemented at the RPD level.
• Experience in designing and development of all layers of OBIEE Repository i.e. Physical, Business Model, and Presentation layer.
• Creating Presentation Catalogs with measures from Multiple Fact Tables.
• Experience in creating the Dashboard and Report level prompts.
• Implemented Measures & Dimensions and organized the information data into related subject areas. Involved in scheduling the workflows through Job scheduler using UNIX scripts.
• Knowledge on Informatica Cloud.
• Coordinated efforts with ERP team regarding Master Data Tables with the Enterprise MDM Solution
• Good in analysis and problem solving, Good team player.
• Good in writing and communication skills.
• Worked with multiple teams like DBA, Unix admin and Data modeling, technical teams and Business users for gathering business requirements.
• Good in planning, organizing, prioritizing multiple tasks.
• Interested in learning new technologies and willing to working changing environments.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.5.1,9.0.1, 8.x, 7.x,Netezza plug-in, Informatica B2B, SAP Power Connector, INFORMATICA Big data edition 9.6.1,, Hadoop, Hue, Pig, Impala, Scoop.

BI Tools: OBIEE 11g.

Databases: DB2, Oracle 11G, 10g 9i/8i, Teradata, MS SQL Server 2008, DB2, MS Access, Sybase, Greenplum, Netezza, T-SQL.

Operating Systems: Windows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIX.

Programming: C, SQL, PL/SQL

Scripting Languages: SQL, PL/SQL, UNIX Shell Scripting

Methodologies: E-R Modeling, Star Schema, Snowflake Schema

Other Software Engineering Tools/Technologies: Toad, Putty, Remedy, DAC, Tivoli, Remedy, Control M

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Sr. Informatica Developer

Responsibilities:

• Project is on Asset Liability Management. Calculating Liquidity Ratios for various stress scenarios.
• Collecting requirements from the BSA team. Implementing business rules using Informatica 9.6.1.
• Work with various sources. XML, Flat Files and Relational Database.
• Developed complex mappings using various transformations to implement business rules and store data in EDW on oracle.
• Implemented Confidential for mappings so as to capture the changes and maintain history.
• Involved in ETL load process and control framework for the warehouse.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Performance Tuning of SQL Queries and ETL Mappings.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of the mappings migrated to QA and production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance.
• Experience in writing Batch/ Shell scripts handle files and informatica jobs from AIX UNIX.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Good verbal and written skills and
• Good team player.

Environment: Informatica Power center 9.6.1, Oracle 11g, UNIX, Toad, Putty, and Quality Center.

Confidential, Irving, TX

Sr. Informatica Developer

Responsibilities:

• Designed and developed Complex Mappings, to store the data in EDW on SQL Server in Normalized form, Error handling, and implementation of business rules.
• Implemented Confidential for mappings so as to capture the changes and preserve history.
• Experience and hands on with Big Data Edition of Informatica9.6.1and Hadoop components like Hue, Impala, Pig, Scoop.
• Managing and tuning Hadoop cluster.
• Experience of managing clustered services.
• Involved in ETL load process and control framework for the warehouse.
• Worked with Unstructured Data.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Performance Tuning of SQL Queries and ETL Mappings.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of the mappings migrated to QA and production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance.
• Experience in writing Batch/ Shell scripts handle files and informatica jobs from AIX UNIX.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Good verbal and written skills and
• Good team player.

Environment: Informatica Power center 9.5.1, INFORMATICA Big data edition 9.6.1, Hadoop, Hue, Pig, Impala, Scoop, SQL Server 2008, 2012, Flat files, UNIX, AIX, XML.

Confidential, Portland, OR

Sr. Informatica Developer

Responsibilities:

• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies, Worked as an ETL Architect.
• Designed and developed Complex Mappings, which involves extracting order related data from XML’s and store the data in SQL Server in Normalized form, Error handling, and implementation of business rules then generate the Flat files to send it to Warehouse maintenance team.
• Implemented Confidential for mappings so as to capture the changes and preserve history.
• Applied PDO to optimize the mappings.
• Involved in ETL load process and control framework for the warehouse.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Performance Tuning of SQL Queries and ETL Mappings.
• Created Sessions, Work lets and workflows for designed mappings.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of the mappings migrated to production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance.
• Experience in writing Batch/ Shell scripts handle files and informatica jobs from AIX UNIX.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Good verbal and written skills and
• Good team player.

Environment: Informatica Power center 9.5.1, DB2, SQL Server 2008, 2005, flat files, AQT for DB2, UNIX, AIX, ERwin 4.0.

Confidential, Dallas, TX

Sr.Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Member of the warehouse design team, which interacted with the business community and database administrators to identify the business requirements.
• Worked with SAP Sources to merge Finance data into EDW.
• Experience in designing the logics to be implemented at the RPD level.
• Experience in designing and development of all layers of OBIEE Repository i.e. Physical, Business Model, and Presentation layer.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies.
• Worked in SAP BODS finance application.
• Deploy Informatica Objects TEST, UAT and Production Environments.
• Developed Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Various Transformations like Expression, Lookups, Filters, Sequence Generator, Joiner, and Sorter were used to handle situations depending upon the requirement.
• Worked with MDM for one of the application.
• Called Stored Procedures to perform Database operations on Post-Session and Pre-Session commands.
• Implemented Change Data capturing ( Confidential ) for Type2 slowly changing dimensions to keep track of Historical data.
• Created parameter file for session parameters and called in the sessions.
• Created shortcuts to reuse objects across folders without creating multiple objects in the repository.
• Involved in coding & designing of SQL, procedures, functions and support.
• Worked with Teradata DB (Fast load, Multiload, Tpump and Fastexport).
• Dropped and recreated the Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings. Extensively used PDO for optimizing the loads.
• Performed Unit Testing and verified the data using Informatica Debugger break points.
• Tuned mappings and sessions for better performance on the data loads.
• Performed Error handling on sessions in Workflow Manager.
• Good in analysis and problem solving and good team player.
• Willing to learn new technologies.

Environment: Informatica 9.1.1,SAP BODS,OBIEE 11g,UNIX, LINUX Windows 2007, Oracle 10g, Teradata, PL/SQL,T-SQL, SQL, SQL Server 2008/2005, database, Putty, WinSCP, Cron Tab, Toad and SQL developer, MDM.

Confidential, Plano, TX

Sr. Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Designed and developed Complex Mappings, which involved slowly changing dimensions (Type2), Error handling, and implementation of business rules.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Design and Implement Informatica mappings to Migrate data from various legacy applications/acquisition offices to a centralized application.
• Use Elite Software to maintain change control approval process.
• Worked with Teradata DB (Fast load, Multiload, Tpump and Fastexport).
• Deploy Informatica Objects and TEST, UAT and Production Environments.
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Various Transformations like Expression, Lookups, Filters, Sequence Generator, Joiner, and Sorter were used to handle situations depending upon the requirement.
• Called Stored Procedures to perform Database operations on Post-Session and Pre-Session commands.
• Implemented Type2 slowly changing dimensions to keep track of Historical data.
• Created parameter file for session parameters and called in the sessions.
• Created shortcuts to reuse objects across folders without creating multiple objects in the repository.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated the Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Experience in working with SSIS packages.
• Performed Unit Testing and verified the data using Informatica Debugger break points.
• Tuned mappings and sessions for better performance on the data loads.
• Performed Error handling on sessions in Workflow Manager.
• Involved in Internal KT’s and Production support transitioning.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies.

Environment: Informatica 8.6, UNIX, Windows 2007, Oracle 10g Enterprise Edition, PL/SQL, SQL, SQL Server 2008/2005, database, Putty, WinSCP, CronTab, Toad and SQL developer .

Confidential

Informatica Developer

Responsibilities:

• I have been involved in development & major/minor development projects for Customer Relationship Management & Maintenance activities like Extracting and sending customer related information to clients sister companies.
• The maintenance/enhancement requests come in the form of Change Requests (CR). These are mostly to do the need of capturing new metrics and thus require a change in data warehouse model (dimension/fact structure). The solution is delivered according to the standards and guidelines.
• Clear Quest tool is used for implementing the Software Development Methodology (SDM) process in any development and enhancement work at Confidential . As per the SDM process followed at Confidential , any development and enhancement work needs to have -
• For Development environment:
• I have been working on Informatica (Fixing/modifying/developing/mappings/sessions/workflows)
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated the Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Created Sessions, Worklets and workflows for designed mappings.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange .
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of the mappings migrated to production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance .
• Experience in working with SSIS packages.
• Used Shell scripts to call procedures and load the data into the table.
• Developed Perl scripts to automate pre session and post session tasks.
• Involved in the End user training and worked in testing and production support environments.
• Efficient Documentation (Migration document) was done for all mappings and workflows.

Environment: Informatica 8i, UNIX, Windows 2003/07,Oracle10g Enterprise Edition, PL/SQL, SQL, UNIX Shell Scripting, Putty, WinSCP and Toad, SQL Server 2008/2005,SSIS.

Confidential, SC

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings.
• Worked in Onsite and as well as in Offshore as a Developer and Coordinate the Onsite and Offshore Teams for maximum productivity by resolving the issues.
• Involved in the team during the entire ETL process and development of data marts using Informatica PowerCenter 8.6/7.x.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin and Business Intelligence Reporting Applications using OBIEE.
• Extracted the data from Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, MappingDesigner, Workflow Manager, Mapplet Designer and Transformation Developer.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Created Reusable transformation and Mapplet based on the business rules to easy the development process and responsible for document the changes.
• Maintained and modified mappings as per changing reporting requirements.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Checked Sessions and error logs to troubleshoot problems and also used Debugger for complex Problem troubleshooting
• Developed Informatica mappings/sessions/workflows for ETL processing and used UnixShellScripts for smooth application interfacing.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in using the Stored Procedures, Functions and Triggers at Data Base level and imported them in Informatica for ETL.
• Extensively used SQL * Loader for Bulk loading from Flat Files to Oracle Tables.
• Involved in Unit and System testing of developed mappings.
• Responsible for migrating the folders or mappings and sessions from development to production environment.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power center 8.6/7.x,XML, Flat Files, UNIX, Windows 2003,Oracle 9i, PL/SQL, SQL, MS Visio, Shell Scripting, Putty, WinSCP and Toad.

Confidential

Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various Mappings & Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping. Also developed Error Processing to capture the error records and loads them into Message Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Fine tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.

Environment: Informatica 6.1, UNIX, Windows 2003, Oracle8i, PL/SQL, SQL, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer.