SUMMARY

• 7+ years of experience in Information Technology with a strong background in Data warehousing and Data Extraction using Informatica Power Center 9.x/8.x/7.x as ETL Tool.
• 2 year experience as SQL developer with good knowledge of Oracle SQL/PL/SQL.
• Strong experience in ETL and Data Warehousing using Informatica Power Center clients Designer, Repository Manager, Workflow Manger and Workflow Monitor.
• Extensively worked on Informatica Designer Components such as Source Analyzer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools such as Task Developer, Workflows &Worklet Designer.
• Experience in creating Re - Usable Transformations, Mapplets, and Mappings.
• Good Experience on Managing, Scheduling, and Monitoring of Informatica Workflows.
• Extensively worked on Informatica Power Center Transformations but not limited to such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Experience in performing ETL procedures to load data from heterogeneous sources like Oracle 9i/10g, DB2, Flat Files, XML Files, Teradata, MS SQL Server and MS Access into Data Warehouse using Informatica Power Center.
• Experience in Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
• Have good knowledge of IDQ, Teradata.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience working in Oracle8i/9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Strong knowledge of Mapping Variables and Parameters to perform Incremental Load, SQL Transformation using Query and Script mode.
• Excellent in Data Analysis, Data Requirement Analysis and Data Mapping for ETL Process.
• Experience in identifying Performance Bottlenecks and Tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Strong in Data Warehousing methodologies of Star /Snow Flake.
• Experience in troubleshooting the mappings by using Debugger.
• Experienced in Installation, Configuration, and Administration ofInformatica Power Centeron Client/Server environment.
• Good working knowledge of UNIX shell scripting.
• Good practice of working under Agile/Scrum methodologies.
• Excellent skill set of analytical problem solving, documentation, communication and presentation.
• Outstanding interpersonal skills with proficiency to work in a team as well as self.
• Creative, adaptive and result-oriented professional with avidness to learn new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter9.x/8.x/7.x/6.x/5.x (Source Analyzer, Repository Manager, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Warehouse Designer and Informatica Server), Data Cleansing, Data Quality, Web services.

Operating Systems: Microsoft Windows 7/Vista/XP/2000/NT, UNIX

Languages: SQL, PL/SQL, C, C++, Java, UNIX Shell Scripting

Data Bases: Oracle 8i/9i/10g RAC, SQL Server,Teradata

Reporting Tools: Business Objects

Process/Technologies: SDLC, Waterfall, Agile, Scrum

Tools: /Utilities SQL Navigator 6.7, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Sr ETL Informatica Developer

Responsibilities:

• Understand the project requirements given by the Client, Co-ordinate with offshore team to translate technical specs toInformaticawith Business rules.
• Active interaction with business team for gathering the business requirements.
• Excellent understanding of Informatica PowerCenter Client- Repository, Designer, Workflow and Monitor
• Designing end to end the ETL mapping using the Teradata as source and target.
• Responsible for understanding the current process of Informatica flow and migrate the Oracle data marts to Teradata data warehouse.
• Worked on data extraction from multiple sources, used various transformations and external loader to load the data into teradata warehouse using Informatica
• Work with Unconnected as well as Connected Look Ups.
• Developed efficient PL/SQL query for Source Qualifier using When-Case, Inner Join, Outer Join, Complex Conditions
• Followed complete SDLC process and worked under Agile methodology.
• Data Validation and Cleansing for Performance Tuning of the ETL workflow.
• Implemented the FTP process for flat files as sources and target
• Efficient detecting and fixing the ETL defects within timeframe and deploying the ETL jobs in various testing environment.
• Designed the UNIX scripts for automatically triggering the ETL jobs.
• Troubleshoot the process or production issues and resolve the problems
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Effectively coordinating with business users to complete acceptance testing within timelines and obtain sign offs.
• Working on data warehousing concepts/design with good understanding of the ETL and reporting processes
• Collaborate with team members to resolve issues to assure the successful delivery of high quality ETL Code.

Environment: Informatica Power Center 9.5, Fixed Width and Delimited Flat Files, XML Files, SQL Server2005/ 2008, Windows, Teradata.

Confidential, Dublin, OH

ETL Informatica Developer

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica Power Center to extract, transform and load data from various source systems to staging and target Data warehouse.
• Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in batch process.
• Created fact and dimension tables based on specifications provided by managers using Star Schema.
• Designed and created complex source to target mappings using various transformations like Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Involved in Performance Tuning of mappings, sessions and SQL queries.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail of the workflow.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Written UNIX scripts to transfer the data from operational data sources to the target data warehouse.
• Developed PL/SQL procedures, functions, triggers for processing business logic in the database. Wrote optimized SQL queries for data retrieval from the source database.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shells scripts.
• Monitoring the session logs to check the progress of the data load.
• Working with an Agile, Scrum methodologies to ensure the delivery of high quality work.
• Involved in different Team review meetings.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, windows XP.

Confidential, Springfield, MA

ETL Developer

Responsibilities:

• Involved in Production Support, analyzing issues and resolving them.
• Involved in Derivatives Accounting Industry and exposed to various financial instruments.
• Used informatica for various purposes for data import from accounting systems to ODS, and ODS out to other processes and feed.
• For price import and exports to collateral management, pricing, treasury control, SAP GL feed etc.
• Developing, editing and migrating DOS batch files for automation of various processes in the system.
• Developing, testing and migrating code to the production environment of the ETL Designs through Informatica power center.
• Createdstored procedure in Oracle to process accounting and used MS SQL for various lookup tables and stored procedures to process the lookup information like issuer info, pricing used in informatica.
• Well versed in Database Models and various Schema Designs.
• Used UNIX shell as per the ad-hoc requirements.
• Involved in Knowledge Transfer to new team members, as well as reverse Knowledge Transfer to clients.
• Update documentation regarding Prod Support cases and resolutions.
• Co-ordinate with off-shore team for Prod Support along with any Informatica enhancements.

Environment: Informatica Power Center 9.1, Unix scripting, MS SQL server 2005, Oracle 11g, PL/SQL (Stored Procedures).

Confidential

ETL/Informatica Developer

Responsibilities:

• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• 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 Data warehouse.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Responsible for the data management and data cleansing activities using Informatica data quality (IDQ).
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used the sandbox for testing to ensure minimum code coverage for the application to be migrated to production.
• Improved performance testing in Mapping and the session level.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.
• Documented Data Mappings/ Transformations as per the business requirement.

Confidential

ETL Developer

Responsibilities:

• Identifying integrity constraints for tables.
• Tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in Implementation and Testing phases of the system
• Worked with different Sources such as DB2, SQL Server and Excel, Flat.
• Used Informatica to extract data into Data Warehouse.
• Developed Re-Usable Transformations and Re-Usable Mapplets.

Environment: Informatica 8.1, Business Objects 6.5, Oracle 10G, Windows NT Server.

Confidential

Database Developer/ Jr. ETL Developer

Responsibilities:

• Involved in gathering business requirements and technical aspects for development.
• Involved in deciding the architecture strategy and design physical and logical models of the data warehouse as well two independent data marts.
• Scheduling, monitoring, coding and testing of the custom Pl*SQL modules to load data into the data warehouse from the legacy systems.
• Extensively used all the features of informatica 6.x and 7.x including designer, workflow manager and repository manager, workflow monitor.
• Interpreted logical and physical data models for business user to determine common data definitions and establish referential integrity of the system.
• Worked with mapping user expressions, aggregators, filters, lookup, update stratergy and stored procedure transformations.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Partitioned sources to improve session performance
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.

Environment: Informatica Power Center 6.1, Oracle7.0, SQL, PL/SQL, TOAD, Oracle, Designer, Business Objects.