Confidential

Role: Sr Software Engineer

Responsibilities:

• Involved in designing of Informatica mappings by translating the business requirements.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Involved in configuring Informatica cloud, Database Connection, ETL design and Data processing.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target table in efficient manner.
• Crated Mapplet and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter Files, round robin and Key range Partitioning.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Involved in creating RPD, Logical design, reports, answers and connectivity.
• Involved automating retail prepaid system process and enhance the process.
• Created Function, Packages and Triggers and dependencies of the processes.
• Involved in support, maintaining, enhancing and developing new interfaces for application.
• Created Teradata Utilities like MLOAD, FLOAD and DATA PUMP.
• Created Unix Script for ETL jobs and archiving file processes.
• Created PowerExchange Registration, DataMap and configured recovery processes.
• Created three tire testing process and involved in reviewing mapping and UTCs

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.1/8.6, Teradata 13, WinSQL, Oracle 11g, DB2, SQL server 2007, Flat files, PL-SQL, Sun Solaris, Cognos, ESP, Putty, MQ Series, XML, Erwin 7.1, Unix, MLOAD, BTEQ and FLOAD.

Confidential

Role: Sr Informatica Developer

Responsibilities:

• Attended web conference with Business Objects.
• Created Web Intelligence reports with dynamic objects that are linked to the values those are returned from the database.
• Used Autosys for Scheduling Informatica batch and stand alone sessions with different jobs.
• Involved tuning the session performance by using various techniques.
• Work closely with database administrators and reporting team to ensure data is refreshed for each cycle and balancing the reports of converted data.
• Involved in supporting the project and resolved production issues.
• Converted different Line of Business: XL Property, XL Casualty, XL Excess of loss based on business rules.
• Involved in the Software Development Life Cycle.
• Developed stored procedures for generic values instead of using the sequence generator transformations.
• Extract the data from RSG application to staging area thru flat files and Tables.
• Implemented Dashboards Analytics using Business objects Performance manager.
• Upload the data from staging area into Destiny database
• Extract the data from RSG application to staging area thru flat files and Tables.
• Understand the business functionalities of XLRe CONFIDENTIAL CONFIDENTIAL OBU's data and convert them into Destiny Application based on Destiny Business rules.
• Involved in Migrating BO 6.5 to BO XI R2.
• Worked on Web Services to consume and send data.
• Worked on MQ Series Source, target, XML transformation and generator

Environment: Informatica PowerCenter9.1/8.1.1, Informatica PowerExchange 9.1/8.1, Business objects XIR2/6.5, Oracle 10g, Win SQL, UNIX, LINUX, Cognos, Teradata, Autosys, CVS and Test Tracker

Confidential

Role: Consultant Program Analyst

Responsibilities:

• Involved in the documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and lead design reviews to assure compliance.
• Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Performed QA work to verify the results provided from other teams.
• Worked with various file formats like fixed length and delimited.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Maintained the proper communication between other teams.
• Utilizing the existing UNIX shell scripts to run the informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participates in on-call support for ODS and the data warehouse.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica PowerCenter7.1/8.1, Windows2000, Business Objects XIR2/6.x, WEBi, Crystal Reports, LDAP, , Autosys, SQL Server, Documentum, Teradata, Defect Track tool

Confidential

Role: ETL Developer

Responsibilities:

• As a team member involved in collecting all the requirements for building the database.
• Involved in Creation and designed required tables, indexes and constraints for all production activities.
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center.
• Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing them into targets.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Involved in Data Modeling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.
• Used SQL, PL/SQL for database related functionality.

Environment: Informatica Power Center 7.1, Teradata V2 R6, SQL, Windows XP, SQL Assistant, UNIX Shell Script.