SUMMARY

• 7+ years of IT professional experience in designing, analysis, programming and testing using Informatica Power Center 9.x/8.x/7.x/6.x.
• Extensive experience in design, development and implementation of Data marts, Enterprise Data Warehouses and Business Intelligence Solutions.
• Extensive experience in Developing Informatica complex mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Extensive experience in Insurance, Financial and Healthcare domains.
• Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.
• Intelligent Gathering of Business requirements to map legacy and other sources to integrate into the Warehouse.
• Expertise with ETL processes utilizing Informatica PowerCenter design data conversions from a variety of relational, XML and flat file source systems to data marts/EDW.
• Experience with data analysis and Dimensional Data Modeling (specific to a data warehouse / Business Intelligence environment), Star schema/Snowflake schema, fact and dimension tables.
• Responsible for all activities related to the development, implementation and support of ETL processes for large - scale data warehouses using Power Center and Power Mart.
• Expertise in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Experience in designing and developing efficient Error handling methods for ETL mappings and workflows.
• Strong hands on experience using Teradata utilities (SQL, BTEQ Fast Load, MultiLoad, FastExport, TPump, Visual Explain, Queryman, WinDDI, AMpUsage reports)
• Extensive experience in UNIX programming and shell scripting for Informatica pre & post session operations.
• Ability to communicate design solutions to both technical and non-technical audience.
• Experience in full life cycle development and implementation.
• Good understanding of overall data warehouse design principles and best practices.
• Good Team Player with excellent communication, analytical, and documentation skills.
• Experience in preparing documentation for data requirements and on performing data modeling.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session.
• Hands on experience in scheduling jobs through Control-M / WLM (Workload Manager) Jobs.
• Very good exposure to Oracle 10g, 9i, 8.x, Teradata databases
• Hands on experience working in UNIX and Windows environments.
• Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Industrial, Insurance, Pharmaceutical industries
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

PROFESSIONAL EXPERIENCE

Informatica / ETL Developer

Confidential, New York, NY

Responsibilities:

• Defined, designed, configured, and implemented a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, message queues, spreadsheets) to Amazon Reshift, Oracle 10g and SQL Server environment.
• Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations.
• Designed SnapLogic Pipeline for ETL Process to load the data into Amazon Redshift.
• Performance tuning on Snap Logic Pipelines in Production environment.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows.

Environment: Informatica … Amazon Redshift, SQL, PL/SQL, Trello, SQL Server, Windows XP.

Informatica Consultant

Confidential, Richmond, VA

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.
• Created several mappings using various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner and Expression.
• Developed Conceptual Business Model, Logical Data Model, Physical Data Model and Star - Schema design.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Defined, designed, configured, and implemented a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, message queues, spreadsheets) to Oracle 10g environment.
• Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including
• Developed, tested and implemented break/fix change tickets for maintenance and enhancement of Operational Data Store.

Environment: Informatica … Teradata 14.10, SQL, PL/SQL, TSRM, WLM, UNIX, Windows XP.

Informatica Developer

Confidential, Richmond, VA

Responsibilities:

• Used different tasks (Session, Command, Email, Event - Wait and Control) in the workflow
• Involved in preliminary analysis for the failure and approach to fix the issues/specifications after finding the Root cause.
• Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations
• Completion of loads meeting the SLA's by coordinating with Source teams and LO teams for smooth execution.
• Created slowly changing dimension tables - SCD type 1 & type 2 mappings using lookup, Expression, Update Strategy and Router Transformations
• Preparing and tracking of the overall status of applications and communicating it with client on regular basis.
• Involved in analysis of primary cause of Incident Tickets, creating change requests, Work Order (Service requests) in TSRM tool to implement new production jobs, scheduling changes and fixes.
• Effective coordination with team members for Client deliverables & also with development team to resolve the possible production issues.
• Understanding and documenting the existing applications for extended and smooth support of applications.

Environment: Informatica 9.1, Teradata 13, SQL, PL/SQL, Oracle 10g, TSRM, Windows XP UNIX, WLM, TSRM

ETL / Informatica Developer

Confidential, Pleasanton, CA

Responsibilities:

• Based on the business requirements created High level and low level Design Documents.
• Coordinated with team and Performed code review.
• Interacted with Data modular and DBA and Source systems and resolved the Issues.
• Created Source definitions from SQL Server, Flat Files, Oracle, Teradata, and Mainframe COBOL Sources.
• Created mappings involving various transformations like joiner, aggregator, lookup, sequence generator, stored procedure, update strategy, filter and router transformations to implement business logic.
• Imported/Created Target definitions and created Reusable Transformations, mapplets in Shared folder.
• Involved in creating Informatica mapping to populate staging tables and data warehouse tables from Mainframe sources.
• Performed dimensional and 3NF modeling according to enterprise standards.
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Created shortcuts for source and target and also created Reusable Transformations, mapplets in Shared folder.
• Creating sessions, work lets and workflows for carrying out test loads.
• Extensively created BTEQ scripts to implement post load processes.
• Extensively created MLOAD, FLOAD and TPUMP control files to load data in to EDW tables.
• Extensively used FAST EXPORT script to unload data from EDW and send them to other systems to use them as source.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Extensively used sequence generator for key generation in the data warehouse.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Coordinated with testing team in all three phases of testing including end - to-end testing.

Environment: InformaticaPower Center 8.1, Teradata 13, windows 2000, Teradata SQL, UNIX, Microsoft Excel.

ETL Informatica Developer

Confidential

Responsibilities:

• Extensively used Informatica power center for extraction, transformation and loading process.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Used Informatica Designer to create mappings using different transformations to move data from source to a Data Warehouse.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Router, Rank, Filter and Sequence Generator transformations.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Created SCD type 2 mappings using lookup, Expression, Update Strategy and Router Transformations.
• Scheduled the sessions to extract, transform and load data into warehouse database as per Business requirements. Improved the session performance by pipeline partitioning.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for Data ETL.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Environment: Informatica Power Center 7.x, windows 2000, Teradata SQL, UNIX, Microsoft Excel.

Confidential

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center 6.x/7.0 tool.
• Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
• Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
• Design of ETL Mappings and Workflows using powercenter designer and workflow manager.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.
• Used Shell Scripting to automate the loading process.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I and II changes in slowly changing dimension tables.
• Used command line program pmcmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed processes to extract, transform, and load data to the Data Mart.
• Performed impact analysis, remedial actions and documented on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Environment: Informatica Power Center 6.x, ETL, Oracle 8i, MS Access, SQL, PL/SQL, Windows NT.

TECHNICAL SKILLS

ETL Tools: Teradata, Snap Logic, Informatica Power Center …

Databases Oracle: Amazon Redshift and Teradata

Programming Skills: SQL

Scripting Languages: UNIX Shell Scripting

Operating Systems: UNIX (Sun Solaris 2.x, HP/UX) and Windows …

Utilities: BTEQ, Fast load and Multi Load.