Pritam Sontakke

About Pritam Sontakke

7 years of experience in full life cycle of software project development in various areas like design, Applications development of Enterprise Data Warehouse on large scale development efforts leveraging industry standard using Talend (8.x) and Informatica (9.x). • Extensive knowledge of business process and functioning of Financial, Fleet Management, Heath Care, Manufacturing sectors. • Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems including Oracle, Teradata, Sybase, Postgres, Snowflake, MS SQL server and non - relational sources like flat files, csv files. • Expertise in creating mappings in Talend using tMap, tFileCopy, TFileAcrchive, tFileDelete, tCreateTemporaryFile, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, like tJavaRow, tJava, tJavaFlex, Routines, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap, tDie etc. • Used tRunJob component to run child job. Created Context Variables and Groups to run Talend jobs against different environments. Used tParallelize component and multi thread execution option to run sub jobs in parallel which increases the performance of a job. • Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter. • Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Router, Update strategy and Normalizer Transformations. Developed reusable Transformation and Mapplets. • Expertise in Data Modelling - Star Schema and Snowflake modelling, developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 and Incremental loading. • Excellent working experience in Waterfall, Agile methodologies. Proficient in performance analysis, monitoring and PL/SQL stored procedures, SQL query tuning. • Troubleshoot long running jobs and fixing the issues. Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment. • Strong Experience with Python and shell scripting. Developed automation scripts to help in various phases of data engineering. • Experience in providing technical leadership and mentoring to Junior Engineers.

Experience

1. Consultant

   Deloitte

   Oct 2022 — Present · Pune, IN

   Pune, Maharashtra, India

Education

• Government Polytechnic, Awasari, Pune

  Diploma in Information Technology

  2011 — 2014

• Pimpri Chinchwad Education Trust'S. Pimpri Chinchwad College Of Engineering, Pune

  Bachelor of Engineering (B.E.)

  2014 — 2017