SUMMARY

• 8+ years of total IT experience in Software Development Life Cycle (SDLC) with strong background in Database Development and ETL Data Warehousing using Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1 and Informatica PowerExchange 9.5.1/8.6/8.1.
• Eight plus years of Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources. Worked on data integration from various source files such as flat files, CSV files, Relational Databases etc into a common analytical Data Model.
• Certified in Agile Methodology (Scrum, XP)
• Four years of experience with PowerExchange to extract data in real - time and batch mode.
• Extensive working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL) methodologies.
• Extensively worked on database objects like Stored Procedure, Function, Package and Triggers.
• Worked on Stored Procedure concept to truncate tables and delete rows from error logs.
• Expertise in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Workflow Manager and Workflow Monitor.
• Strong understanding of RDBMS and Data modeling concepts. Worked on various methodologies of data modeling using Erwin 4.1/3.5.
• Expertise in OLTP/OLAP System Study, Analysis and database schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extensively worked on Performance Tuning techniques at various levels to increase the performance and minimize the time for work.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
• Conducted System Integration Testing, UAT and functionality testing, coordinated to move code to various environments and investigated software bugs.
• Proficient in UNIX Operating system and shell scripting.
• Proficient in usage of TKPROF, EXPLAIN PLAN and SQL TRACE used in performance tuning of code.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Strong business analysis skills to find business problem, process, management and possesses.
• Ability to work individually as well as Team.
• Worked on Teradata SQL and utilities like FLOAD, MLOAD, FLOAD and TPUMP.
• Excellent communication and interpersonal skills. Good team player with excellent analytical and presentation skills with strong aptitude towards learning new technologies.

TECHNICAL SKILLS

ETL Tool: Informatica PowerCenter 9.5/9.1/8.6.1/8.6/8.1/7.1 , Power Exchange 9.1/8.6/8.1

Data Modeling: ERwin r7.3/4.0/3.5, Star schema Modeling, Snowflake modeling.

Languages: PL/SQL, SQL*Plus, C, C++, SQL, Java

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/ 2000, DB2, Teradata 13/12/V2R5

OLAP Tools: BusinessObjectsXIR2, OBIEE 11g/10g

SQL Tools: SQL Developer, TOAD, SQL*PLUS, SQL*Loader, CDC

Office Tools: MS Office, MS Project, Auto CAD, MS Visio.

O/S: Windows 95/ 98/NT/2000, XP/7, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr. ETL Informatica Developer

Responsibilities:

• Responsible for logical dimensional data model and use ETL skills to load the dimensional physical layer from various sources including SQL Server, Oracle, Flat file etc.
• Leading Informatica onsite-offshore team, coordinating with various group to understanding requirements, test code, migrate code and involved in production support.
• Successfully collaborated with business users to capture & define business requirements and contribute to defining the data warehouse architecture (data models, data analysis, data sourcing and data integrity)
• Analyzed source data for potential data quality issues and addressing these issues in ETL procedures.
• Developed technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Create High Level design, Mapping document, test case and review template.
• Create Slowly changing dimension type 1 and 2 to capture incremental data in DWH.
• Worked on Sql tunning using Explain Plan, Sql hints.
• Created deployment group and coordinated with operation team to move the code to prod.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc…
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Update the status and plan the releases through the scrum meetings.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.5, Oracle11g, SQL Server 2008 r2, SQL*Plus,IDQ, Windows, Erwin 7.5.

Confidential, Wellesley, MA

Sr. ETL Informatica Developer

Responsibilities:

• Leading Informatica onsite-offshore team, coordinating with various group to understanding requirements, test code, migrate code and involved in production support.
• Worked on complete data warehouse development life cycle from requirement specifications to delivering the test product.
• Involved in upgrade project from Informatica 8.6 to 9.5.
• Involved in creating upgradation plan, testing scripts, customizing connections, sessions, workflows, Java transformation for upgrade.
• Involved in Testing, Debugging, Validation and Performance Tuning of ETL Architecture, help develop optimum solutions for Informatica deliverables.
• Involved in some production support and update-exiting mapping.
• Design and develop ETL using CDC using Power Exchange 9.5 in Mainframe DB2 environment
• Experience in writing SQL, PL/SQL codes, stored procedures and packages.
• Used pmcmd to run workflows and Tidal to automate their schedules.
• Extracted data from flat files, XML and oracle database to load them in the central oracle 11g database. Worked on XML Parsor and XML generator.
• Used MQ Series and Webservices as Source and Target to receive and transmit data.
• Worked on data warehouses with sizes from 3-5 Terabytes
• Created reports inAnswersand embedded them inDashboardsaccording to the requirements.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Involved in Testing, Debugging, Validation and Performance Tuning of ETL Architecture, help develop optimum solutions for Informatica deliverables and Table portioning in DB level.
• Experience in writing SQL, PL/SQL codes, stored procedures and packages.
• Experience in full and partial push down optimization.
• Created Informatica PowerExchange Real-time registration and Datamap to read data in Real-time and batch mode. Used CDC capability of Informatica PowerExchange.
• Successfully moved the Sessions and Batches from the development to production environment.
• Create Slowly changing dimension type 1 and 2.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Translated the PL/SQL logic into Informatica mappings. Tuned Sql and PL/Sql code.
• Provided support for existing systems and worked on new development initiatives simultaneously.
• Actively participate in design and analysis sessions to ensure sound team decision-making
• Support system and user acceptance testing activities, including issue resolution.

Environment: Informatica PowerCenter 9.5/8.6, PowerExchange 9.5/8.6, Oracle Exadata/11g, SQL Server 2008 r2, PL/SQL, SQL*Plus, SQL*Loader, SQL Developer, OBIEE 11g, Windows, Linux, Erwin 7.5, Tidal.

Confidential, PA

ETL Informatica Developer

Responsibilities:

• Responsible for logical dimensional data model and use ETL skills to load the dimensional physical layer from various sources including DB2, SQL Server, Oracle, Flat file etc .
• Successfully collaborated with business users to capture & define business requirements and contribute to defining the data warehouse architecture (data models, data analysis, data sourcing and data integrity)
• Analyzed source data for potential data quality issues and addressing these issues in ETL procedures.
• Developed technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Design, develop, test, maintain and organize complex Informatica mappings, sessions and workflows.
• Complete technical documentation to ensure system is fully documented.
• Design and develop ETL using CDC using Power Exchange 9.1 in Mainframe DB2 environment.
• Created registration and data map for mainframe source.
• Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy.
• Worked with SAP data Services for Data Quality and Data Integration.
• Created Unix script for identifying CDC hanging workflows.
• Participate in Developing PL/SQL procedures, Korn Scripts to automate the process for daily and nightly Loads.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc…
• Worked with Mapping/Session/Worklet/Workflow variables and parameters, running Workflows in RHEL Unix shell script.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc…
• Created Informatica PowerExchange Restart token and enables recovery for all real-time sessions.
• Worked on data warehouses with sizes from 2-3 Terabytes.
• Worked on Teradata utilities like FLOAD, MLOAD and TPUMP to load data to stage and DWH.
• Worked on Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.

Environment: Informatica PowerCenter 9.1, PowerExchange 9.1, SQL Server 2008, Teradata 12 UNIX, Toad, Erwin 7, Linux, Harvest, Putty, DB2 Mainframe, FLOAD, MLOAD and TPUMP.

Confidential, Louisville, KY

ETL/Informatica developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed Type1 and Type2 mappings
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java,XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Converted MS SQL Server DTS Packages logic into Informatica mappings.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Scheduled Informatica workflows using AppWorx to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica PowerCenter 8.6, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, SQL, PL/SQL, T-SQL, SQL*Plus, TOAD, AppWorx, Erwin, Windows XP, Unix, Teradata v2r5, Oracle Applications 11i, Sun Solaris

Confidential, MA

Informatica Developer

Responsibilities:

• Involved in designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
• Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
• Designed the procedures for getting the data from many source systems to Data Warehouse.
• Developed mappings using Mapplets & various sources involving flat files, XML files and Relational tables.
• Extensively used ETL to load Flat files, XML files, Oracle and legacy data as sources and Oracle, Flat files as targets.
• Worked extensively with complex mappings using expressions, aggregators, filters, and lookups.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Involved in writing procedures, functions in PL/SQL.
• Designed and developed UNIX Shell scripts to report job failure alerts.
• Worked with Data Quality group to identify and research data quality issues.
• Coding, Debugging and sorting the time-to-time technical problems.
• Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Involved in Unit testing, System testing and UAT to check data consistency.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Involved in designing the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) in Oracle as per business requirements using ERWin.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Supporting daily loads and work with business users to handle rejected data.
• Used shell scripts to pre-process data in UNIX.
• Used version control to check in and checkout versions of objects.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data

Environment: Informatica PowerCenter 8.1, Oracle 10g, PL/SQL, DB2 8.0, Autosys, MS SQL Server, Oracle SQL developer, Flat Files, IP Switch, ERWIN 4.5, UNIX shell script, Sun Solaris

Confidential, Birmingham, Al

Informatica Developer

Responsibilities:

• Interacting with end users to get business Requirements and reporting needs. Created Business Requirement Document based on the client requirement and existing application.
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Designed, Developed and implemented of project from the Initial Life Phase until deployment into production.
• Informatica Power Center was used to develop ETL mappings and transformations, and to load data.
• Modified existing mappings in accordance with the Data Model.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created variables and parameters in the Mapping Designer.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Used Informatica Server manager to create Sessions and Workflows to run with the logic embedded in the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
• Involved in Documentation regarding the ETL process.
• Coordinated with offshore site in developing and deploying mappings.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created database tables, indexes in Oracle Database by implementing various business rules using appropriate constraints and database triggers.

Environment: Informatica PowerCenter 7.1/8.1, Oracle 9i, Erwin 4.1, SQL 2000, Flat Files, Windows XP.