SUMMARY

• Around 8+ years of combined Industry Experience as a Data Warehousing Expert and ETL Developer in designing, developing and implementing ETL processes for business applications.
• Diversified domain experience in banking domain, mortgage and healthcare.
• Worked on Informatica versions of informatica 9.5.1INFORMATICA 6.1.3, INFORMATICA 7.3.1, INFORMATICA 8.1.1 & INFORMATICA 9.0.1.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica PowerMart /PowerCenter with Oracle, DB2, Sql Server & Teradata.
• Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III).
• Involved in the Software Development Life Cycle (SDLC) with Analysis, Design, Development, Testing, Deployment and Maintenance
• Strong knowledge in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical, Physical Data Modeling and XML files.
• Worked with various Power Center/Power Mart components like Informatica Server and Client tools e.g.) Designer, Workflow Manager, and Repository Manager & Workflow Monitor.
• Developed shell scripts for invoking Informatica workflows.
• Expertise inData Profiling, Data Quality, and Data Governance.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Worked extensively on Teradata Utilities like MLOAD, TPUMP, FASTLOAD & FASTEXPORT and also Oracle Stored Procedures, Table Partitions SQL queries and loading data into Data Warehouse/Data Marts using Informatica.
• Involved in upgrading the product from PC 7.1.4 to PC 8.1.1, and also applied PC 8.1.1 SP1, SP2, SP3 and SP4on top of PC 8.1.1.
• Extensively used third party schedulers which include Tidal, AutoSys, Tivoli, Maximo, CA7 & Quality center etc.
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.”

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 6.x/7.x/8.x/9.x

Databases: Teradata V2R5 & V2R6, Oracle 8.i/9.i/10g, SQL Server 2010/2012, Access DB 2010/2007/2003.

Data Modeling Tools: Erwin 4.1.

Version Control Tools: Source safe & Sub Version

Languages: SQL, PL/SQL, C, C++, Java, XML, Cobol

Scripting Languages: Korn Shell, Bash shell scripting

Business Intelligence Tools: Had training on Cognos 7.x, Informatica Power Exchange

Scheduling tools: Autosys, Tidal and Tivoli

Special Tools: TOAD, Autosys, Tivoli, Maximo, CA7, HP Quality center, Changeman, NDM & File-Aid

Operating Systems: Windows, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Plano, Texas

ETL Developer

Responsibilities:

• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Created design documents, technical specifications for Mappings and Sessions based on user requirements.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Developed macros, queries and forms while generating reports in access db
• Developed Customized reports to support Client requests
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor
• Implemented sending of Post-Session Email once data is loaded.
• Used Debugger to test the mappings and fixed the bugs
• Worked on performance tunning of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Extensively used ETL to load data from Flat files, COBOL files, Mainframe VSAM files, flat files.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs

Environment: Informatica Power Center 9.5.1, Oracle 10g/9i, TOAD, SQL Server 2012, Access DB 2010, T-SQL, SQL and Business Objects, VB Script, DB2 v8.1, PL/SQL, UNIX, Windows XP, Erwin 4x, COBOL, UNIX Shell Scripts and DB2 Connect.

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Collaborated with Business analysts for understanding the requirements, 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 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.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed and Developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, 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.
• Involved Data migration from one environment to another environment using ETLInformaticatool, Data Extraction, Data Cleansing, Data Staging of operational sources.
• Developed complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Implemented Incremantal load logic based on workflow variables such as run id, last updated workflow start and end date
• Configured workflows with Email Task, which would send mail with session, log for Failure of a session and for Target Failed Rows.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning
• Solid experience in debugging and troubleshooting sessions using the Debugger and Workflow Monitor.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance
• 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 sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files.
• Scheduled Informatica workflows to run at regular intervals.
• AppliedData Governance rules(primary qualifier, class words and valid abbreviation in Table name and Column names)
• 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.
• Gain knowledge and understanding of business problems caused by Data Governance.
• 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 Power Center 9.5.1 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, XML, Oracle 11g, MS SQL Server 2008/2012, SQL,PL/SQL,T-SQL, Windows XP, Unix, Cognos, Tidal.

Confidential, Mclean, VA

ETL Developer

Responsibilities:

• Worked with different Informatica client Tools like Source Designer warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server.
• Created design documents, technical specifications for Mappings and Sessions based on user requirements.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Created Informatica maps using various transformations like Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router
• Used debugger to validate mappings and gain troubleshooting information about data and error conditions.
• Involved in creating shell scripts for various database objects related to the data model, which involve in creation of schema, tables, sequences, views, Materialized views, constraints, and indexes.
• Developed shell scripts to automate Session (pre-session and post- session )tasks.
• Sound knowledge in migrating mappings from development to production.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Contacted Informatica tech support for resolving the issues we are not familiar with.
• Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Worked with pre and post sessions and extracted data from Transaction System into Staging Area.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Attendantarchitecture meeting and data governance meetingto understand the project.
• Developed and maintained technical documentation for Informatica servers and repositories.
• Monitored the existing ETL jobs and takes necessary actions as per the errors.
• Analyzed performance measures to fit the reporting needs of the company.
• Extensively used ETL to load data from Flat files, COBOL files, Mainframe VSAM files, flat files.

Environment: Informatica Power Center 8.6, Oracle 10g/9i, TOAD, and Business Objects, DB2 v8.1, PL/SQL, UNIX, Windows XP, Erwin 4x, XML, Web services, UNIX Shell Scripts and DB2 Connect.

Confidential, San Jose, CA

Sr. ETL/Informatica Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Used Informatica Power Center 8.5 to extract, transform and load data from different Operational data sources like Oracle as an ODS, DB2 and flat file.
• Coordinated with source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
• Worked with DB2, SQL Server, business users and developers to develop the Scalability and performance tune existing batch to handle large volumes.
• Extracted data from DB2, Mainframes, EXCEL files and Relational databases and loaded into Oracle database and into XML files using Informatica.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner Transformation, UpdateStrategy, Lookup transformation, Rank transformation, Expressions, Aggregator, and Sequence Generator.
• Developed mappings with Transformations and Mapplets confirming to the business rules.
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email.
• Data Enhancements and deliverables done to QA Environment Successfully.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Designed reusable transformations and Mapplets to be re used with various mappings.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints.
• Performed Unit, Integration and Regression testing and preparing Test Cases for the same.
• Defined roles and responsibilities within the team and reviewing deliverables.
• Coordinated work with offshore team

Environment: Informatica Power Center8.5 (Repository Manager, Designer Tools like Source Designer, Warehouse Designer, Mapping and Mapplet Designer, XML, Web services, Workflow Manager, Workflow Monitor) DB2 8.0, Oracle 10g, UNIX Shell Scripting, Autosys.

Confidential, Milpitas, CA

ETL/Informatica Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules in building the Datamarts/Data Warehouse using Kimball Methodologies.
• Interacted with users, documented user requirements, and translated requirements into system solutions and designed ETL processes and job schedule plans.
• Developed complex Mappings to load data from external sources like Flat Files, XML, Oracle, SQL Server, DB2 UDB using Informatica PowerCenter 7.1.4/6.2 designer to the Staging and Data Warehouse database.
• Created Mappings using transformations like Source Qualifier, XML Source Qualifier, Expression, Sorter, Aggregator, Filter, Lookup, Update Strategy, Sequence Generator, Normalizer, Stored Procedure, Joiner, Rank, Router and Transaction Control transformations.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Used partitioning in Sessions to improve the performance of the database load time.
• Created Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Tested the existing mappings and redesigned the mappings to improve the performance and the efficiency of the design logic.
• Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporting.
• Performed unit test, string test, parallel test and user testing by developing test cases and test scripts.
• Performed trouble-shooting on the impending issues in identifying the problem, provided appropriate solution for the production problem.

Environment: Informatica PowerCenter 7.1.4/6.2, Oracle 9i, PL/SQL, SQL Server 2000, DB2 UDB, Teradata, MS Access, Autosys, MS Visio, ERWIN, XML, TOAD, WinSQL, XML, Windows XP, Unix, Shell Scripting, Business Objects 6.2.

Confidential, Indianapolis, IN

ETL Developer

Responsibilities:

• Documented data conversion, integration, load and verification specifications.
• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager.
• Performed data analysis based on the source systems and existing OLTP database systems.
• Interacted with business analysts, data architects, application developers to develop a data model
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed data transfer strategy from various legacy data sources like operational and validate data models defined in the ER diagram.
• Involved in Performance Tuning of sources, targets, mappings and sessions
• Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Performed unit testing to validate mappings and populate the database.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.

Environment: Informatica Power Center 6.2, Oracle 9i, SQL, PL/SQL, XML, UNIX Shell Scripts, Windows 2000

Confidential, NJ

DW ETL Informatica Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering and project coordination.
• Design and Development of ETL routines using Informatica Power Center 8.1. Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Maplets, connected and unconnected stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Logical and Physical Data Modeling (relational and multi-dimensional) using ERWIN and used Power Plug to forward engineer to Informatica Repository.
• Performance Monitoring and tuning of SQL using Explain Plans and Oracle Hints and tuning of Informatica mappings using SQL overrides and source filters and managing cache file allocations and sizes.
• Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Developed and tested all the informatica Data mappings, sessions and workflows involving several Tasks.
• Implementation of stored procedures and packages utilizing PL/SQL for the enhancements of the existing application level data warehouse.

Environment: Informatica Power Center 8.1, XML, Oracle 10g, Cognos, UNIX (HP-UX 11.x), Sun Solaris (2.6), Windows 2K, UNIX Shell Scripts, PL/SQL, DB2 Connect, TOAD.

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Worked with ETL tool Informatica to create mappings and workflows and transformations.
• Configured Repository Manager, created folders and managed objects in repository manager for Informatica.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Used Filter, Router, Aggregator, Lookup, Expression, and Update the Mapping Strategy transformations whenever required in the mapping.
• Involved in creation of sessions and scheduling of sessions.
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.
• Improved the performance of long running jobs by updating the SQL statements and creating indexes.

Environment: Oracle8i, Informatica 6.1(Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow designer, workflow Monitor) windows 2003, Oracle 8i, SQL/PL SQL.