Summary
Overview
Work History
Education
Skills
Timeline
Generic

PREMDEEP LOMATE

ETL Informatica
Osmanabad

Summary

Seeking assignments in Data Warehousing and Data Integration with an organization of repute.

A result-oriented professional with 3+ years of Development experience in Data Warehousing using Informatica PC, ADF .

Involved in complex mappings like Slowly Changing Dimensions (SCD- TYPE 1, TYPE 2 and TYPE 3).

Excellent conceptual knowledge in Dimensional Modeling (star schema and snowflake) and Performance tuning at Target, Source, mapping and session level.

Good Understanding of Dimensional Modelling like Star, Snow Flake Schemas

Experience in developing technical design documents and mapping specifications to build Informatica mappings

Experience in building and unit testing of deliverables with quality and without any scheduled variation

An energetic, self-motivated team member with hands on experience in programming skills, client-server infrastructure & requirements gathering.

Involved in maintenance and enhancement of the codes.

To improve the session performance, various performance bottlenecks are identified and eliminated. The identification is based on thread statistics.

Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.

Extensively Worked on long running jobs and implemented performance tuning solutions to minimal their run time in mapping, session, SQL level and Involved in Peer Reviews Activities.

Providing L3 support for production issues.

Extracted data from heterogeneous sources like oracle, fixed width and Delimited Flat files

Transformed the data according the business requirement and then Loaded into multiple databases.

Worked on PL/SQL Query performance tuning, Created DDL scripts, Created database objects like Tables, Views, Indexes, and Sequences.

Overview

3
3
years of professional experience
3
3
Languages

Work History

ETL Developer

Cox Enterprises, Accenture
Pune
06.2024 - Current
  • Project Overview: Cox Enterprises, Inc. It is an American privately held global conglomerate headquartered in Atlanta, Georgia, United States, with approximately 55,000 employees and $21 billion in total revenue. Its major operating subsidiaries are Cox Media Group, Cox Communications, and Cox Automotive. The company's major national brands include Auto Trader, Kelley Blue Book, Manheim Auctions and more. Through Cox Automotive, the company's international operations stretch across Asia, Australia, Europe and Latin America. Cox Enterprises launched a new subsidiary Cox Video, which lined up eleven commitments for original video programs, four of them came from Media Home Entertainment, which are comedy-based tapes and seven of them came from Fox Hills Video, which are reality-based tapes, both subsidiaries of Heron Communications, and co-production.
  • Effectively worked in FACT and Dimension tables creation
  • Involved in the SDLC process beginning with the design of dimensional modeling in building the data warehouse
  • To analyze source system data and prepare low-level documentation To ensure successful data loading into different targets from various source systems like Oracle Database, Flat files into the Staging table and then to the target database Oracle.
  • Studied functional documents for thorough understanding of client's need.
  • To improve the session performance, various performance bottlenecks are identified and eliminated. The identification is based on thread statistics.
  • Used Informatica features to implement mapping like SCD Type 1,2 and also CDC.
  • Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Developing Informatica mappings to build business rules to load data and tuning them when necessary.
  • Experience in designing and implementing different types of mappings which includes Expression, Lookup, Update, Router, Aggregator and Sequence Generator.
  • Supporting ADF job, Informatica job and IICS jobs. Worked on dimensional modeling to design and develop STAR Schema, identified Fact and Dimension tables for providing a unified view to ensure consistent decision making.
  • Involved in support for ALM and User Acceptance Testing of the module developed. To improve the session performance, various performance bottlenecks are identified and eliminated. The identification is based on thread statistics.
  • Used almost all Transformations including Connected & Unconnected Lookups, Router, Sequence Generator, Stored Procedure and Update Strategy and others.
  • Updating the mapping technical specifications on basis of new changes done for enhancement.
  • Developing Informatica mappings to build business rules to load data & tuning them when necessary.
  • Involved in performance tuning of session and SQL query.
  • To design Informatica mappings by using various basic transformations like filters, routers, source qualifiers, lookups, Aggregators, Joiner, and sorter and so on.
  • Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Used Informatica best practices for performance improvement and also Used concept of partitioning.
  • Cox Enterprises, Inc. is an American privately held global conglomerate headquartered in Atlanta, Georgia, United States, with approximately 55,000 employees and $21 billion in total revenue. Its major operating subsidiaries are Cox Media Group, Cox Communications, and Cox Automotive. The company's major national brands include Auto Trader, Kelley Blue Book, Manheim Auctions and more. Through Cox Automotive, the company's international operations stretch across Asia, Australia, Europe and Latin America. Cox Enterprises launched a new subsidiary Cox Video, which lined up eleven commitments for original video programs, four of them came from Media Home Entertainment, which are comedy-based tapes and seven of them came from Fox Hills Video, which are reality-based tapes, both subsidiaries of Heron Communications, and co-production.

ETL Developer

TD Bank, TCS
Pune
09.2023 - 05.2024
  • Company Overview: TD Bank, N.A., is an American national bank and subsidiary of the Canadian multinational Toronto-Dominion Bank. The project is to develop reporting system based on data warehouse from Oracle is used to develop different reports. The new trade repository will serve all financial institutions as well as non-financial operations and will deliver flexible participation levels that adapt to the diverse profiles and needs of all stakeholders and actors in the OTC derivatives market. The datamart was dimensionally model with the capability of capturing changed or delta records. The datamart was later used by reporting system to build dashboards and for ad hoc reporting to identify the usage of the statements.
  • Worked on dimensional modeling to design and develop STAR Schema, identified Fact and Dimension tables for providing a unified view to ensure consistent decision making.
  • Used Informatica features to implement mapping like SCD Type 1,2,3 and also CDC.
  • Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Used Informatica best practices for performance improvement and also Used concept of partitioning.
  • Used Informatica Workflow Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
  • Designed a project specific versioning mapping for all core tables to keep track of historical data.
  • Used almost all Transformations including Connected & Unconnected Lookups, Router, Sequence Generator, Stored Procedure and Update Strategy and others.
  • Worked with dynamic cache for static cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
  • Involved in designing the error handling strategy and Performance tuning.
  • Involved in the SDLC process beginning with the design of dimensional modeling in building the data warehouse.
  • To ensure successful data loading into different targets from various source systems like Oracle Database, Flat files, SQL Server into the Staging table and then to the target database Oracle.
  • Involved in implementing business rules by creating re-usable transformations, workflows and Mappings/ Mapplets.
  • Performed root cause analysis and recovery process and raised ticket to concern BA.
  • TD Bank, N.A., is an American national bank and subsidiary of the Canadian multinational Toronto-Dominion Bank. The project is to develop reporting system based on data warehouse from Oracle is used to develop different reports. The new trade repository will serve all financial institutions as well as non-financial operations and will deliver flexible participation levels that adapt to the diverse profiles and needs of all stakeholders and actors in the OTC derivatives market. The datamart was dimensionally model with the capability of capturing changed or delta records. The datamart was later used by reporting system to build dashboards and for ad hoc reporting to identify the usage of the statements.

L2 Support Engineer

CNA Insurance
Remote
02.2022 - 08.2023
  • Company Overview: CNA Financial Corporation is a financial corporation based in Chicago, Illinois, United States. Its principal subsidiary, Continental Casualty Company. The project involves building a Data Warehouse solution to meet the various requirements of operations teams and DSS. The Data Mart is mainly focused on Point of trade and implemented to analyze the business performance, trends over time and build forecasts in addition to generate various reports for business users. Give sales team a better visibility. Informatica used to load the data to warehouse dimension and fact tables.
  • Updating the mapping technical specifications on basis of new changes done for enhancement.
  • Daily load monitoring.
  • Resolving issues in daily/weekly load cycle.
  • Preparation of test plans and unit testing.
  • Used Informatica client tools - Workflow Manager, Mapping Designer, and Transformation Developer.
  • Worked on enhancement projects.
  • Automated and scheduled the Informatica jobs.
  • Extensively used ETL methodology for developing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica.
  • Involved in creating the Unit cases and uploaded in to Quality Center for Unit Testing and UTR.
  • Ensure that daily support tasks are done in accordance with the defined SLAs.
  • Studied functional documents for thorough understanding of client's need.
  • Experience in designing and implementing different types of mappings which includes Expression, Lookup, Update, Router, Aggregator and Sequence Generator.
  • Mappings were designed to the at most performance by optimizing expressions in Expression Editor of Transformation, filtering source data at the Source Qualifier, and applying transformation logic.
  • Effectively implemented MD5 algorithm so as to reduce overall ETL run-time and the cache memory usage, by caching only the required fields which are of at most importance.
  • CNA Financial Corporation is a financial corporation based in Chicago, Illinois, United States. Its principal subsidiary, Continental Casualty Company. The project involves building a Data Warehouse solution to meet the various requirements of operations teams and DSS. The Data Mart is mainly focused on Point of trade and implemented to analyze the business performance, trends over time and build forecasts in addition to generate various reports for business users. Give sales team a better visibility. Informatica used to load the data to warehouse dimension and fact tables.

Education

Bachelor of Science -

SRTMUN University
Latur, India
04.2001 -

Skills

ETL Tools - Informatica Power Center 10x

Database - Oracle 11g

Database Tool - SQL Developer

Programming Languages - PL/SQL

Programming Languages - Unix

Timeline

ETL Developer

Cox Enterprises, Accenture
06.2024 - Current

ETL Developer

TD Bank, TCS
09.2023 - 05.2024

L2 Support Engineer

CNA Insurance
02.2022 - 08.2023

Bachelor of Science -

SRTMUN University
04.2001 -

Similar Profiles

CREATE PROFILE
PREMDEEP LOMATEETL Informatica