Data Software Developer

Professional Summary:

Having *.*+ years of experience in Software life cycle in Data warehouse and service oriented applications and developing Strategies for Extraction, Transformation and Loading mechanisms using Informatica and Oracle database..

Ability to interpret and implement complex business rules.

Knowledge in SQL and exposure to Oracle 10g/11g.

Implemented Type 1, Type2 slowly changing dimension mappings based on user requirements.

Strong understanding of Dimensional Modeling, Star, Snowflake.

Data cleansing, scrubbing and validating the data before loading the data into Data warehouse.

Designed and developed mappings from various transformation logic using expression, rank, sorter, joiner etc.

Created Informatica mappings to build business rules to load data. Most of the transformations were used like the Source qualifier, Update strategy, lookup, Filter & Sequence generator.

Extensive expertise in implementing complex business rules by creating reusable transformations and mappings/mapplets.

Experience in the areas of data aggregation, data version/cleansing, data conversion, data load, performance tuning, data quality profiling.

Experience in loading data from fixed width, Delimited flat files to Oracle database.

A self-starter, target-oriented, self-disciplined and proactive professional with good communicational, interpersonal, intuitive skills with ability to work effectively on multiple tasks both as individual contributor and team environments.

Experience:

Working for Symphony Teleca as Senior software developer from 2014 Mar to till date.

Worked for Ness Technologies as Software developer from 2012 Sep to 2014 Feb.

Educational Qualifications:

MCA from SASTRA UNIVERSITY with 65%

Technical Skills:

ETL Tool : Informatica PC 8.x & 9.x

Frontend Tool : Toad 9.5/10.5

Databases : Oracle 10g, 11g

Languages : SQL

Operating System : Windows XP, Windows 7 & 8, UNIX

Project Experience:

Project #1

Project Name : Bank of America

Client : Bank of America, US

Duration : 2014 Mar to till date

Domain : Banking

Role : Informatica Developer

Environment : Informatica Power center 8.6.1,Oracle 10g/11g, Sql, Toad 9.5/10.5,Unix

Project Description:

Bank of America is one of the largest bank holding companies in the United States with its head quarters located in Charlotte, NC. Bank of America operates in all the states of U.S. and 40 other countries. It covers approximately 57 million consumers and small business relationships having 5900 banking centers and 18, 000 ATMs. This project is developed for maintaining a catalogue of all the products that are offered online to the customers. It involved extraction of data from multiple Source systems and loading them through an ETL process in to staging tables and then in to Target tables.

Responsibilities:

Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.

Extensively involved in writing ETL Specifications for Development and conversion projects.

Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.

Involved in requirement definition and analysis in support of Data Warehouse.

Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.

Defined and worked with mapping parameters and variables.

Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.

Performed the performance evaluation of the ETL for full load cycle.

Created test cases for unit testing and functional testing.

Analysing the job running time and improving the performance.

Performed Unit tests and validates results with Business Analyst and end users

Interaction with the offshore team on a daily basis on the development activities.

Project #2

Project Name : ING US

Client : West Chester, US

Duration : Sep 2012 to 2014 Feb

Domain : Financial

Role : ETL Developer

Environment : Informatica Power center 8.6.1/9.1.0,Oracle 10g, Sql, Toad 9.5

Project Description:

ING Group operations in the U.S are performed through ING. U.S which provide large financial services to retail and institutional clients, which includes annuities, retirement plans, mutual funds, life insurance, direct banking etc. This project involved extraction of data from multiple sources and transform the data as per the business logic and is loaded into the data Warehouse which is finally used for reporting.

Responsibilities:

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

Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.

Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.

Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.

Used various transformations like Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.

Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.

Used Variables and Parameters in the mappings to pass the values between mappings and sessions.

Implemented restart strategy and error handling techniques to recover failed sessions.

Did performance tuning to improve Data Extraction, Data process and Load time.

Wrote complex SQL Queries involving multiple tables with joins.

Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.

Contact this candidate