Summary

• Around 8years of IT experience in all phases of Software Development Life Cycle analysis, design, development, test, implementation and support .
• 7years of experience in DataWarehousing using ETL and OLAP tools InformaticaPowerCenter9.5/9.1/8.x/7.x, Informatica PowerExchange9.x/8.x,OBIEE 11g/10g, Business Objects XI/6.1.
• Accomplished and highly experience in Informatica applications.
• Designed and Developed the ETL processes for various domains like HealthCare, Finance, Logistics and Insurance.
• Interacted with end-users and functional analysts to identify and develop Business Specification Documents BSD and transform it into technical requirements.
• Proficient with RDBMS systems, SQL, OraclePL/SQL,databasedesign and optimizations
• Skilled in Data warehousing, Scripting and Data Modeling, experience in dealing with various Data sources like Oracle, SQL Server, MS-Access, Teradata, MQ Series, Web Servicesand DB2.
• Strong knowledge of Data warehouse design such as dimensional data model, logical and physical design.
• Profound knowledge of ChangeDataCapture CDC technologies.
• Strong knowledge of Informatica PowerExchange real-time and batch mode.
• Worked in Teradata queries, utilities, procedures, macros and tuning code.
• Worked on MLOAD, FLOAD, FEXPORT and TPUMP to load data to DWH system.
• Proficient in creating Oracle Function, Stored procedure, Package, Trigger and Materialized View.
• Worked on design, develops, test, debug and maintain application programs.
• Excellent working knowledge of UNIXshellscripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Worked onscheduler tool Tidal and Control-M to create job for ETL workflows.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Worked on ProductionsupportL2 and L3, Onsite-offshore model and on call support.
• Excellent working knowledge of tracking work status, effort estimation, coordination with various team, reporting and resolving prod issues, creating prod process and run book.
• Worked on Jira to capture bugs, track status and resolution on time.
• Created various connectors for Informatica Cloud to extract and load data.
• Developed and Implemented Error logging, Error handing and Error resolution process in many projects.

Software Skills

Professional Experience

Sr ETL Informatica Developer

Confidential

Roles and Responsibilities:-

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling and using Erwin.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer .
• Actively involved in gathering requirements from the end users
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables..
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized the mappings and increased the re-usability
• Used transformations such as the source qualifier, normalizer, aggregators, connected unconnected lookups, filters, sorter, stored procedures, router sequence generator.
• Checked and tuned the performance of application.
• Created and defined DDL's for the tables at staging area.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Migration between Development, Test and Production Repositories.
• Involved in creating and management of global and local repositories and assigning permissions using Repository Manager. Also migrated repositories between development, testing and production systems.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.
• Installed and configured Informatica Tools on client machine on Windows NT environment.
• Created and performed testing strategy and test plans for any changes/upgrade to informatica mappings
• Involved in UAT Support.
• Involved in Peer reviews of LLDs, mappings, Sessions and PWX data maps.
• Monitoring currently running jobs.
• Worked on performance tuning of queries in project.

Environment:Informatica Power Center 9.1.0/9.5, Workflow Manager, Workflow Monitor, PL/SQL, SQL, Oracle 11g/10 g, Toad 10.6, Oracle 11.6.

SrETL InformaticaDeveloper

Confidential

Roles and Responsibilities:-

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents BRD, explained business requirements in terms of technology to the developers.
• DevelopedDataFlowdiagramsto create Mappings and Test plans.
• The Data flow diagrams ranged from OLTPsystems to staging to Data warehouse.
• DevelopedTestplan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• DevelopedcomplexInformaticamappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD's Slowly Changing Dimension to handle the Incremental Loading for Dimension tables, Fact tables.
• Designedvariousmappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2.
• CreatedInformaticaPowerExchangeRegistration and Datamap.
• Designed and developed real-time data warehouse.
• Worked on Informaticacloud and extracted data from Sales Force source.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Experience in building of the Repository RPD using the OBIEEtoolset.
• Developed OBIEE technology such as Answers, Dashboards, and BI Publisher.
• Identify users and see what level of familiaritydo they have with this data. Segment these users based on criteria like influence, authority and participation levels.
• Identifying automated decision-making possibilities.
• Worked on Teradata utilities BTEQ, MLOAD, FLAOD and TPUMP to load staging area.
• Worked on Audit login, Error login and Reference check while loading data to Data warehouse.
• Created UNIX Script for ETL jobs, session log cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor and Scheduler alert editor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote Unix scripts, Perl scripts for the business needs.Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process.

Environment: InformaticaPowerCenterCloud 9.1, Informatica Power Exchange 9.1, OracleExadata, Teradata13, MSSQL Server 2008 R2, T-SQL, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, Putty, DB2 Mainframe, OBIEE 11g, Informatica Cloud, Salesforce.

SrInformaticaDeveloper

Confidential

Roles and Responsibilities:-

• Involved in Requirement Gathering and Business Analysisand created tech specs for ETL process.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Transfer the source code setup file to outside conversion team for production movement and support. Coordinate with vendor, business, developers tester for UAT and system testing.
• Coordinated with Onsite and Offshore team.
• Consolidate sales order data using Informatica and loaded to aggregate tables for reporting.
• Build the Dimension Facts tables load process and reporting process using Informatica and OBIEE.
• Design, development and implementation. It includes the several modifications, enhancement and maintenance of existing software.
• Worked on Various transformations such as Joiner, Filter, Update Strategy, Expression, Router, Lookup, Union, and Aggregator.
• Administered and developed monitoring scripts for power center server process and workflow jobs.
• Designed and developed enhanced data models and ETL applications to meet the business requirement.
• Used Informatica Power Connect to extract data from third party databases, web services and XML.
• Mapping type 1 type 2 Slowly Changing Dimension SCD using Informatica.
• Timely delivery of ETL tasks is performed using workflow manager and scheduler.
• Worked closely with DBA and developers during planning, analyzing, developing and testing phase of the project.
• Involved in Designing of Data Modeling for the Data warehouse.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Involved in the Performance Tuning of Database andInformatica. Improved performance by identifying and rectifying the performance bottle necks.
• Involved in user acceptance testing. Defect reporting tracking inJira and resolved them.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.

Environment:Informatica Power Center 8.6.1, Informatica Power Exchange 8.6,MS OFFICE/VISIO 2007, Oracle Exadata, DB2Mainframe,UNIX, AIX, Rally, MS Series, Web Services, Java, Tidal, Putty, Basecamp, Erwin 7.5, PL/SQL

ETL/ Informatica Developer

Confidential

Roles and Responsibilities:-

• Designed and developedcomplexmappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Extensively worked on various source like flat files, Databases, XML andWeb services.
• Created and alteredTables, Triggers, Sequences, and other DDL, DML, DCL and utilities of Oracle.
• Extensively worked in the performance tuning of ETL procedures and processes.
• Error checking testing of the ETL procedures programs using Informaticaand Oracle procedures.
• Performance Tuned Informatica Targets, Sources, mappings sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• DevelopedUNIXshellscripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Responsible for productionsupport.
• Any issues with the daily running jobs, find out the errors and fix them within time limit
• Always be on alert 24/7 with a company pager for monitoring daily workflows.
• Mainly responsible for solving Informatica and Database Issues for different departments if ticket is opened.
• Any problem with the ETL codes, prime responsibility was to test in Integration Environment before loading in Production.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results for various tickets.
• Part of documenting and testing all the ETL connections at the time of migration from Old to New Teradata box.
• Used FTP on a few occasions to solve complex supply chain problems.
• Created Oracle Stored Procedure, Function, Cursor, Package and Triggers.

• Wrote Analytical queries to generate report, designed normal and materialized View.
• Optimized mappingshaving transformation features like Aggregator, filter, Joiner, Expression and Lookups
• Created daily and weekly workflows and scheduled to run based on business needs

Environment: InformaticaPowerCenter8.6, Oracle 10g, Teradata V2R5, XML, TOAD,SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Web Intelligence, DSBASIC, Erwin 6.1, Remedy, Maestro job scheduler, Mercury Quality Center

Informatica/Developer

Confidential

Roles and Responsibilities:-

• Collection of requirements from business users and analyzed based on the requirements.
• Extensively used flat files for Designed and developed Informaticamappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking testing of the ETL procedures programs using Informatica session log.
• Performance Tuned Informatica Targets, Sources, mappings sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Performed error handling for removing database exceptional errors.
• Configured InformaticaPower Exchange connection and navigator.
• Created Registration, Data Map, configured Real-Time mapping and workflows for real-time data processing using CDC option ofInformaticaPower Exchange.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked with tools like TOAD to write queries and generate the result.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informaticamappings. Involving also in the functional and technical design document sessions with Technical team and business users team.
• Actively involved in acquiring training on the Portico 8.0/9.0 versions of Provider Manager and Business Administrator modules of Portico.
• Working on the Data Analyzer, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.

Environment:InformaticaPowerCenter8.1,InformaticaPower Exchange 8.1, DB2 Mainframe, Cobol, ORACLE 10g, UNIX, Windows NT 4.0, Sybase, UNIX Shell Programming, PL/SQL, TOAD, Putty, WinScp, Remedy

Informatica developer

Confidential

Responsibilities

• Developed complex mappings to extract source data from heterogeneous databases SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT User Acceptance Testing with user community.
• Extracted data from VSAM file and XML files.
• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and DevelopedOracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Participated in the design of Star Snowflake schema data model.

Environment: InformaticaPowerCenter 7.1, Oracle 10g, SQL Server 2000, Erwin 3.5, XML, TOAD, HP Unix 11.11, Harvest, Sun Solaris, DB2 Mainframe.