SUMMARY:

• 7+ years of experience in system analysis, Database Design, Programming, Development and Implementation using Informatica Power Center.
• In - depth knowledge and understanding of concepts of Data warehouse, Business Intelligence, OLTP, OLAP, Star/Snowflake Schemas and Data Modeling (Physical/Logical/ER-Diagrams) etc.
• Experience in all phases of data warehouse development viz. Requirements analysis, application design, development (including ETL and database), code migration, testing, and implementation in Production environment, Production support and on call support for night jobs and weekend support.
• Experience in designing Workflows, Worklets, Mappings and Sessions using Informatica power center 9.6.1/8.6.1 /7.1.3 .
• Experience in designing and developing complex mappings using various transformation logic like Unconnected and Connected Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, etc.
• Experience in debugging and performance tuning of targets, sources, mappings and sessions.
• Experience in Informatica Data Quality (IDQ) 9.6/9.1 as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
• Good Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Experience in optimizing mappings and implementing complex business rules by creating re-usable Transformations, Mapplets and Stored Procedures.
• Experience in dealing with various data sources like Netezza, Oracle, SQL Server 2012/2010/2008, Teradata, Flat files, web services, XML, COBOL/VSAM files.
• Familiar with relational database design for OLAP and OLTP.
• Extensively worked with Informatica performance tuning involving source level, target level and mapping level bottlenecks.
• In-depth knowledge in the Teradata cost-based query optimizer , identified potential bottlenecks.
• Experince in creating Mappings and Mapplets using various connected and unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator, SQL, HTTP transformations, Transaction Control and Upate Strategy.
• Worked extensively on Teradata Analyst Pack such as Teradata Visual Explain, Teradata Index Wizard and Teradata Statistics Wizard..
• Worked exclusively in implementing slowly changing dimensions (SCDs) - Type I and II in different mappings as per the requirements.
• Experience on Teradata platform using Teradata utilities such as Teradata sql assistant, load utilities such as Teradata parallel transponder, FastLoad, FastExport.
• Developed BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Created UNIX scripts to run Informatica workflows and controlling the ETL flow.
• Scheduled jobs using Informatica scheduler, Autosys, Cybermation.
• Independently perform complex troubleshooting , root-cause analysis and solution development.
• Experience on Defect Management Tool HP Quality Centre to create and run manual test cases as well as generate defect reports.

TECHNICAL SKILLS:

Data warehousing (ETL): Informatica Power Center 10.1.1/9.6/9.3, Repository Manager, Informatica Power Exchange for mainframes, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer and Informatica Data quality tool

Data Modeling: Ralph Kimball Methodology, Bill Inmon Methodology, SnowFlake, Star Schema, FACT Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization using Erwin, Confidential info sphere data stage tools and Oracle SQL developer

Databases: Oracle 10g/9i/8i, MS SQL 2012/2008, SQL Server 2008/2012, Teradata 12/13, DB2 UDB 9.5/8.0/7.0

Reporting tools: Cognos BI tools, SAP Business objects

Environment: Windows 2010/2007, UNIX, AIX, Linux

Job Scheduling: Informatica Scheduler, Control M, CA Autosys 11.3

Others: PeopleSoft, Microsoft Word, Basics of mainframe, Microsoft Excel, Outlook, XML, and HTML.

PROFESSIONAL EXPERIENCE:

Confidential, San Leandro, CA

Sr. Informatica Developer

Responsibilities:

• Involved in Business Analysis, requirement gathering, Designing Logical and Physical Data models. Creating the design and technical requirements of the project.
• Create the project design, unit test plans, and system test plan as per the standards defined for client.
• Attend User Level Meeting with the Client to fine tune the application scope and functionality.
• Perform the fit gap analysis for the major enhancements and provide the effort estimates.
• Create the code for the requirement with high complexity. Logical Design and enhancing the scope and functionality of the application.
• Assisted in the creation of Fact and Dimension tables and their implementation in Star Schema model based on the requirements.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer, Transformation Developer and Informatica power exchange and data stage.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Created data maps in power exchange tool for mainframe resources Converted functional specifications into technical specifications (design of mapping documents).
• Responsible for design and implementation needed for loading and updating the warehouse.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Manage the service request/incident queue and adhere to the SLA defined for them.
• Create ETL code for the complex Slowly Changing Dimensions.
• Perform the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Cognos report studio reports generation and Cognos reports migration from COGNOS 10 to COGNOS ANALYTICS

Environment: Informatica Power Center 9.X (Power Center Designer, workflow manager, workflow monitor), IDQ 9.6, COGNOS 9 and COGNOS 10, DB2, UNIX, Oracle.

Confidential, Charlotte, NC

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, Netezza, and Flat Files.
• Extracting data from Netezza, Oracle and Flat files, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformation, Update strategy transformations to load data into the target systems.
• Used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Worked on performance tuning of Informatica mappings.
• Implemented Change Data Capture (CDC) on Source data .
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA, Production)
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Was part of support team during which assisted production support resources in resolving issues efficiently.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Monitored and improved query performance by creating views, indexes and sub queries
• Maintained the Defects Tracking in HP Quality Center and to analyze the variation between the expected and actual results.

Environment: Informatica Power Center 9.6.1/8.6.1, Informatica Data Quality (IDQ) 9.6, Flat Files, Oracle 11G, Quest Toad Central, SQL Server 2012, Autosys

Confidential, Battle creek, MI

Sr. Informatica Developer

Responsibilities:

• Involved in discussions with business users for requirement gathering, understanding the requirements and explanation of technical probabilities and possibilities with business users.
• Developed Informatica mappings, transformation, reusable objects by using mapping designer and transformation developer and Mapplet designer in Informatica Power Center.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked closely with MDM team to identify the data requirements for their landing tables and designed IDQ process accordingly.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Lookup, Joiner and Stored procedure transformations.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager. performed MLOAD scripts to load data from Load ready files to Teradata warehouse performed tuning and optimization of complex SQL queries using Teradata explain. created series of macros for various applications in TERADATA SQL ASSISTANT
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Used Informatica Workflow Manager and server to read data from sources to write to target databases, manage sessions/tasks and to monitor server.
• Involved in Performance Tuning of mappings in Informatica.
• Prepared documents for QA and PRODUCTION migration.
• Worked with business users and QA team during testing phases.
• Created Test cases for Integration testing and UAT. Reviewed UAT with business users.
• Provided on-call support for the project after migration.

Environment: Informatica 9x, Informatica Data Quality (IDQ) 9.6, Teradata 12.0/13.0, Sql Server 2008, SQL Loader, UNIX, Shell script, Toad, PVCS, Visio, Autosys.

Confidential

Sr. Informatica Developer

Responsibilities:

• Developed number of complex Informatica mappings, mapplets and reusable transformations to implement the business logic and load the data incrementally.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Developed Shell Scripts for moving Files to/From Different Servers.
• Created Informatica workflows and IDQ mappings for - Batch and Real Time.
• Responsible for creating and maintaining Informatica processes, managing data warehouse schemas, assisting with SQL tuning techniques, creating views, tables, snapshots to assist report teams.
• Worked on Stored Procedures in fixing the bugs, modifying the PL/SQL code for Small Enhancements.
• Managed multiple tasks and responsibilities in high-pressure implementations.
• Migrated mappings, workflows from one environment to another environment.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Experience in working on change requests which includes creating changes (Data Repair, Low Impact, Major and Minor Change requests), implementing the Changes.
• Extensively used Informatica to load data from SQL Server and flat files into staging area.
• Developed Shell Scripts for triggering Informatica Workflows using PMCMD Command.
• Worked in Scheduling daily, weekly and Monthly jobs using Control M to extract information from multiple data sources and provide Target Files to Business Users.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions.
• Worked Extensively on Creating and implementing Changes into Production.

Environment: Informatica 9x, Informatica IDQ, Informatica Metadata Manager, Oracle 11g and Windows 2010 professional, SQL Server 2008, ESP scheduler

Confidential

Informatica /ETL Developer

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Document the process for further maintenance and support. Worked on test cases and use cases.
• Used caching optimization techniques in Aggregator, Lookup and Joiner transformation.
• Created reusable transformations and used in various mappings.
• Used various debugging techniques to debug the mappings.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed Informatica parameter files to filter the daily source data.
• Used various Indexing techniques to improve the query performance.
• Creating Test Documents for Unit Test and Integration Test to check the data quality.

Environment: Informatica 8.3, Confidential Mainframes, DB2UDB, flat files, UNIX, Windows 2000, Oracle 10g, SQL Server, TSQL, WinSQL, Mercury Quality Center.

Confidential

ETL Developer

Responsibilities:

• Involved in Business Requirements analysis and design, prepared and technical design documents.
• Used Erwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Developed technical design specification to load the data into the data mart tables confirming to the business rules.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable components such as Mapplets, Reusable transformations and sessions etc.
• Involved in loading the data from Source Tables to ODS (Operational Data Source) Tables using Transformation and Cleansing Logic using Informatica.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Created Materialized views for summary tables for better query performance.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 7.1.3, Oracle 10g, UNIX, Business Objects, PL/SQL, Flat files, SSIS, MS SQL Server 2008.