Professional Summary:

• 7 years of IT experience in Analysis, Design and Development of various software applications and implementation of Business Intelligence Solutions in Data Warehousing using ETL and Reporting with various databases on Windows and UNIX operating systems.
• Strong experience in Data Warehousing Data Integration and Data Conversion Projects with ETL experience using Informatica Power Center 9x/8x/7x.
• Highly proficient in the integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i,MS SQL Server,DB2,COBOL Files and Flat File.
• In-depth knowledge of Data Warehousing concepts with emphasis on Project Management, ETL, Software Development Life Cycle SDLC including requirement analysis, design, development, testing, implementation support.
• Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
• Developed complex mappings in Informatica using various transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected Unconnected, Sequence Generator, Filter, Sorter, Stored Procedure transformation etc.
• Developed slowly changing dimension SCD mappings using type-I, type-II, and type-III methods.
• Experience in developing Reusable components for using them across the projects.
• Worked extensively with Dimensional modeling, Data migration and skilled in Data Modeling using Star Schema and Snowflake Schema.
• Expertise on Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Expertise on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process.
• Experience in working with Informatica Power exchange for Mainframe Sources.
• Strong Data Analysis and Data Profiling background using Informatica Analyst, Informatica Data Explorer IDE and Informatica Data Quality IDQ .
• Experience in working with Standardizer, Parser, Match, and Merge Consolidation Transformations using IDQ. Worked with SQL/PL-SQL to write Complex SQL queries, Stored Procedures, Triggers, Functions PL/SQL packages.
• Experience in writing UNIX shell scripts.
• Expertise in implementation of OBIEE Applications including Informatica, DAC and OBIEE platform.
• Having good knowledge on reporting tools like Cognos and Business objects.
• Having Knowledge on Informatica Master Data Management MDM .
• Having knowledge on different MDM tables, delta detection, defining trust levels, validation rules, match and merge setup, Queries and packages, Batch Viewer Batch Groups.
• Effective Team Player with strong Logical and Analytical Reasoning Skills Excellent Communication with good Listening, Presentation and Intrapersonal Skills.

Technical Skills:

Professional Experience:

Confidential

Sr. Informatica Consultant

Responsibilities:

• Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.
• Translate customer requirements into formal requirements and design documents.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Written Informatica mapping for dropping and recreating the indexes of database tables.
• Development of address cleansing Mapplet and mapping using First logic plug-in.
• Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources oracle, Netezza, Teradata, fixed width and delimited flat files to ORACLE using Informatica Power Center.
• Worked on Scheduling workflows and sessions using Informatica scheduler and have implemented decision task and email task for tracking the successful completion
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Extensively used T-SQL in creating Procedure.
• Implemented complex mapping such as SLOWLY CHANGING DIMENSIONS Type II .
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Worked with Informatica Data Quality 8.6.1 IDQ toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Created UNIX scripts for parsing and modifying data and experience in using AUTOSYS job scheduler for automation of UNIX shell scripts and batch scheduling.
• Created Materialized views for summary tables for better query performance.
• Creating Test cases for Unit Test, System Integration Test.
• Created tables, table's relationships, indexes, keys.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Created UNIX shell scripts and called as pre session and post session commands.
• Developed the multidimensional reports in Business Objects by translating the business validations. Generated different kinds of charts in Business Objects.
• Created Master Detail, Cross Tab reports to view the data in analyzed way.
• Facilitate end-user procedures development.

Environment: Informatica Power Center 9.1/8.6.1 Power Center Designer, workflow manager, workflow monitor , IDQ, Oracle 11g, DB2, TERADATA, NETEZZA, SQLServer'08, UNIX, TOAD, AUTOSYS, COGNOS.

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in gathering requirements from end users and involved in modifying data according to the requirement.
• Worked with the end users to identify, create, and deliver reports according to requirements.
• Interacted with business users and source system OLTP IT teams to define, agree and document incoming data mapping specifications.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD,SQL PLUS and PL/SQL.
• Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.
• According to the business logic created various transformations like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Created Data models for data warehouse development.
• Performed installation, configuration, as well as implementation of OBIEE.
• Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Worked with UNIX scripts for automation of ETL Jobs using Autosys Scheduler and Involved in migration/conversion of ETL processes from development to production environment.
• Working experience using Push Down Optimization.
• Executed performance tuning of Informatica components for daily and monthly incremental loading.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed Informatica parameter files to filter the daily source data.
• Created Oracle Stored Procedure to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Used various Oracle Index techniques like B tree, bitmap index to improve the query performance and created scripts to update the table statistics for better explain plan.

Environment: Informatica Power Center 9.1, Oracle 10g, OBIEE, Flat Files, DB2, SQL Server 2008, TOAD 10.5, MS Visio, Netezza, SAP Business Objects BI4.0, Cognos, SQL, PL/SQL.

Confidential

Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various mappings mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner etc. Also developed Error Processing to capture the error records and loads them into Mesg Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Fine-tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Maintained effective communication with non-technical client personal and handled the change requests.

Environment: Informatica Power Center 8.6.1, Oracle 10g , SQL Server 2008, Flat Files, CS files, PL/SQL Stored Procedure, Trigger, Packages , Erwin 6.1, Microsoft Visual Studio Team System/Team Foundation Server TFS , Tidal, MS Visio, SQL Developer, iSQL Plus, TOAD, Windows 2007, UNIX AIX 5.3.

Confidential

Informatica Developer

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading data into data warehouse ETL .
• Created and developed a series of mappings for handling different cases of input data in the same source table. Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results. Used parameters and variables in mappings.
• Involved in Data Extraction from Oracle, Flat files using Informatica.
• Prepared ETL flow of data from Staging to Data Mart.
• Developed mappings to populate Reference data tables which provide codes and descriptions for dimension tables in the database.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner and Update Strategy for developing mappings involving complex business logics.
• Developed shell scripts, PL/SQL procedures for creating/dropping of table and indexes of performance for pre and post session management.
• Attending the technical review meetings.
• Involved in unit testing and system testing and preparing Unit Test Plan UTP and System Test Plan STP documents.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed using debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batch Jobs/Worklets and Workflows.
• Developed various reusable transformations using the Transformation Developer in the Informatica Power Center Designer.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Extensive use of SQL commands with TOAD environment to create Target tables.
• Tuned Performance of Informatica session for large Data Files by increasing block size, data cache size, Sequence buffer length and target based commit interval.

Environment: Informatica Power Center 8.1, Oracle 10g, DB2, Sybase, TOAD, SQL, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in translating business requirements to integrate into existing datamart design.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensively used ETL to load data from different relational databases, XML and flat files.
• Used ETL, Informatica Repository Manager to create repositories and users and to give permissions to users.
• Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
• Handle the Migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings for Optimum Performance.
• Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting the jobs and work flows.
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Created various UNIX shell scripts for Job automation of data loads.
• Worked on all phases of SDLC from requirement, design, development and testing.
• Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs.
• Extensively involved in the analysis and tuning of the application code SQL .Involved in unit testing and system integration testing and preparing Unit Test Plan UTP and System Test Plan STP documents.
• Worked on Change Requests CR while integration testing and UAT are in progress.

Environment: Informatica Power Center 8.1, Business Objects 6.5.1, Oracle 9i, SQL Plus, Toad, Windows 2000, SQL Server 2000, PL/SQL, UNIX, AUTOSYS, Erwin 6.1.

Confidential

Jr. ETL Developer

Responsibilities:

• Trouble shooting mappings during data loading into all testing Schemas.
• Developed Informatica mappings based on business requirements using various transformations Dynamic Lookup, connected and unconnected lookups, Filter, Stored procedure, Update Strategy, Joiner, Aggregator, Expression, Router, Sequence generator, Normalizer in the mappings.
• Documented the entire process. Documentation included mapping document, unit testing document and system testing document among others.
• Conducted System Testing, Unit testing and scheduled Informatica jobs. Involved in production support for Informatica.
• Worked on capturing slowly changing dimensions and consolidated key processes.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created UNIX scripts to automate the activities like start, stop, and abort the informatica workflows by using PMCMD command in it.
• Prepared a document to explain the whole operations involved in preparing the data and how to use the UNIX shell scripts to load the data.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Done the documentation work for all the deliverables weekly wise and took responsibility to complete the given task on time.
• Responsible for updating and maintaining and supervising ETL Run Logs and co-ordinate with DBA team to request for Imports and Exports of data from database and flat files

Environment: Informatica 7.1, SQL, Erwin 4.0, PL/SQL, Windows 2000, UNIX, IBM DB2, MS SQL Server 2000, MS VISIO.