SUMMARY

• 6+ years of total experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Extensive experience in Banking, Insurance, Financial and Healthcare domains.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Experience with ETL process using Informatica Power Center 9.x/8.x Power Exchange, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, DB2 UDB, Teradata, MS SQL Server and Worked on integrating data from XML files, flat files like fixed width and delimited.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Experience in the successful implementation of ETL solution between an OLTP and OLAP database in support of Decision Support Systems/Business Intelligence with expertise in all phases of SDLC.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulkload.
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Involved in Understanding and translating the business requirements and to High Level and Low level design for ETL processes in Teradata, Data stage and Informatica.
• Very strong in Shell Scripting (KSh, Bourne Shell) and scheduling using Crontab.
• Experience in Performance Tuning of mappings, ETL procedures and process and involved in complete life cycle implementation of data warehouse.
• Experienced in OLTP/OLAPsystem study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin, Visio.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and Denormalization Concepts.
• Extensive experience in implementing CDC using Informatica Power Exchange 9.x/8.x
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11x/10g, SQL Server 2005,Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Effectively communicate with business, project manager and team members.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.

TECHNICAL SKILLS

ETL Tools: Informatica 8.x,9.x(Power Center)

Databases: Oracle11g/10g,Sybase12.0/11.x,Teradata13/V12/V2R6/V2R5, DB2, SQL Server2008/2005/, MSAccess2003/2000.

BI Tools: OBIEE 10.x, Business Objects.

Data Modeling: Erwin, Star Schema, Snowflake Schema, Dimension Data Modeling, Fact tables, Dimension tables.

Programming: SQL, PL/SQL, UNIX Shell Scripting

Environment: UNIX, Windows 2000/2003/XP, Windows NT

DB Tools: Toad for Oracle, SQL*Loader,SQL Navigator, Informatica Data Quality 9.1

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Participation in the daily Scrum meeting.
• Creating the design and technical specifications for the ETL process of the project.
• Worked extensively on source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Designed and developed Informatica Mappings and sessions based on business rules.
• Analyzed business process workflows and assisted in the development of ETL procedures for Moving data from source to target systems.
• Created and managed the triggers for the smooth flow of data from the Source tables to unboxing tables.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Involved in performance tuning using Explain Plan, analyzing Schema's, Tables and Indexes.
• Customized the solution by using partition tables, index views.
• Designed and developed complex aggregate, join, look up transformation rules to generate Consolidated (fact/summary) data.
• Developed Test Cases for Unit Testing, and also involved in Integration, system, and performance Testing levels.
• Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain Current and historical data in the dimension.
• Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
• Involved in fixing the invalid Mappings. Wrote various Functions, Triggers and Stored.
• Procedures to drop, re-create the indexes and to solve the complex calculations.
• Migrated the codes from Development to Test, Test to Production.
• Created effective Unit, System, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure The Successful execution of accurate data loading.
• Created technical documentations for each Mapping for future developments.
• Created Pre & Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re- Create the indexes and to solve the complex calculations on data.
• Responsible to transform and load of large sets of structured, semi-structured and unstructured data from heterogeneous sources.
• Tested mappings, workflows and sessions to figure out the bottleneck to tune them for better Performance.
• Prepared effect Unit, Integration and System test cases for various stages to capture the data discrepancies/ inaccuracies to ensure the successful execution of accurate data loading

Environment: Informatica Power Center 9.5, Oracle11g, PL/SQL, UNIX Shell Scripting, SQL-Developer, JIRA, UC4, Windows XP.

Confidential, Nashville TN

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Transformation mapping for inserting and updating records when loaded.
• Expertise in conversions from SQL Server to Teradata.
• Use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Created Mapping Parameters and Variables.
• Worked with Teradata utilities such as Mload, Fload, export etc. to load or extract tables.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 9.5, Oracle 11g, PL/SQL, Teradata, Flat files, XML, MS Access, SQL Server 2008, VSS, Erwin, Unix. Toad 9.0.

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between staging tables and data warehouses/data marts.
• The cleansed data from the Intermediate layer was then loaded into Data Repository after applying the required transformation rules.
• Improved error handling and reduced the number of defects by implementing Audit Balance Control (ABC) using Informatica and DB2 to maximize the quality of the deliverables.
• Analyzed the data for gap analysis between source and target structure.
• Performed data profiling to understand the data pattern using Informatica
• Performance tuned the module using techniques like cache, scripting and transformation improvements.
• Wrote Unit Test Plan, Module Test Scripts, Module Test Plan, and Failure Modes & Effective Analysis.
• Understand the overall Investment Management business so that identification of processes becomes simple.
• Involved in Analysis Phase to gather the requirement provided by user and prepare the functional document.
• Interacting with BA’s and downstream end users to understand the requirements clearly.
• Customization/Creation of ETL components as part of development.
• Create the Unit Test Cases and done SIT testing for ETL & Reporting.
• Performance tuning of new or existing application wherever required.
• Handled complete configuration of customized/new tasks and loading process through Control-M jobs.
• Understand the Business requirements and estimate the effort for the new requirements.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required.
• Designed logical and physical data model. Designed ETL process from source to target.
• Created database objects like staging tables, target tables, synonyms, sequences, triggers and stored procedures to move data to target.
• Developed Informatica mappings. Unit test ETL mapping codes and validated the result set data.
• Developed Shell scripts to run ETL batch through Control-M schedule.
• Documented validation rules, exception processing and test strategy of the mappings
• Migrated ETL codes from Development to Test to Production.

Environment: Informatica 9.1, Control-M, Rapid SQL, FileZila, Cognos, Oracle10g, Sybase, DB2, Erwin, Shell Script, Toad.

Confidential, Pleasanton CA

Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Migrated Informatica Folders from Development Environment to Test and System Test Environment and Worked with Admins to migrate the same to Production environments.
• Wrote PL/SQL procedures for reconciliation of financial data between source and target to automate testing phases and help business for preliminary validation.
• Wrote UNIX scripts, environment files for Informatica.
• Developed Metadata driven code for effective utilization and maintenance using technical metadata, business metadata and process metadata.
• To externalize the business logic instead hardcoding in the mapping I have used Parameter file in Informatica.
• Generated Cognos reports to test standardized reports as per business requirements.
• Tuned Mappings and Mapplets for best Performance on ETL Side and Created Indexes and Analyzed tables periodically on Database side.
• Organized the dataflow and developed many Control M jobs for Scheduling Jobs and moved to production.
• Primary resource in Production support team so, involved in emergency calls when application outage occurred and resolved defects when raised.

Environment: InformaticaPower Center 8.6.0, SQL Server 2005, Oracle 10g, MS Excel, MS Access, Flat Files, Cognos 8.0, SQL Dev, Toad, Unix, Windows XP, Erwin, Control M.

Confidential, NYC, NY

Informatica Developer

Responsibilities:

• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 8.6.
• Created batches to run several sessions sequentially and concurrently.
• Involved in performance tuning of Informatica mappings and sessions.
• Based on requirements, Developed Source-To-Target mapping document with business rules and also developed ETL Spec documentation.
• Did code review and unit tested ETL mappings. Mentor the developers and help them with issues.
• Developed ETL mapping for the reporting requirement and for data feeds. Changed ETL Mapping provided by vendor to suit business requirement.
• Gap analysis by mapping the functional requirements to the Business Requirements worked on the report design to create User Interface mock-ups.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.
• Verifying the deliverables of the testing performed by the QA team and provided sign-off for production.

Environment: Unix, Informatica 8.6, Windows XP, Oracle 9i, MS Access 2000, VB Script, Toad, MS Visio, MS Excel, MS Word.

Confidential

ETL Developer

Responsibilities:

• Impact Analysis, Detail Design, Traceability Matrix.
• Distribution of work among team members.
• Task creation for the team members and management related work for Technical Design Document, Functional document and code review for the different project.
• Developed ETL mapping for the reporting requirement and for data feeds. Changed ETL Mapping provided by vendor to suit business requirement.
• Gap analysis by mapping the functional requirements to the Business Requirements worked on the report design to create User Interface mock-ups.
• Coordination with the onsite coordinator for delivery to client.
• Verifying the deliverables of the testing performed by the QA team and provided sign-off for production.
• Unit testing and implementation in production for new CR.
• Daily production supports for the scheduled job and provide the resolution related to failed job and fixed them.
• Performance tuning of the workflow which are taking time.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Creation of technical documents.
• To write unit test cases/integration test cases, share test cases with client and do the unit tests for the client sample data.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Environment: Informatica Power Center 8, Workflow Manager, Workflow Monitor, Power Exchange, PL/SQL, Oracle 10g/9i, SQL Server 2005/2000, Windows Server 2003, UNIX, Toad, Visual Source Safe (VSS),Business Objects.