Summary:

• Over 7 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.5.1/8.x/7.x and PowerMart 6
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify, study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Extensively worked on Extraction Transformation and Loading ETL using Informatica 8.6.1/8.1/7.1/6.1.2/5.1/4.7 Power Center .
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling Star Schema and Snow Flake Schema .
• Experience in integration of various data sources like Oracle, Netezza, Teradata, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Experience in creating Reusable Transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks Sessions, Command, Email and Non-Reusable Tasks Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control .
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Proficient in using Informatica Server Manager to create schedule sessions and batches.
• Good Understanding knowledge of Ralph Kimball Bill Inman Methodologies.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Good understanding of Software Development Life Cycle SDLC and Project Life Cycle.
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical/ communication skills and good team player.

Technical Skills:

Confidential

ETL/Informatica developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup
• Created events and tasks in the work flows using workflow manager
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them using Autosys.

Environment: Informatica Power Center 9.1, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL Loader, Sun Solaris 2.6, UNIX Shell Scripting, Autosys

Confidential

ETL/Informatica developer

Responsibilities:

• Designed and developed the logic for handling slowly changing dimension table's load by flagging the record using update strategy for populating the desired.
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Scheduled Informatica workflows using AppWorx to run at regular intervals.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre Post Session SQL Script to meet business logic.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Converted MS SQL Server DTS Packages logic into Informatica mappings.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java,XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed Type1 and Type2 mappings
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in massive data cleansing prior to data staging.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 8.6, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, SQL, PL/SQL, T-SQL, SQL Plus, TOAD, AppWorx, Erwin, Windows XP, Unix, Teradata v2r4, Oracle Applications 11i, Sun Solaris

Confidential

Informatica Developer

Responsibilities:

• Collected the Stats in Teradata for all the queries after every refresh of the DB for improving the query performance.
• Worked extensively with utilities of Teradata like Multi-Load, T-Pump and BTEQ to populate the target data.
• Executed Multi-Load scripts for daily batch jobs.
• Written complex SQL queries in Teradata for testing the Informatica mappings.
• Created and used Scripts, Run Files, BTEQ, MLoad and Tpump jobs.
• Extensively used Teradata SQL with in BTEQ.
• Interacted with business community and gathered requirements based on changing needs.
• Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from Oracle, Flat files, XML files, and load into Teradata Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing against source and target data.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Scheduled Informatica jobs through Maestro Scheduler for UAT and Production and UAT loads.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Worked closely with the business analyst's team in order to solve the Problem Tickets, Service Requests by giving 24/7 Production Support.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, Teradata v12, Flat files, UNIX, Erwin, TWS Maestro.

Confidential

Data Warehouse Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process ETL for data migration using Informatica power center.
• Responsible for developing Source to Target Mappings.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various source Oracle, Flat file, XML and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time
• Monitored Workflows and Sessions
• Developed Unit test cases for the jobs.
• Involved in developing Adhoc reports using Business Objects.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment: Informatica 5.1, Oracle 8i, Erwin 4.0, PL/SQL, UNIX and Windows NT.