SUMMARY

• 8+ years of experience in Data Warehouse applications and involved in Design, Development and Implementation of Data warehouses and Data marts as an ETL Developer. Expertise in Designing & Developing complex Extract, Transform and Load (ETL) applications using Informatica Power Center.
• Experienced with Informatica Data Quality (IDQ) tool for Data Analysis / Data Profiling and Data Governance.
• Extensively worked on Informatica Designer Components - Source Analyzer, Power Center Designer, Transformation Developer, Mapplet and Mapping Designer.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Expertise in Ralph Kimball's Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly changing Dimensions (Type1, Type2, and Type3) and Surrogate Keys and Data warehouse concepts.
• Experience in CDC and daily load strategies of Data warehouse and Data marts.
• Experience in integration of various data sources like Oracle, Teradata, SQL server and Flat Files into staging area. Also hands on experience in Database querying, data manipulation using SQL and PL/SQL in Oracle and Teradata.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Installed and Configured DAC (Data Warehouse Administration Console) to manage ETL process.
• Hands on experience in installation, administration and maintenance of DAC and Informatica.
• Experience in Audit, Balance checks and Error handling techniques.
• Hands-on experience in Performance tuning of Informatica ETL Queries.
• Implemented complex business rules in Informatica by creating Reusable Transformations, and robust mappings/mapplets. Experience in loading data, troubleshooting, Debugging and tuning of Informatica mappings.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner, Rank, Update Strategy, Stored procedure, XML Source qualifier, Input and Output transformations.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experience in writing UNIX shell scripts and handling files with Unix scripts.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes and Shell scripting.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• 24/7 Support and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
• Have strong interpersonal skills along with proficient written and verbal skills. Overall strength lies in precise translation of business requirements into technical documents. Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Application Tools: Informatica 9.x/8.x,Informatcia Data Quality(IDQ), DAC 11g/10g, OBIA/BI APPS 7.9.6.x/7.9.5, TOAD, SQL*Loader, SQL Developer.

Operating Systems: Windows XP/7, UNIX, Linux.

Languages: SQL, PL/SQL, C, C++, Java, HTML, XML.

Scripting Languages: Unix Shell scripts.

RDBMS: Oracle 9i/10g/11g, Teradata, SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, California

ETL Informatica Lead/Developer

Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL) using Informatica.
• Using IDQ Informatica developer tool, generated mappings, mapplets performed column profiling, and discovering the potential joins between two columns in data source.
• Involved in a Data Warehousing project, which consolidated the company’s data come from different operational source and then data is transformed and loaded into a centralized data warehouse which is used for Executive Reporting Dashboards.
• Designed and developed complex Informatica mappings including Type-II slowly changing dimensions.
• Extensively worked on heterogeneous data sources like flat files, SQL server, Hyperion, Teradata and Oracle.
• Created type 2 mappings and implemented CDC method to capture updates.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Used Metadata Manager to find the dependencies of all repositories and traced data lineage.
• Modified out of the box SDE,SIL mappings of financial analytics and customized them to Extract the data from Oracle EBS into Data Warehouse.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Used debugger in debugging some critical mapping by setting breakpoints and trouble shot the issues by checking sessions and workflow logs Created and maintained various project related documents like high level design documents.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Deployed Informatica workflows to the DAC, created dependency and dependent hierarchical tasks and streamlined the Execution Plans with their respective tasks in DAC.
• Involved in adding all the newly developed Dimension, General, Aggregate and Fact tables in to DAC and creation of new Subject Areas.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Implemented LDAP authentication and configured application roles for authorization.

Environment: Informatica Power Center 9.6.1, Informatica IDQ, OBIA/BI APPS 7.9.6.4, DAC 11g, SQL, Microsoft SQL Server 2008,Teradata and UNIX.

Confidential, New Jersey

ETL Informatica Developer

Responsibilities:

• Worked on complete Software Development Life Cycle (SDLC), from gathering requirements to deployment.
• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Worked with data quality tooling to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets) with various transformations.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Redesigned some of the mappings and mapplets in the system to meet new functionality.
• Extensively worked on Tuning (Both Database and Informatica side) and thereby improving the load time.
• Implemented Financial Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Granting access to users and maintain security by using database authentication and authorization.
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.
• Automated process of migrating Data Definitions and Templates from instance to instance.
• Scheduled sessions and workflows using Informatica scheduler and pmcmd command.
• Extensively worked with the Users for the successful completion of the UAT.
• Resolved open issues with production system.

Environment: OBIA/BI APPS 7.9.6.4, DAC 10g, Informatica Power Center 9.0.1, TOAD, SQL, PLSQL, Microsoft SQL server 2008, SQL* Loader.

Confidential, Virginia Beach, Virginia

Informatica Developer

Responsibilities:

• Gathered requirements from the client for Confidential analysis, translated them into technical design documents and worked with team members in making recommendations to close the Confidential .
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.
• Extensively used Informatica Power Center Designer to create source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Extensively used Informatica power center to load data from flat files into the target tables.
• Extensively used transformations like lookups (connected and unconnected), Update Strategy, Joiner, Router, Sorter, Aggregator, Expression, Rank, Sequence Generator and others.
• Extensively worked on Mapping Variables, Mapping Parameters.
• Developed very complex mappings per business requirements.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Involved in Production support.
• Extensively worked on heterogeneous data sources, like flat files, SQL server, Teradata and Oracle.
• Used PL/SQL, creating Stored Procedures to delete existing data from the tables before loading.
• Thorough test cases are created to test each and every low level requirement in project
• Extensively developed Unix shell scripts to run SQL scripts and Informatica work flows from Unix server
• Scheduled sessions and workflows using Informatica scheduler and pmcmd command.
• Actively involved in Customer Interaction, gathering information related to enhancements and executed the same.
• Worked on production support and provided bug fixes, Incident support and Root cause analysis wherever applicable
• Analyze and understand the requirement documents, and prepare design documents
• Verified and tested ETL mappings using Informatica Power Center Designer.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

Environment: Informatica Power Center 8.6, DAC 10.1.3.4.1 , BI Apps 7.9.6.2, Oracle 11g/10g, PL/SQL, SQL, TOAD, SQL*Loader.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
• Used SQL * Loader for Data Conversions and to load the data from flat files into Oracle tables.
• Involved in Agile development, project planning and release planning activities
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of ETL mappings.
• Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
• Creating data mappings to extract data from different source Databases, transform the data using ETL Informatica Transformations then load to Oracle data warehouse.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Responsible for Trouble shooting, Production support, Performance tuning and Batch monitoring activity.
• Provide Production Support, create Production Run book and Operations Manuals, address and resolve critical production issues.
• Created a mapping document that outlines the sources mapped to the targets
• Extensively created workflows with the Event Wait task to specify when the workflow should load the tables.
• Have ensured that test cases are designed and implemented to test each and every low level requirement in project.
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting sales data.
• Scheduled Workflows and Session tasks comprising of different mappings in order to load data into target database and fine-tuning ETL Mappings and Sessions. .

Environment: Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1 , Toad, Linux.

Confidential, California

Informatica Developer

Responsibilities:

• Created various mappings using Router, Joiner, Expression, Update Strategy, Lookup transformation, Stored procedure and other transformations.
• Used Workflow Manager to schedule and monitor different sessions of loading.
• Used Informatica to extract, transform and load data from multiple input sources like XML files, Flat files, and ORACLE and CSV files to Oracle 10g.
• Created different target definitions using warehouse designer of Informatica Power Center.
• Created different transformations for loading the data into Oracle database.
• Responsible for querying data from different database tables as per the requirement.
• Responsible for creation of standard Filters, Calculations, prompts and conditions, Formulation of Join Strategy and adding columns in catalog after they are added in already existing tables.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Attended meetings to finalize strategies for handling various concepts like Error Handling and Slowly changing dimension
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed UNIX Shell scripts for data extraction and file transfers. Assist operation support team for transactional data loads.
• Performed Unit and System Testing of developed mappings.
• Documented program development, logic, coding, testing, changes and corrections.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.

Environment: Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 7.9.6, Toad, Linux.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center Designer to create source and target definitions, mappings, mapplets, transformations, re-usable transformations
• Extensively used Informatica power center to load data from flat files into the target tables.
• Extensively used transformations like lookups (connected and unconnected), Update Strategy, Joiner, Router, Sorter, Aggregator, Expression, Rank, Sequence Generator and others.
• Extensively worked on Mapping Variables, Mapping Parameters.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Involved in Production support.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions from heterogeneous sources and determining the hierarchies in dimensions.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Worked extensively on bug fixing on Mappings, and performing Unit and Integration Testing.
• Defined, captured metadata and rules associated with ETL process.

Environment: Oracle BI Apps 7.9.4, Informatica Power Center 7.1.4, Oracle 9i, SQL Developer, Linux.