Bharamani Halaskar

About Bharamani Halaskar

Around 3.4 years of hands-on-experience in Data Engineering Field, worked on IICS Informatica tool, Azure Databricks, SQL, ETL/ELT process, Data warehouse and was part of the Core Data Team responsible for Data Migration Activities, Looking for a long-term association with a growth-oriented organization with some added responsibilities. Experience in the Analysis, Design and Development of data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL/ELT) process by using Mapping, Mapping task and Taskflows. Having good knowledge on Data integration projects to Integrate data from diffrent cloud sources to build Lakehouse by using ETL tool. Implemented Medallion architecture of Lakehouse to logically organize data in a Azure Lakehouse, which contains 3 layers (Bronze, Silver and Gold Layer) is followed to segregate the raw data with cleansed one. Data is transformed and cleansed using IICS tool before they are stored into the final Gold Layer, used for Power BI report generation. Software Engineer specializing in ETL/ELT Process, Data Migration Activities, building lake house on cloud, SQL. Knowledge of Different Database Sources - Databricks SQL (DB SQL), Oracle, MySQL, SQL Server. A Quick learner and an effective professional with excellent skills for solving critical business problems with a structured approach and analytical mind-set.

Experience

1. Iics Developer

   Tata Consultancy Services

   Dec 2021 — Present · Pune, IN

   Having 3.4 years of hands-on-experience in Data Engineering Field, worked on IICS tool, Azure Databricks, SQL, ETL/ELT process and was part of the Core Data Team responsible for Data Migration Activities. Informatica Cloud Data Integrator (IICS) is used as an ELT tool to copy the data from various sources suchas MySQL, Flat Files, Rest API and place these into Azure Data Lake. Databricks hive meta store is usedas the platform to display the Lakehouse data in tabular format. Technologies Used: IICS, Azure Databricks, SQL, Unix, PuTTY, WinSCP, MySQL. Implemented Medallion architecture of Lakehouse to logically organize data in a Lakehouse, whichcontains 3 layers (Bronze, Silver and Gold Layer) is followed to segregate the raw data with cleansed one.Data is transformed and cleansed using IICS tool before they are stored into the final Gold Layer, used forPower BI report generation. Worked with a team to do Data profiling of all history data(55 tables) which is present in MySql to createuseful summaries of data and to check data quality issues, such as duplication and data discrepancy of thedata. For History load (One time load) created the parameterised pipeline by creating a single parameterisedmapping loaded 680 million of data to the silver layer by using task flow and multiple mapping tasks inparallel flow. Handled excel format as a source in IICS by creating structure parser for each file by using structure model. Prepared all the related documentation of the project end to end such as source to target document,deployment sheet and given the same Presentation to the customer.

Education

• Visvesvaraya Technological University

  Bachelor of Engineering - BE

  2016 — 2020