ETL Informatica Developer

Praveena Chandrasekaran

Email: *************@*****.***

Professional Summary:

7+ years of IT experience in all stages of SDLC Analysis, Design, Development, Implementation, Testing and Production Support of Data Warehousing, Business Intelligence & Optimization and Data Integration Solutions using Informatica Powercenter 9.x,8.x7.x/Power Exchange.

Knowledge in Full Life Cycle development of Data Warehousing.

Experience in developing end to end BI solutions for enterprise level data warehouse.

Created UNIX shell and Perl scripts to run the Informatica workflows and controlling the ETL flow.

Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.

Proficient in the Integration of various data sources with multiple databases like Oracle11g /Oracle10g/9i, MS SQL Server, IBM DB2 VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.

Proficiency in developing SQL and database designs with various databases like Oracle, SQL Server, etc.

Experience in scheduling of ETL jobs using Crontab, Control-M.

A good team player, self- motivated and possess excellent analytical and problem solving skills.

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Expertise in Relational, Dimensional Data modeling, Star schema modeling, Snowflake modeling using CA Erwin.

Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.

Independently perform complex troubleshooting, root-cause analysis and solution development.

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good verbal / written communication skills.

Strong with relational database design concepts and slowly changing dimensions.

Technical Expertise:

Databases

Oracle 12c/11g/10g/9i/8i/7.3, SQL SERVER 2005/2008, DB2, MS Access, IBM DB2 UDB 8.0/7.0, DB2/400, Flat File Systems, XML Files,Teradata.

GUI

Forms 10g/6i/4.5, Reports 10g/6i/2.5, Oracle Discoverer 6i,Crystal Reports 10, Java,

Tools and Utilities

TOAD, SQL*Plus, SQL Navigator, Erwin, TK-Prof, UTL_File Packages, Business Objects6.1, SQL*LOADER, TKProf, Stats pack, Informatica, Load Runner, Quality Center, Autosys, Crontab, TWS.

Web Technologies

ASP,HTML,DHTML,JAVA, JSP

Programming Languages

C, C++, Unix shell scripting, PL/SQL,MY SQL

ETL Tools

Informatica –Power Center 6.x/7.x/8.x/9,x, Power Exchange,ODI (Oracle Data Integrator),Power center Data Transformation studio.

Data Modelling

Relational modeling, Dimensional Data modeling- Star schema, Facts & Dimensions using CA Erwin etc.

Version Controls

SVN, IBM Rational Clear Case/RTC

OS

Windows NT/XP/2000, Linux, Sun Solaris, HP-Unix,

Education, Awards, Appreciations & Certificates:

Bachelor of Science, Mathematics, Madras University, Tamil Nadu, India – May 2007

Netezza Bronze Certified.

Retail Domain Certified.

Received ‘Beyond Performer’ for outstanding performance.

Successful completion and live implementation of the Pilot 1 project.

Successful completion and live implementation of the SP6 project.

Appreciated as ‘Dedicated and Successful Team ‘from Client.

Professional Experience:

Client: Motorola Mobility LLC, Chicago IL Apr ’15 – Till Date

Project: Global EComm – Brazil

The Motorola Global eCommerce objective is to implement a global direct-to-consumer (D2C) eCommerce sales channel. This eCommerce channel will sell Motorola CTO phones, Legacy Sales Model, Companion Products, and service products through the Motorola.com websites in Brazil. This is an international expansion of the existing U.S. eCommerce channel and will integrate with Motorola's current business systems and web technology infrastructure being used for the U.S. model.

Role: Sr. ETL Informatica Lead

Responsibilities:

Extensive hands on experience in ETL domain. Have Designed, Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Power Center -Designer to extract the data from source systems to target systems.

Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target.

Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.

Created mapplets, mappings, complex worklets and workflows.

Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.

Solid extensive exposure to PLSQL and UNIX Shell Scripting.

Extensively worked on OBIEE testing.

Have migrated the code into different instances using kintana application.

Have involved in resolving the issues faced during the testing.

Prepared unit test cases and SIT test cases.

Have done unit testing, SIT testing and UIT in different instances.

Tested and compared data on OBIEE results with Database results.

Worked as an ETL onsite coordinator at client site.

Involved in meetings to gather information and requirements from the clients.

Analyzed the requirements to identify the necessary tables that need to be populated in to the staging database.

Interacted with users about the requirements and reported the status of the project on weekly basis.

Coordinated with offshore team and conducted meetings twice a day to discuss on project status up-to-date.

Have documented design, requirement documents. Documented clearly the implementation release notes to production team to implement the code correctly in production.

Played a crucial role as a team lead and delivered project to users on schedule.

Involved in the Analysis, Design, Coding and testing of the ETL mappings.

Created LLD's, HLD's and test case documents.

Environment:

Informatica powercenter6.1/8.1, Oracle, Winscp, OBIEE, Unix Shell scripting, Kintana, Citrix.

Client: Motorola Mobility LLC, Chicago IL Dec ’13 – Apr ‘15

Project: Verizon CTO

Motorola’s Mobile Devices portfolio includes a broad array of converged devices including smart phones based on the Android™ operating system, as well as tablets and Bluetooth® accessories. Motorola Mobility addresses the needs of consumers and businesses to deliver Internet services, email, social networking and entertainment in the palm of one’s hand. Implementation of Verizon POS project enables the Configure to order (Arctic Fox) capability for Verizon customers.

Role: ETL Informatica developer

Responsibilities:

Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.

Developed mappings for implementing type I and type II slowly changing dimensions and dimensional hierarchies and aggregates.

Design of System Test cases and implementing integration testing.

Working on Teradata External Loaders using Informatica.

Developed shell scripts for loading the data from the operational data store (ODS) into the staging area in the warehouse.

Extensively worked on performance tuning of mappings, sessions and various ETL Processes.

Responsible for creating user groups, privileges to the users using repository manager.

Responsible for repository creation, node creation, domain startup/shutdown, bouncing nodes on Informatica server.

Mentoring other developers in technical and business aspects.

Created reports for availability of Informatica server using BAC monitoring tool.

Involved in business analysis and technical design sessions with business and data architect to develop requirements document, data models and ETL specifications.

Developed error handling mechanism to load invalid records into error table with an appropriate status. The status of the record determines whether the record is to be reprocessed with the next day load.

Involved in OBIEE Administration for creating user accounts, granting privileges, creation of security groups, creation of dashboards, deployment of catalogs into UAT and Production, bouncing services of OBIEE.

Wrote shell scripts to kick off workflows, send out notifications on failure.

Used Post and Pre session commands to call scripts which Drop, recreate indexes, run reorg and runstats on the warehouse table which was loaded.

Environment:

Informatica 8.6.1, Linux, Windows NT/2000, Clearcase and Kintana tools, OBIEE Admin.

Client: Transunion, Chicago IL July ’12 – Dec‘13

Project: CRS – Consumer Relations System

TransUnion LLC is one of the leading Credit History information providers in USA. At TransUnion, CRS is a consumer relation cell, which caters to all credit report related needs of a consumer. The scope of the project is to work on the credit reports of the consumers based on the request. Worked very closely with customers, end users and powered users collect requirements and training or resolve any business process related issues.

Role: ETL Informatica developer

Responsibilities:

Created User defined functions to reuse the logic in different mappings.

Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.

Creation of sessions and workflows according to the data load in to different systems.

Data investigation in the analysis of incoming data from the various source systems, documenting the data anomalies and generating Data Quality reports.

Involved in different phases of testing like Unit, Functional, Integration and System testing.

Creation of Review documents for specification document and test cases.

Performance tuning of targets, sources, mappings and sessions.

Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer.

Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts.

Wrote and reviewed documents like Functional Specifications, Data Mapping Sheets and Technical Specification Documents.

Prepared documents like Deployment Doc, Estimation Reports, Development tracking report and weekly status Reports

Established standard code migration process.

Extracted data from a wide variety of sources like flat files, XML files, Relational Databases (Oracle, SQL Server) and from the legacy mainframe systems by using Informatica Power Exchange.

Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Stored procedure, XML and Sequence generator transformations.

Environment:

Informatica 8.6.1, Toad, Quality Center

Client: Royal Bank of Scotland, Stamford CT July ’11 - July ‘12

Project: Pilot 1 SUAM – Strategic User Access Management

In 2009 RBS acknowledged that, although significant improvements have been achieved, the previous user access programs had not fully delivered their objectives. Multiple issues have been found in the previously implemented applications which led in to the decision of launching a new program called Strategic User Access Programme (SUAMP).

SUAMP is designed to:

Define and support the implementation of people, process and technology solutions that underpin the strategy.

Deliver tactical short-term solutions to support the business as the long term strategy is implemented.

The scope of the project is to develop a Group-wide user access strategy that is consistent across the Group but is flexible and risk based.

Role: Informatica developer

Responsibilities:

Involved in the Analysis, Design, Coding and testing of the ETL mappings.

Created LLD's, HLD's and test case documents.

Created documents like code review check list, Migration check list.

Involved in performance tuning of Informatica jobs.

Created and performed unit testing.

Involved in all the existing releases and helped the team in resolving critical issues.

Created reusable objects like Mapplets, Reusable Transformations and work lets.

Involved in the design of historical load and incremental load Process.

Develop ETL deployment plan and ETL operations manual to coordinate and drive ETL activities in Test and Production environment.

Worked with the QA team to test the code.

Environment:

Oracle 9i, PL SQL, Pro *C, SQL Plus, Visual Source Safe, Pl Sql developer, Toad, Putty, Windows 2000 and UNIX.

Client: Lowes, Mooresville NC Dec ’10 – June ‘11

Project: SP 6 – Services Platform 6

Lowes is a U.S.-based chain of retail home improvement and appliance stores that has retail stores in the United States, Canada, and Mexico. Currently, Lowe’s administered Extended Protection Plans (EPP) covers only Major Appliances (MAJAP) sold by Lowe’s. The non-MAJAP list of categories (BOR) are covered under National Electronics Warranty (N.E.W) administered EPPs and RPs which implies that any post sales services (Repairs / product replacements) for non-MAJAP will be done through N.E.W contract. Going forward Lowe’s business must be able to service (Repairs/Product Replacements) their customers through Lowe’s administered EPPs and RPs for all the serviceable / eligible products.

The scope of the project is to achieve this Lowe’s will start selling Lowe’s administered EPPs/RPs for BOR product categories and also provide repair service for those products with the ability to determine based on business rules, which products are eligible for repairs, and the proper payment disposition of the associated repair requests.

Role: Informatica Developer

Responsibilities:

Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.

Fine-tuned existing Informatica maps for performance optimization.

Created sessions, batches for incremental load into staging tables and scheduled them to run daily.

Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

Design complex mappings involving constraint based loading, target load order.

Involved in gathering requirements and created design documents and mapping documents.

Involved in design, development and modification of ETL mappings and stored procedures in an optimized manner. Involved in Unit Testing and System Testing stages.

Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.

Worked on bug fixes on existing Informatica Mappings to produce correct output.

Environment:

Informatica Power Center 7.X, Oracle, MS SQL Server 2005, Oracle, windows, Mainframes, EFT, FTP, SQL Plus, My SQL Workbench.

Client: Nielsen, Chennai India Dec ‘09 – Dec‘10

Project: C2C - Client to Customer

Nielsen Media Research (NMR) measures media audiences, including television, radio, theatre films and newspapers. Customers use NMR’s television audience research information to buy and sell television time as well as to make program decisions. That information is the currency in all the transactions between buyers and sellers. The scope of the project is to create custom reports based on Nielsen media research National and Hispanic audience estimates.

Role: Oracle Programmer

Responsibilities:

Gathered the requirement from the client and translated the business design into Technical design.

Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.

Designed forms and reports according to the client requirements. In various applications

Created Triggers, procedures and functions are developed in this reports using PL/SQL.

Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.

Prepared Mapping documents and design documents for data conversion.

Developed validation procedures and error reporting on the data in the intermediate tables. Created user defined Exceptions while handling exceptions.

Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment:

Oracle10g (SQL/PL/SQL), Toad, SQL*Plus, SQL Developer 1.5.5, UNIX, Scripting (Shell and Perl), PERL, Informatica Power center 9, Quality Center 10.0.

Client: Nielsen, Chennai India Apr ’09 – Dec‘09

Project: MB – Market Breaks and Sigma

Nielsen Media Research (NMR) measures media audiences, including television, radio, theatre films and newspapers. Market Breaks is a web based tool which lets the users to analyze Nielsen Media Research market breaks across Broadcast network, Syndication and cable network sources at weekly level based on the National Nielsen People Meter Sample and produce customized reports. It allows clients to directly request and analyze pre-aggregated market break ratings data for multiple programs and for extended periods of time. It also creates analyses based on specific target audiences and competitors, using combinations or subsets of data in addition to those in the standard published Nielsen Media Research reports. The scope of the MB project is to analyze Nielsen Media Research market breaks across Broadcast network, Syndication and cable network sources.

The scope of the SIGMA project is to monitors TV Stations, Cable, and Satellite systems for occurrences of these video events in over 200 markets and reports where and when any were broadcast.

Role: Database Programmer

Responsibilities:

Participated in meetings with users, Business analysts in understanding the business requirements.

Involved in writing the UNIX shell scripts to automate Oracle jobs.

Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.

Involved in preparing program flows and test plans.

Involved in fixing the bugs at the runtime.

Developed and maintained the reusable codes as Common Library routines.

Environment:

UNIX, Windows NT, Oracle 9i, SQL, PL/SQL, SQL * Plus, Toad.

Client: Health Net June ’08 – Apr ‘09

Project: Health Net DW

HN Enterprise data warehouse deals with different kinds of health claims which are categorized as Institutional, Professional, Outpatients and Inpatients. Health Net gets the source data for Members, Claims, Brokers, Providers, Payers, Beneficiaries, payees etc, from various source systems like AS400, Oracle, SQL Server, DB2 and Mainframe. This data will be loaded in to EDW based on different frequencies as per the requirement.

The core objective of this project was to build enterprise data warehouse and consolidates strategic information pertaining to customer, vendor, and its related transaction to facilitate metric collection and further analysis of operation data. The tables were populated with Members, Claims, Brokers, Providers, Payers, payees and Beneficiaries related data using ETL process.

Role: ETL Developer

Responsibilities:

Created the Informatica Mappings, Sessions and Batches, ensuring the Business Rules and Data Validation.

Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.

Involved in preparing ETL and Reporting Design Documents.

Maintained the documentation for errors occurred.

Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.

Involved Unit testing the mappings and sessions.

Involved in Production Support Activities.

Environment:

Informatica Power Center 7.x, Oracle 9i, windows, Mainframes, DB2, Oracle, SQL Plus.

Contact this candidate