Sr.Informatica Developer

Summary

• Developed complex Mappings, used transformations such as lookups, Router, Filter, Expression, Aggregator, Joiner, and Update Strategy.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center in Extraction/Transformation/Loading of data and developed ETL worklets, workflows, and ETL mappings using Version Control and also monitoring the Production Environment.
• Over 8 years of experience in Information Technology with a strong background in Database development and Data warehousing and over 6 years ETL process using Informatica Power Center 9.x/8.x/7.x.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Business Intelligence experience using Business Objects 6.5/4.5 .
• Familiar with UNIX Shell Scripting, PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS-SQL Server 2000/2005 and optimizing the SQL to improve the performance.
• Strong understanding of Performance tuning in Informatica and Databases. Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, and experienced in loading data into Data Warehouse/Data Marts using Informatica.
• Worked with wide variety of sources like Relational Databases, Flat Files, VSAM, and MQ Series and Scheduling tools like Control-M and Informatica Scheduler.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities: as an overview

• Designed the ETL Architecture for the Data warehouse.
• Creating cubes for to fill in the Reports for the User.
• Involved in building complex ETL.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created E-mail notifications tasks using post-session scripts.
• Wrote SQL, PLSQL for implementing business rules and transformations.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency
• Involved in Unit, Integration, system, and performance testing levels.
• Maintaining the ETL for the whole team by Designing, developing, testing and deploying.
• Backing up the Databases and restoring in SQL 2005.
• Worked on SSAS 2000.
• Extensively working on SSAS 2005 and scheduling using SSIS and SQL Server Agent.
• Monitoring directories, resolving space issues.
• Scheduled Stored Procedures for the Process improvement.
• Maintaining the FTP scripts involved in huge file movement.
• Provided Knowledge Transfer and regularly communicated with Daily meetings in helping the offshore team to build and maintain the BO reports.

Environment: Informatica Power Center 9.1, Oracle 11.g, SQL Server 2005, Windows 2003, AIX 3.5, Analysis Services 2005, Microsoft Front Page, SharePoint Designer, Lite Speed, FTP Utilities

Confidential

Responsibilities:

• Designed the ETL Architecture for the Data warehouse.
• Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Created and worked with Netezza External Tables.
• Worked with NZSQL to run the scripts from UNIX and Netezza SQL Analytical functions to generate summarized reports.
• Worked on writing SQL over Netezza for testing the loads and recon process.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions run with the logic embedded in the mappings.
• Scheduled and Maintained ETL/SQL/PLSQL/FTP jobs and maintained using Cybermation. Maintained Processes with notifications on Production support and exception handling.
• Created plans for data subset and monitored data subset for different phases of a plan.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Maintaining the FTP scripts involved in huge file movement.
• Managed a team offshore with communicating the requirements and regular updates with other teams' onsite.

Environment: Informatica Power Center 9/8.1,ILM Workbench, Oracle 10.g, SQL Server 2005, Netezza, Windows 2003, AIX 3.5, Analysis Services 2005, Cybermation, SharePoint Designer, Lite Speed, FTP Utilities

Confidential

Informatica Designer/Developer

The firm is active in the sectors of asset management, insurance, investor services and capital markets. The project involved in creating a warehouse for the Credit applications and the Asset management through which reports are generated.

Responsibilities:

• Involved in deriving Technical Specifications based on Functional Specifications.
• Worked on ILM Workbench, Created data masking rules with different data masking techniques.
• Created and assigned data masking policies and Rules and various types of rules. Simple, Complex, and rule mapplets .
• Described and Managed Data Masking Components.
• Working extensively on Lookup, Router, Filter, Aggregator, Expression, Normalizer, Stored procedure, and Update Strategy Transformations.
• Designed Error Handling Strategy and developed Mappings to track the errors.
• Developed code to load the data from Flat File to Warehouse through Stage and ODS.
• Dealt with mappings that incorporate Incremental loads, Constraint Based Loading and Change Data Capture
• Designed the Workflow for the ODS load following the load Dependencies.
• Worked with Power Center Versioning Check-in, Check-out , Querying to retrieve specific objects, maintaining the history of objects.
• Migrating objects between different Environments using XML Export/Import using Repository Manager .
• Created User Defined Functions in Database for Data manipulation and extraction.
• Involved in end user support and bug fixes and tuning the code for better performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Worked on Reporting Services of SQL Server 2005 to generate reports for Asset Management.
• Coordinated with the DBA for Creating Linked servers connecting to the Warehouse and created Server Objects based on the connected servers.
• Designed the Reconciliation process and created scripts to reconcile the ODS and provided the source system with the scripts that provides with the data that helps the reconciliation process.
• Created Test Cases and generated reports based on the test cases to check the Data quality.
• Responsible for monitoring the sessions that are running, scheduled, completed and failed.
• Environment: Informatica Power Center 8.1/Power Exchange, Oracle 10g, SQL Server 2005, Sybase ASE, Aqua Data Studio 6.0, Windows 2003.

Confidential

ETL Informatica Developer

Responsibilities:

• Worked with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions by creating Technical Specifications for the ETL from the Functional Specifications.
• Working on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code.
• Developed reusable mapplets to include the Audit rules Byte count check .
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Designed and created Database and Informatica objects for Flat File data manipulations.
• Unit and Integration Testing of Informatica source and Target Data.
• Involved in analyzing the year end process and managed the loads that have year end aggregations.
• Creating stored procedures and sequences to insert key into the database table.
• Involved in writing shell scripts for file transfers, file renaming and few other database scripts to be executed from UNIX.
• Scheduled Informatica jobs and managed the loading process using UC4.
• Provided support for the Nightly jobs.
• Coordinated with offshore team with Development/testing/Maintenance of code.
• Environment: Informatica Power center 7.1.3, Oracle 10g, Toad 8.0, Linux 2.4, Flat Files, MQ Series, UC4, and Clear Case.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in Performance tuning of existing Mappings.
• Using Hyperion Explorer to generate test case scripts validating the functional data.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment with a paging system .
• Creating stored procedures, sequences and triggers to insert key into the database table.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table, and worked mostly on constraint based loading.
• Involved in modifying existing Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica source and Target Data.
• Developing mappings to extract the Data from multiple Flat Files and loading them into staging through CDM database.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Populated data into Teradata tables by using Fast Load utility.
• Environment: Informatica Power center 7.1.3, Oracle 9i, Toad 8.6, Teradata V2R6, Unix AIX 5.2, Ultra edit 10.20, Flat Files, XML, Hyperion 8.3.

Confidential

Pleasanton CA as ETL Developer

Responsibilities:

• Developed and maintained ETL Data Extract, Transformation and Loading mappings to extract the Data from multiple source systems like Oracle, and Flat Files and load into Warehouse through STAGE and ODS.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Worked on UNIX machine to connect to the Oracle database and run PL/SQL scripts.
• Tuned SQL queries for better performance.
• Optimized the mappings by changing the logic to reduce run time.
• Developed the mappings to extract the data on incremental load basis.
• Developed reusable transformations for Date Conversion.

Environment: Informatica Power Center 7.1.1, Oracle 9i, Toad, ERWIN 4.0, Unix-AIX4.3, Test Director 8.0, VSAM, Business Objects 6.5.

Confidential

VA as ETL Developer

Responsibilities:

• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica Power Center.
• Involved in developing source to target mappings and scheduling Informatica sessions
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc.,.
• Tuned Informatica Mappings and Sessions for optimum performance
• Worked in writing UNIX scripts, SQL statements and interacted with development and production teams to expedite the process.

Environment: Informatica Power Center 7.1, DB2, Sybase, Windows server 2003, SQL, PL/SQL, XML, Business Objects 6.5.