Manager Data

Harith Mobile: 989-***-****

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

Professional Summary:

AROUND 6+ years of IT Experience in analysis, design, development, implementation and troubleshooting of Data Mart Data Warehousing applications using ETL tools like informatica power center 10.1/9.5/9.1/8.6/7.1 and power exchange 8.6.

Strong experience in Data Warehousing (ETL & OLAP) environment and acquired excellent analytical, co-ordination, interpersonal skills, have immense leadership potential.

Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.

Expertise in Data Flow Diagrams, Process Models and ER diagrams with modeling tools like ERWIN r 7/4/3.5 & MS VISIO 2010/2016

Adept at understanding Agile software development methodologies and framework.

Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center 10/9.5/9.1 and 8.5

Good Understanding of relational database management systems, experience in integrating data from various data source like Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008/2012, Teradata 13/12/V2R5, Flat files and XML into staging area.

Experience in implementing Slowly Changing dimension methodology (SCD) for accessing the full history of accounts and transaction information.

Experience in implementing complex business rules by creating transformation, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets, Mappings, and Triggers

Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.

Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server

Experience in data integration, cleansing and massaging.

Extensively used Repository Manager, Designer, workflow manager, workflow monitor Client tools of Informatica

Experienced in developing various data extracts and loading routine using Informatica, Oracle stored procedures.

Technical Knowledge:

ETL Tool

Informatica Power Center 10/9.5/9.1/8.6, Informatica Power Exchange 8.6/7.1, Informatica Power Connect, Power Mart

Databases

Oracle 11g/10g/9i/8i/7.x, MS Access, SQL Server 2012/2008/2005

Data modeling Tools

Erwin r7/r4/r3.5, Microsoft Visio 2007/2010, Power designer and Tableau 8.1/8.0/7.1

Utility tools

SQL, SQL* loader, SQL PLUS

Operating Systems

UNIX, Linux, Windows XP/Vista/7/8, Windows server 2003/2008/2010

Scheduling Tools

Tivoli, Autosys, Control-M, Informatica Scheduler

Programming Languages

HTML, ASP.NET, Visual Basic 7.0/6.0/5.0

Professional Experience:

Luxury Investments (LI), New York City

Position: Informatica Developer December 2016 – Present

LI is a leading provider of communications services connecting individuals through cloud-connected devices worldwide. It provides feature-rich, affordable communication solutions that offer flexibility, portability and ease-of-use for both landline and mobile phones.

Responsibilities:

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Involved in extracting the data from the Flat Files and Relational databases into staging area.

Mappings, Sessions, Workflows from Development to Test and then to UAT environment.

Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.

Developed several reusable transformations and mapplets that were used in other mappings.

Prepared Technical Design documents and Test cases.

Implemented various Performance Tuning techniques.

Environment:

Informatica Power Center 10.1, Oracle 11g, Windows XP.

Marfic Software Solutions, India September 2015 – August - 2016

Position: ETL Developer using Informatica Power Center

Marfic Software Solutions Pvt Ltd (MSSP) is an IT services and software development company. It provides quality information technology services to our clients with a blend and breadth of industry experience and talent available at our offshore delivery center.

Studied data sources by interviewing users.

Wrote database scripts for user management and roles.

Created, monitored and maintained Oracle databases.

Configured ODBC connectivity for new instances and clients.

Extracted data from various data sources such as Oracle 8i, Flat files, DB2 10.5 and transformed and loaded into targets using Informatica.

Created mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.

Used various performance tuning techniques to improve the session performance (Partitioning etc).

Used Informatica client tools – Designer, Workflow Manager, and Workflow Monitor.

Generated completion messages and status reports using Workflow manager.

Developed, managed and tested back-up and recovery plans

Environment: Informatica PowerCenter 8.6, Oracle 8i, SQL PLUS

Apollo Health Insurance, India

Position: Informatica Developer July 2013 – September 2015

This position requires implementing data warehousing for forecasting, patient data, employee data and patient reports. This data is obtained from tables of relational database. I was involved in extracting, transforming and loading of data using various transformations including router transformation, union transformation, lookup transformation, update strategy, source qualifier transformation, pre and post SQL, used oracle to write SQL queries that create/alter/delete tables and to extract the necessary data.

Responsibilities:

Analyzed various schemas for implementation and modeled the Data Warehousing Data marts using Star Schema.

Created mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.

Extracted data from flat files and oracle database, applied business logic to load them into the central oracle database.

Developed complex mappings & mapplets in Informatica to load the data using different transformations.

Created and monitored Sessions and Batches using Server Manager.

Used various performance tuning techniques to improve the session performance (Partitioning etc).

Successfully moved the Sessions and Batches from the development to production environment.

Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.

Generated completion messages and status reports using Workflow manager.

Created workflows and worklets for designed mappings.

Developed mappings and loaded data into relational database. Worked on Dimension as well as Fact tables.

Extensively used SQL procedures and functions to build business rules.

Environment: Informatica Power Center 8.6, Oracle9i, MS Visio 2013, Tableau 8.1, SQL

Education:

Masters of Science in Information Systems/ Business Intelligence

Bachelors of Technology in Mechanical Engineering

Contact this candidate