KUMARASWAMY.N

acw0gi@r.postjobfree.com

201-***-**** ETL Informatica Developer

PROFESSIONAL SUMMARY:

Around 8 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica Power Center 9.x/8.x/ 7.x. Informatica IDQ 9.X,MDM.

I have good experience in Informatica Installation, Migration and Upgrade Process.

Expertise in defining and configuring Informatica MDM Hub configurations – Data Mappings, Data Validations (landing, staging and base objects).

Expertise in Informatica IDQ Match and Merge Rules, Batch Jobs and Groups and Proactive Monitoring tool.

Extensive experience in Data warehousing, Data Analysis, Data Profiling, Reporting, Development, Maintenance, Testing and Documentation.

Experience in using Informatica Power Center Transformations such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and XML files.

Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.

Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.

Database experience using Oracle 11g/10g/9i, Teradata, MS SQL Server 2008/2005/2000 and MS Access.

Experience in UNIX Operating System and Shell scripting.

Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.

Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts and Data warehouse using Informatica Power Center.

Used Debugger in Informatica Power Center Designer to check the errors in mapping

Experience in writing complex SQL queries.

Excellent skills in fine tuning the ETL mappings in Informatica.

Actively involved in Daily check in meetings to discuss on the production issues and resolved

24*7 Production Support to fix data quality issues and also supported ETL failures

Extensive experience using database tool such as SQL *Plus, SQL *Developer, Autosys and TOAD.

Effective working relationships with client team to understand support requirements, and effectively manage client expectations.

Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

Worked on EDM tool for financial data Processing and reconciliations. Worked on Data Porter, Data Solutions, Generator, Inspector and Data Constructor.

Managing Amazon Web Services (AWS) infrastructure with automation and configuration management

EDUCATION:

Bachelors in Engineering, India.

TECHNICAL SKILLS:

ETL Tools

Informatica 9.x/8.x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect) Informatica Data Quality (IDQ), Data Quality/IDE.

Data Modeling

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

Databases

Oracle 11g/10g/9i/8i,Teradata,MS SQL Server 2008/2005/2000, MS Access and DB2

Languages

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

Web Technologies

XML,HTML, Java Script, AWS

Tools

Toad, SQL* Developer, Autosys, ERwin

Operating Systems

Windows Server, NT/2008/2003/XP/Vista/7, UNIX, MS-DOS and Linux

PROFESSIONAL EXPERIENCE:

Client: Wells Fargo, NC Apr 2016 - Till date

Role: ETL Developer

Responsibilities:

Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process.

Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design and development.

Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data.

Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.

Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.

Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.

Handled versioning and dependencies in Informatica.

Developed schedules to automate the update processes and Informatica sessions and batches.

Resolving technical and design issues.

Developed data transformation processes, maintain and update loading processes.

Developed and implemented the UNIX shell scripts for the start and stop procedures of the sessions.

Used UNIX shell scripts to run the batches.

Developed standards and procedures to support quality development and testing of data warehouse processes.

Actively involved in Daily check in meetings to discuss on the production issues and resolved

24*7 Production Support to fix data quality issues and also supported ETL failures

Environment: Informatica 9.5.1, Informatica Data Quality (IDQ), IDE Data Management, MDM, Oracle11g, SQL Server 2008, Autosys, Windows Server 2008, UNIX.

Client: Bank of America, NC Apr 2015- Mar 2016

Role: ETL Developer

Analyzed the business systems, gathered requirements from the users and documented business needs for decision supporting data.

Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.

Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.

Designed & developed multiple cleanse function, Graph function and standardization scenarios using IDQ.

Analyzed data from a variety of data sources to present a cohesive view of the data and completed data profiling using IDE on various source systems to understand the data.

Involved in integrating the change in the workflow to both test and allow error handling using Informatica IDQ 9.5 and developed solutions based on the data governance.

Extensively used Full Pushdown Optimization in Informatica to performance for DB loads.

Prepared technical documentation to map source to target.

Designed, Developed, Deployed and implemented ETL mappings using Informatica

Migrated Workflows, Mappings, and other repository objects from Development to QA and then to production.

Responsible for performance tuning at all levels of the Data warehouse.

Created Informatica sessions in workflow manager to load the data from staging to Target database.

Prepared technical design/specifications for data Extraction, Transformation and Loading.

Using Aggregator transformation calculated SUM, AVG of monthly sales for different products.

Created different target schemas for Staging and Data Mart.

Designed the Mapping Design documents and the Deployment Documents.

Designed and Developed several mappings to Load the Dimensions and the fact tables using transformations like XML, Union, Expression, Filter, Aggregator, Lookup and Router etc.

Worked with Flat files and XML files generation through ETL process

Generated XML files as target to load into the vendor customized application to generate the reports.

Involved in XML and XSLT coding in order to create the Front End screen insert activities

Implemented Slowly Changing Dimensions Type1, Type 2.

Environment: Informatica 9.5.1, Oracle11g, IDQ, IDE Data Management, MDM, SQL Server 2008, TOAD, SQL Navigator, Windows Server 2008, UNIX.

Cigna, Hartford, CT Jan 2014 - Mar 2015

ETL Developer

Enterprise Data warehouse

Project Description: The Enterprise Data warehouse (EDW) is system we all the insurance data will be maintained of the customers. The Cigna is offering different types of Insurance for their customers like Health, Auto, Property, Rental etc. To maintain all these transactions history a centralized application is built that’s called EDW.

Responsibilities:

Gathered user Requirements and designed Source to Target data load specifications based on business rules.

Used Informatica Power Centre 9.0.1.for extraction, loading and transformation (ETL) of data in the datamart.

Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.

Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table

Performed and used data profiling tools (IDE) and techniques, and development of review and QA data requirements.

Integrated the change in the workflow to test and allow error handling using Informatica IDQ and developed solutions based on the data governance.

Designed and developed ETL Mappings to extract data from Flat files and Oracle to load the data into the target database.

Developing several complex mappings in Informatica a variety of Power enter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power enter.

Built complex reports using SQL scripts.

Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.

Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normaliser and Sequence generator transformations.

Design roles and groups for users and resources using AWS Identity Access Management (IAM).

Ran the workflows on a daily and weekly basis using workflow monitor.

Environment: Informatica 9.0.1, Informatica Data Quality (IDQ),IDE, Data Quality, PL/SQL, AWS, Framework Manager, Teradata,Oracle 11g, TOAD, Windows Server 2008, UNIX.

Client: MediMedia, Yardley, PA Jan 2013 - Dec 2013

Role: ETL Developer

MediMedia is a leading multichannel marketing provider of promotional health care-related campaigns. It delivers a suite of sampling and fulfillment services for the pharmaceutical and biotechnology industries. Project is to enhance fulfillment maintenance application by authoring new reports for tracking fulfillment activity, unit redemption trend analysis and LIT packages.

Responsibilities:

Participated in all phases of system development life cycle from requirements gathering to deployment of the finished system into production followed by maintenance and knowledge transfer tasks.

Gathered requirements by analyzing source systems and identification of business rules through regular requirements gathering sessions with business users and other support teams for various OLTP and OLAP systems.

Used Power Center Designer to design the business process, grain of the data representation, dimensions and fact tables with measured facts.

Extensively used Transformations like lookup, Router, Filter, Joiner, Source qualifier, Aggregator, Update strategy, Etc.

Involved in performance tuning of sessions that work with large sets of data by tweaking block size, data cache size, sequence buffer length and target based commit intervals.

Developed sessions and batches to move data at specific intervals and on demand using workflow manager.

Participated in deployment planning and in deployment of the system to production.

Facilitated business user smoke testing of the production system by setting up test data.

Involved in production support duties including monitoring of nightly batches.

Responsible for updating business stakeholders and OLTP/OLAP application support teams about the status of various ETL sessions and the impact of failed sessions on data availability.

Environment: Informatica Power Center 9.1.,IDQ,Teradata,Oracle10g, SQL*PLUS, TOAD, DB2, UNIX, Windows

Client: ICICI, India Sep 2011 - Dec 2012

Role: Informatica Developer

ICICI Bank is a rapidly growing Banking and credit card company in INDIA. The company was interested in developing several Data Marts, Operational Data Store and Enterprise Data Warehouse from the historical, transactional and financial data for analysis by different business units within the Bank.

Responsibilities:

Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.

Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.

Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.

Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on target table.

Used the Informatica Server Manager to register and monitor the server, create and run the sessions/batches for loading the data using the earlier created mappings.

Created mapplets and reusable transformations.

Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.

Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Power Center 8.x, Repository Manager, Designer, Oracle 8i, SQL, UNIX, Win 2000/NT.

Client: Bharatronics, India Nov 2008 – Aug 2011

Role: Database Developer

Project - 2:

Involved in the design and development of Inventory Control System. It provides information like products available, quantity on hand, vendor information, vendor evaluation etc. The basic functions include receiving indents from various departments and consolidating, generating tender documents, quotation evaluation, generating purchase orders and amendments, scheduling of material receiving, generating goods receipts, preparing material rejection notes, invoice verification etc.

Responsibilities:

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Writing queries to fetch data from the OLTP system and executed at regular intervals of time.

Modified existing forms, reports, and graphs as per the enhancement.

The backend was in Oracle and database operations were handled using stored procedures.

Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.

Moved data from one database to other database, Used SQL*Loader for data migration.

Environment: Oracle 8i, SQL, TOAD, UNIX, Windows 2000/03/NT

Project -1:

Developed a financial accounting system named CPD. This is an application to maintain a database about the customers who are financed for motor vehicles and their guarantors. The system maintains the contract information, restructures the payment procedure and generates reports including monthly collection/income and list of defaulters.

Responsibilities:

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Writing queries to fetch data from the OLTP system and executed at regular intervals of time.

Modified existing forms, reports, and graphs as per the enhancement.

Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.

Moved data from one database to other database, Used SQL*Loader for data migration.

Environment: Oracle 8i, SQL, TOAD, Windows.s

Contact this candidate