SUMMARY

• 11 + years of comprehensive and versatile exposure of IT experience on Data Warehouse and Business Intelligence with proven ability of implementation through Software Development Life cycle (SDLC) encapsulating the encyclopedic process like Business Requirements Analysis, Application Design, Development, Testing, Implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Banking, Insurance and Retail domain.
• 10 years of Experience in Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica Power Center 9.x, 8.x, 7.x versions.
• Extensive knowledge in Hadoop file distributing system, Hive and Oozie Hadoop Streaming.
• Exposure to Informatica B2B Data Transformation that supports transformation of structured, unstructured, and semi - structured data types while complying with the multiple standards which govern the data formats.
• Strong experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Aggregator, Joiner, Update Strategy etc.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• 7 Years of experience in database programming using Oracle 11g,10g,9i,8i,Teradata, XML Files,SQL, PL/SQL, SQL*Plus, SQL*Loader. Strong Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages, Functions, exception handling, ref cursors and Triggers.
• 2 years of experience using Utility scripts like Fast Load, MultiLoad to load data from various source systems to Teradata Enterprise Data warehouse and Good Understanding in protection concepts like Fallback and Journals.
• Extensive knowledge in Dimensional Data Modeling like Star and Snowflake schemas and knowledge in designing tools like Erwin and Power Designer.
• 3 Years of in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Extensive experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 9.x/8.x/7.x/6.x, informatica developer, Hive.

Reporting Tools: Micro Strategy

Data Modeling Tool: Dimensional Data Modeling, Star/Snow flake Schema Modeling, Erwin 3.5/4.0Databases Oracle 11.x/10g/9i, DB2, Teradata V2R5 (Fast-Load, Multi-Load, Fast Export, BTEQ), XML files

Languages: SQL, PL/SQL, Shell Scripting, COBOL, core Java, VB Scripting

Operating Systems: Sun OS UNIX, IBM AIX, HPUX, MS Windows, Windows NT

Utilities: Toad 8.x, SQL*Loader, Embarcadero Rapid SQL 7.0.1

Others: Control-M, Oozie, Contab, PVCS, MS Visio, WinScp.

PROFESSIONAL EXPERIENCE

Confidential, San Roman, CA

Sr. ETL developer

Responsibilities:

• Implement BI and Data Warehousing design principles and industry best practices
• Work closely with Data architect, Data Analyst, BAs.
• Analyze and design/develop MDM processes, tasks, data flows and dependencies
• Involve in gathering requirements and created architectural, detail design documents and mapping documents
• Design ETL solution to leverage with the existing enterprise systems.
• Provide application support for CCAR system.
• Build Informatica mappings/mapplets/sessions/workflows and fine tune to meet SLAs.
• Design and Build framework related mappings that can be used by multiple projects.
• Review/Validate data models and suggest the ETL objects/attributes to add-in for Incremental loads, Error handling and data quality checks
• Provide leadership and direction on ETL portion of project using Informatica Power Exchange.
• Design ETL solution to leverage with the existing enterprise systems.
• Build Informatica mappings/mapplets/sessions/workflows and fine tune to meet SLAs.
• Design and Build framework related mappings that can be used by multiple projects.
• Maintain consistent Informatica standards, configuration management strategies and production deployment standards
• Ensure ETL quality through code reviews, inspections and knowledge sharing
• Create and execute unit test plans based on system and validation requirements
• Develop, troubleshoot, optimize and tune ETL mappings.
• Maintain consistent Informatica standards, configuration management strategies and production deployment standards
• Ensure ETL quality through code reviews, inspections and knowledge sharing
• Create and execute unit test plans based on system and validation requirements
• Develop, troubleshoot, optimize and tune ETL mappings.

Environment: Informatica 9.6.1, Informatica MDM, CDC, IDQ, Oracle 11i, Shell programming, MS Visio, WINScp, TOAD 9, UNIX AIX, Erwin, HP Quality Center.

Confidential, San Francisco, CA

Sr. ETL developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center
• Created the Test cases and Captured Unit test Results.
• Involved in running and scheduling UNIX Shell scripts, Informatica jobs.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 11.2.0.
• Developed and tested all the informatica mappings, sessions and workflows - involving several Tasks.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 9.5/9.1,Oracle 11.2.0,DB2,PL/SQL,Control-M,Crontab,Micro Strategy, TOAD, SQL*Plus, SQL*Loader, XML files, Flat files, Omniture Files Windows, UNIX.

Confidential, San Francisco, CA

Sr. Informatica Developer

Responsibilities:

• Generated the data as per the Clients specifications using mappings and transformations.
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center
• Involved in Data Extraction from Oracle and Flat Files, XML Files using SQL Loader.
• Involved in running and scheduling UNIX Shell scripts, Informatica jobs.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 11.2.0.
• Developed and tested all the informatica mappings, sessions and workflows - involving several Tasks.

Environment: Informatica Power Center 9.5/9.1,Oracle 11.2.0,DB2,PL/SQL,Control-M, Micro Strategy, TOAD, SQL*Plus, SQL*Loader, XML files, Flat files, Windows, UNIX.

Confidential, San Bruno, CA

Sr. Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Modified existing mappings for enhancements of new business requirements.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Environment: Informatica Power Center 9.5/9.1,Oracle 11.2.0,DB2,PL/SQL, Test Director, Erwin, TOAD, SQL*Plus, SQL*Loader, XML files, Flat files, Windows, UNIX.

Confidential, Redwood City, CA

Technical Integration Consultant

Responsibilities:

• Design ETL for Framework, Logging Activity, Control Tables and Error Handling by Interacting with the ETL Integration Consultants and Architects.
• Developed Informatica technical mapping document to pull data from different Source systems and integrate.
• Workflow Recovery with mapping build for recovery, Tuning and Error Handling.
• Debugging and Performance Tuning of sources, targets, mappings and sessions.
• Developed several reusable transformations and mapplets, several workflow tasks.
• Developed Slowly Changing Dimension Mappings of type II
• Created different transformations for loading the data into targets using various transformations like Sql, Joiner, Update Strategy, Lookup, Union, normalizer etc.
• Interact with SMEs to understand the enterprise level operations and its process.
• Complex mappings creation using various transformation tasks and fine tune.
• Build Packages/Procedures/Functions using PL/SQL and performance Tuning.
• Worked on Oracle Utilities SQL Loader, Triggers, EXPLAIN PLAN, Cursors, Views, Materialized Views, Error Handling mechanism etc.
• Assist in usage of Exceptional handling, records, arrays, Partitioning of tables, Bulk Collects.
• UsedTeradata utilities fast load, multiplied, tpumpto load data and wrote BTEQ scripts to transform the data
• Responsible to deploy the releases according to the project plan.
• Provide production support and monitor the loads.
• Create RFC and SRs for any enhancements for deployment and get approvals.
• Write test cases and evaluate test cases for Unit, Integration and system Testing.
• Do health checks by ensuring the source data and target data are accurate and valid.

Environment: Informatica 9.0/8.6.1, ORACLE RDBMS 11i, PL/SQL, Teradata, Teradata SQL Assistant, MS SQL Server, Shell programming, MS Visio, WINScp, VSS, TOAD 9, UNIX AIX, Tivoli, Erwin, Remedy User.

Confidential, Hartford, CT

Sr. Informatica Consultant

Responsibilities:

• Convert the Business requirements into technical requirement documentation.
• Perform analysis, validation on the flat files received from different source systems and integrate the various source systems.
• Design ETL Framework, Logging Activity and Error Handling by Interacting with the ETL Integration Consultants and Architects.
• Low level design documentation of mapping/ ETL specs for business functionality
• Developed Informatica Mappings/ Transformations/ Workflows/ Worklets to pull data from different source systems and integrate.
• Workflow recovery with mapping build for Recovery, Tuning and Error Handling.
• Installation, Configuration and Administration of Informatica Power Center on Client/Server Environment.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Developed several reusable transformations and mapplets, several workflow tasks.
• Developed Slowly Changing Dimension Mappings of type II
• Fine tune mappings/sessions and collect statistics to identify the anomalies.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Stored Procedure etc.
• Created reusable transformations and mapplets to use transformation logic in multiple mappings.
• Complex mappings creation using various transformation tasks and fine tune.
• Build Packages/Procedures/Functions using PL/SQL and performance Tuning.
• EXPLAIN PLAN, cursors, views, materialized views, error handling mechanism etc.
• Worked in exceptional handling, records, arrays, partitioning of tables, bulk collects.
• Shell programming for manipulating the files using AWK and SED.
• Responsible to deploy the releases according to the project plan.
• Provide production support and monitor the loads.
• Problem resolution tickets solving and document it.
• Write test cases and evaluate test cases for Unit, Integration and System Testing.

Environment: Informatica 8.0, DB2,ORACLE RDBMS 10g/9i, PL/SQL,SSIS, MS SQL Server, Shell programming, MS Visio, Web Logic, WINScp, VSS, TOAD 8, DOS Batch Programming, UNIX, Cygwin, CRONTAB, Erwin.

Confidential

ETL Developer

Responsibilities:

• Involved in project life cycle - from analysis to production implementation and support.
• Worked closely with Project Managers, Business Analysts, source owners, Data Quality team to ensure timely and accurate delivery of business requirements
• Developed data movement process that load data from different sources into Teradata by using Teradata SQL and utilities such as Bteq, Fast load, Fast export, Multiload .
• Created Macro’s on TERADATA and Executed through Informatica and Good Understanding in protection concepts like Fallback and Journals.
• Worked on Complex SQL, Stored Procedure and Executed through Informatica.
• Created Technical Specs documentation, and ETL documentations, Data Profiling, Data Mapping, and unit test Specs conforming to internal guidelines
• Accomplished Teradata performance tuning via Explain, collect statistics or rewriting of the code.
• Handled release tickets for defects, enhancements, performance tuning, and process optimization activities
• Performed data quality, integrity end to end testing, reversed engineer and documented existing ETL codes
• Automated ETL tasks by developing UNIX shell scripts and using Control-M.
• Assisted SIT/UAT testers in optimizing testing scripts and to ensure data accuracy and integrity and provided production support.

Environment: Informatica Power Center 8.5.1/8.6.1 , ETL, SQL Server, Teradata, Oracle10/11g/9i, UNIX, Erwin, PL/SQL, Control-M.

Confidential

Informatica Developer

Responsibilities:

• Worked with business users and other data source owners to identify requirements, source file structure, and frequency of loading, implications and resolve data quality issues.
• Prepared Power point presentations, Test cases, Data flow diagrams.
• MentoredDevelopment teams, program code development, test plan development, testingandresult documentation, analyzing defects, bug fixing
• Documented Program Specifications, UnitandIntegration Test Specifications, Test Results
• Coded test SQLsandanalyzed results and Analyzed test case resultsanddocumented test cases/plans
• Accomplished data movement process that load data from Flat files intoOracleby the development of Korn Shell scripts, usingOracleSQL.
• Improved Informatica performance by identifying bottlenecks at source, target, mappings and session level.
• Provided expertiseandtrained less experienced developers, creating the necessary training materials.
• Worked closely with Project Managerand client to assess goals and kept accurate, generatedand/or maintained moduleandstatus reports
• Develop Mappings/Workflows and Fine Tune.

Environment: Informatica 7.2, ORACLE RDBMS 9i, PL/SQL, Crontab, Teradata, COBOL, TOAD, Trillium, Windows XP Professional and UNIX