SUMMARY

• 8+ years of experience in Informatica with a strong background in ETL development using Informatica tools PowerCenter, Data Quality, Informatica cloud.
• Experience in Telecom, Health care, Pharma and Financial service domains.
• Extensive experience in Data Warehouse applications usingInformatica, Oracle, DB2, Mainframes and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Good working knowledge on developer client/InformaticaIDQ.
• Proficient inInformaticaPowerCenter 8x/9x, Power Exchange, DB2, Oracle and TWS Scheduler, TIDAL, Unix, Mainframe and Xml's.
• Expertise in preparing theETLDesign Documents like High Level and low level Design documents.
• Experience in documenting High Level Design, Low level Design, STM's, TRD, TDD and Deployment Documents Worked with the flat files in both the direct and indirect methods and worked with XML files.
• Involved in project estimations, Unit testing and preparation of Unit Test Cases.
• Involved in preparation of Deployment plan to deploy the code from one environment to another environment.
• Responsible for gap identification in existing solution and preparing a solution model for the execution and deployment of project releases
• Responsible to co - ordinate with multiple teams across vendors forETLcode development, testing, issue resolution and production.
• Involved in conducting and leading the team meetings and providing status report to project manager.
• Experience in developing mappings in Hadoop environment for extracting and loading into HIVE tables and HDFS usingInformatica BDE.
• Experience in working with Oracle 11g including PL/SQL and shell scripting.
• Implemented end-to-end tasks effectively throughout the project till its delivery to customer.
• Very strong knowledge ofInformaticaData Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Very strong knowledge on end to end process of Data Quality.
• Good experience on Data Warehouse Concepts like Dimension Tables, Fact tables, slowly changing dimensions, DataMarts and dimensional modeling schemas.
• Good Knowledge of web services likeInformaticacloud, salesforce web services and amazon web services
• Experience in working with otherETLtools like Pentaho Kettle and DataStage
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Data Vault, Oracle Designer and modeling tools like Erwin and Visio, SCD, Surrogate keys, Normalization/De normalization

TECHNICAL SKILLS

Data Warehousing/ETLTools: InformaticaPowerCenter 9.x/8.x/7.x/6.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformation, Sessions, Workflow Manager-Workflow, Task, Commands, Worklet, Transactional Control, Constraint Based Loading, SCD I, II, Data Flux, Datamart, OLAP, ROLAP, MOLAP, OLTP.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle … SQL Server … MS Access and DB2

Languages: SQL, PLSQL C, C++, Data Structures, Unix Shell Script, Visual Basic

Web Technologies: XML, HTML, Java Script

Tools: Toad, SQL* Developer, Autosys, Erwin

Operating Systems: Windows Server, … UNIX, MS-DOS and Linux

PROFESSIONAL EXPERIENCE

Confidential, Michigan

Sr.ETL Informatica Developer

Responsibilities:

• Involved in designing, developing and documenting of theETL(Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds usingInformatica, PL/SQL scripts
• Designed and developed complex mappings inInformaticato load the data from various sources such as SQL Server, Flat files, Oracle, XML using different transformations such as, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Extracted data from Heterogeneous source systems like Oracle, Teradata, SQL Server and flat files.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked with database andInformaticafor performance tuning.
• Created and configured workflows, Worklets, and sessions to transport the data to target warehouse SQL Server tables usingInformaticaWorkflow Manager.
• Created Mapping Parameters and Variables.
• Administrating User Privileges, Groups and Folders which includes creation, update and deletion.
• Migration of New and ChangedInformaticaobjects across the environments using Folder to Folder and Deployment Group methods.
• Worked on Database level tuning and SQL Query tuning for the Data warehouse.
• Analyzed newly converted data to establish a baseline measurement for data quality
• Developed PL/SQL stored procedures and UNIX commands shell scripts for pre and post session commands and batch jobs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Worked with PMCMD command line program to talk with theInformaticaserver
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
• Used data coming from IBM Mainframe systems to stage in Oracle and then write to database.
• Identified end user data access and reporting needs and help business users towards defining detail requirements.
• Analyzed data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.

Environment: Informatica8.6, Oracle 9i, HP-UNIX, Flat Files, PL/SQL Developer and TOAD, Power Exchange 8.6, IBM Mainframe.

Confidential, Louisville, Kentucky

ETL Informatica Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse andETLprocesses.
• UsedInformaticaasETLtool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked onInformatica- Source Analyzer, Warehouse Designer, Mapping Designer &Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and storedprocedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Successfully upgradedInformatica9.1 and to 9.5 and responsible for validating objects in new version ofInformatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of Teradata SQL,ETLand other processes to optimize session performance.
• Loaded data in to the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by followingInformaticabest practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively onInformaticaPartitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• SchedulingInformaticajobs and implementing dependencies if necessary using Autosys.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.

Environment: InformaticaPower Center 9.1.1/9.5.1, Oracle 11g, DB2, Teradata, Flat Files, Erwin 4.1.2, Sql Assistant, Toad, Winscp, Putty, Autosys, UNIX.

Confidential, Salt Lake City, Utah

ETL Informatica Developer

Responsibilities:

• Coordinating with Onsite Team and client for Requirements gathering and analysis.
• Implementation of Basel II/III Framework
• Understanding and developing theETLframework forInformaticaobjects as per coding standards.
• Performed the data profiling and analysis making use ofInformaticaData Quality (IDQ).
• Worked withInformaticaData Quality (IDQ) tool kit, Analysis, data cleansing, data matching, data conversion, exception.
• Used reference tables and rules created in Analyst tool.
• Used various IDQ transformations like Standardizer, Match, Association, Parser, Weighted Average,
• Comparison, Consolidation, Decision, Expression
• Implement Data Quality Rules using IDQ to check correctness of the source files and perform the data cleansing/enrichment.
• Loading data into operational data store.
• Designing and developingInformaticamappings including Type-I, Type-II, Type-III slowly changing dimensions(SCD)
• Worked on creating PL/SQL objects like Stored Procedures, functions, triggers, materialized views, packages
• Coding & testing theInformaticaObjects & Reusable Objects as BI standards.
• Participating in peer review ofInformaticaobjects.
• Estimating volume of work & Deriving delivery plans to fit into overall planning
• PreparedETLBuild Peer Review Checklist's and Unit Test Case Templates for different work packages.
• Involved in Unit Testing, Integration Testing and System Testing.

Environment: Informatica9.1(PC & IDQ), Data Stage, Power Exchange, TeraData 13, SQL SERVER 2008, Teradata SQL Assistant, SQL Developer, UNIX, CITRIX, Business Objects, JIRA

Confidential

ETL Informatica Developer

Responsibilities:

• Designed and developedETLProcesses based on business rules, job control mechanism usingInformaticaPower Center.
• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-endETLprocess for Sales Data Warehouse.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• UsedInformaticapower center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, usedInformaticadebugger to identify issues in mapping execution.
• Re-engineered lots of existing mappings to support new/changing business requirements.
• Monitored production jobs on a daily basis and worked on issues relating to the job failure and restarted failed jobs after correcting the errors.
• Developed reusable transformations, mapplets, sessions, work lets to makeInformaticacode very modular and reuse as required
• Performance tuned SQL statements,Informaticamappings, usedInformaticaparallelism options to speed up data loading.
• UsingInformaticaPower center9.1 to make the changes to the existingETLmappings in each of the environments.
• Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: InformaticaPower Centre 9.1, Repository Manager, Designer, Work Flow Manager, Oracle 11g, SQL Server, Teradata, XML Files, Flat Files, CSV files, PL/SQL (Stored Procedure, Trigger, Packages), Windows.

Confidential

ETL Informatica Developer

Responsibilities:

• Assisted to prepare design/specifications for data Extraction, Transformation and Loading.
• PerformedInformaticaUtilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the sources, transformed data, prepared mapping for data and loaded the data into targets usingInformaticaPower Center Designer.
• Prepared reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Helped in developing complex mappings such as Slowly Changing Dimensions (SCD) Type-II Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected & Unconnected lookups, Update Strategy, Filter transformation, Joiner tra1 nsformations to implement complex business logic.
• UsedInformaticaWorkflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables & Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Helped in performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developingInformaticaETLprocess.

Environment: InformaticaPower Center 8.1, Oracle 9i, PL/SQL Developer, SQL, UNIX Shell Script.