Karthik R. Profile

0,0

(0 comentarios)

Ahora estás siguiendo a

Error al seguir a usuario.

Este usuario no permite que los usuarios lo sigan.

Ya estás siguiendo a este usuario.

Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.

Dejaste de seguir correctamente a

Error al dejar de seguir al usuario.

Has recomendado exitosamente a

Error al recomendar al usuario.

Algo salió mal. Por favor, actualiza la página e intenta de nuevo.

Email verificado correctamente.

$30 USD / hora

hyderabad,

india

$30 USD / hora

Aquí son las 9:58 a. m.

Se unió el abril 21, 2014

0 recomendaciones

Karthik R.

@karthik0313

0,0

(0 comentarios)

0,0

$30 USD / hora

hyderabad,

india

$30 USD / hora

N/A

Trabajos finalizados

N/A

Dentro del presupuesto

N/A

A tiempo

N/A

Tasa de recontratación

ETL Informatica developer

Karthik Reddy B Mobile: [login to view URL] Email: Professional Summary:  Having 3.5 Years of Experience on ETL Informatica Power Center.9.1/8.6  Having Good knowledge on Data Warehousing and Business Intelligence concepts with emphasis on Extraction Transformation and Loading data of a business process including development, testing and implementation.  Extensive experience using Informatica components Designer, Workflow Manager, Workflow Monitor.  Involved in Performance tuning of mapping, sessions.  Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.  Experience in Oracle9i/8i, SQL Server.  Experience in working with different data sources like Flat Files, RDBMS.  Having Good Understanding of Dimensional Modeling like Star Schema, Snow Flake Schemas.  Good Knowledge of SQL and PL/SQL  Knowledge of UNIX Script. Experience Details:  Working as an associate consultant in Ness Technologies, Hyderabad from Oct 2013 to till date.  Worked For Dell, Bangalore From June 2011 to Sept 2013. Education Details:  [login to view URL] (Computers) From Hyderabad Educational and Research Centre, Hyderabad, Passed Out 2011. Technical Skills: ETL : Informatica Power Center 9.1/8.6. OLAP Tools : Business Objects. Database Languages : SQL Server 2005, Oracle 9i/10g. Operating Systems : Windows NT and UNIX.

Ver todo Internet Marketing Specialists en India

Contacta Karthik R. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Comentarios

Cambios guardados

¡No hay comentarios para ver aquí!

Experiencia

Old National Bank

oct 2013 - ago 2014 (10 meses, 1 día)

Role : ETL Developer Duration : Oct 2013 to till date. Description: Old National Bank is a multi-billion dollar, multi-state Financial Services company Headquartered in Evansville, Indiana. As the largest Independent banking company Based in Indiana, It is providing to customers with a comprehensive range of financial Products and services, including Commercial and Retail Banking, Credit Card Services, Electronic Banking, Trust and Asset Management, Brokerage and Insurance Services. This bank involved in amounts for various purposes like Personal Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The company requires different level of analysis regarding loan amount, type of customers’ type of payment schedules, interest rates, defaulters list and the penal interest calculations, etc. The data warehouse, basically it is a Data Mart as it covers only one domain of the business and captures data from their Historical Database. This system is required to extract, transform, and load data from the different client system into a relational table environment that can be accessible for reporting purposes. A set of reports will be developed against the relational tables to deliver the information to its customers in the form of PDF files. The data from the different systems will be extracted into a set of text-based and Graphical reports. Responsibilities:  Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.  Extracted source data from flat files, Oracle and loaded to an Oracle.  Developed mappings in Informatica Power Center Designer to load data from staging environment to warehouse.  Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.  Checked and tuned the performance of Informatica Mappings.  Involved in Creating Sessions, Workflows Using Workflow Manager  Involved in testing the mappings (UNIT testing). Environment: Windows NT, Informatica Power Center 8.6, Oracle 9i, UNIX.

LEAD Communications

sept 2012 - sept 2013 (1 año)

Project : Telecomm Analysis Data Warehouse Client : LEAD Communications, UK Role : ETL Developer Description: Sales Analysis system provides Data warehousing solution for LEAD Communications Company, UK. LEAD Communications is an Electrical and Communications company. This company is involved in manufacturing and selling of Electrical and Communication Devices. This project involves Creating Data warehouse for sales reporting system. Data gathered from sources Oracle, Transferred data from these sources to Oracle target. Data was Extracted, Transformed and Loaded using Informatica. Responsibilities:  Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.  Extracted source data from flat files, Oracle and loaded to an Oracle.  Developed mappings in Informatica Power Center Designer to load data from staging environment to warehouse.  Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.  Involved in Creating Sessions, Workflows Using Workflow Manager  Involved in testing the mappings (UNIT testing). Environment: Informatica Power Center 7.1, Windows NT, Oracle9i.

American Skyline Insurance Company

jun 2011 - ago 2012 (1 año, 2 meses)

Role : ETL Developer Description: American Skyline Insurance Company, (ASCI) is one of the world’s respected players in Health Care Insurance industry. This conceptual enterprise Data Warehouse model provides Enterprise wide solution, which deals with several treads of the business like Audit& IT Analysis, Billing & Payment Analysis, Disability Claim Analysis, customer Profile Analysis, Customer Service Analysis, Financial Analysis, Human Resource Analysis, Marketing Analysis and Sales Channel Analysis. It also supports the Operational Reporting Strategies Development from which it is extracting the data through Flat Files, Oracle then Transforming, and Loading into Oracle target database. We first constructed the Data Marts according to the identified subject areas and then integrated them into Data Warehouse. Responsibilities:  Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.  Extensively used ETL to load data from Oracle, flat files to Oracle.  Extensively used aggregator, expression, lookup, and update strategy, transformation.  Analyzed Mappings and Sessions for better performance. Environment: Informatica Power Center 7.1, Windows NT, Oracle8i.