I am a highly motivated, meticulous and detail-oriented Data Engineer with 14+ years of experience in gathering requirements, designing and developing traditional BI and cloud solutions. I excel at creating effective visualizations and dashboards, and I am an extremely effective communicator who delivers value using Agile and Scrum methodologies. I specialize in MS Fabric, Azure Data Factory, Informatica, Denodo, Azure Databricks, Data Lake Gen2, Synapse Analytics, SQL Server, Oracle, Postgres, and I have hands-on knowledge of Python, PySpark, Power BI, AWS, Snowflake, DevOps, and GitHub. I have worked across various Norwegian clients and led complex data flows and migrations, including SCD Type 2 implementations and cloud infrastructure migrations.

Puneet Bansal

I am a highly motivated, meticulous and detail-oriented Data Engineer with 14+ years of experience in gathering requirements, designing and developing traditional BI and cloud solutions. I excel at creating effective visualizations and dashboards, and I am an extremely effective communicator who delivers value using Agile and Scrum methodologies. I specialize in MS Fabric, Azure Data Factory, Informatica, Denodo, Azure Databricks, Data Lake Gen2, Synapse Analytics, SQL Server, Oracle, Postgres, and I have hands-on knowledge of Python, PySpark, Power BI, AWS, Snowflake, DevOps, and GitHub. I have worked across various Norwegian clients and led complex data flows and migrations, including SCD Type 2 implementations and cloud infrastructure migrations.

Available to hire

I am a highly motivated, meticulous and detail-oriented Data Engineer with 14+ years of experience in gathering requirements, designing and developing traditional BI and cloud solutions. I excel at creating effective visualizations and dashboards, and I am an extremely effective communicator who delivers value using Agile and Scrum methodologies.

I specialize in MS Fabric, Azure Data Factory, Informatica, Denodo, Azure Databricks, Data Lake Gen2, Synapse Analytics, SQL Server, Oracle, Postgres, and I have hands-on knowledge of Python, PySpark, Power BI, AWS, Snowflake, DevOps, and GitHub. I have worked across various Norwegian clients and led complex data flows and migrations, including SCD Type 2 implementations and cloud infrastructure migrations.

See more

Experience Level

Expert
Expert

Language

Norwegian
Intermediate
English
Fluent
Hindi
Fluent
Panjabi, Punjabi
Fluent

Work Experience

Senior Data Engineer at Heimstaden Services Norway
May 1, 2022 - Present
Senior Data Engineer in the Data and Analytics team. Worked on Azure Data Factory, MS Fabric stack, SQL Server and Postgres. Implemented various source and platform integrations with REST APIs, SQL Server, Blob Storage, SharePoint, MS Dynamics 365, Xano integration, Postgres, Workday, Visma. Created multiple simple and complex data flows with complex business logic and SCD Type 2. Led migration efforts from Azure to MS Fabric, including mirroring concepts and data synchronization.
Senior Data Engineer at Fremtind Forsikring Norway
February 1, 2021 - May 31, 2022
Senior Data Engineer in Innsiktsløsninger team. Worked on Informatica Cloud and Netezza. Developed large-scale Data Warehouse solutions using Informatica Cloud, Netezza and Aqua data solutions. Created multiple reusable and non-reusable mappings and mapplets with advanced transformations to extract and load data from multiple flat files/tables into target files/tables. Involved in design and data modeling exercises.
Senior Data Engineer at Sopra Steria Norway
September 1, 2020 - January 31, 2021
Senior Data Engineer in RightCloud Data Platform team. Managed and deployed resources using GitHub Actions, Terraform and GitLab. Built a generic data platform using Microsoft Azure services such as Data Factory, Databricks, Storage account, Key vault, Data lake, Delta lake etc. Set up Azure DevOps, configured git, and created Infrastructure as Code for clients. Worked for clients like Lånekassen and WalWil to set up their cloud infrastructure.
Data Engineer at Telia Norge AS (GET Norge AS)
December 1, 2017 - August 31, 2020
Key part of a squad called Enterprise representing Data Analytics and BI Norway. Involved in designing data warehouses and data marts at the enterprise level. Design logical/physical database design and data modeling of data marts. Defining, designing, developing & optimizing ETL processes for data warehouse. Render insights & generate analytical reports with recommendations to enable strategic planning by management. Processed large data sets using advanced querying, visualization and analytics tools. Administered Denodo virtualization and monitored performance; managed Denodo Scheduler and delivered reports using Denodo and Qlik View. Participated in major migrations such as Remedy to ServiceNow and Melody to Navi.
BI Developer (ETL/ Data warehouse Developer) at Tata Consultancy Services
November 1, 2010 - November 30, 2017
Involved in developing solutions for large-scale Data Warehouse using Informatica PowerCenter as ETL tool, Oracle, SQL/PLSQL, and Unix scripts. Created reusable and non-reusable mappings and mapplets to extract and load data from multiple sources. Created reports using SAP BO and Microsoft PowerBI. Led migration projects including scheduling migration from Informatica to Automic UC4 and migration of obsolete DWH to new Enterprise DWH.

Education

Master of Computer Applications at Punjabi University Patiala, India
July 1, 2007 - June 30, 2010
Bachelor of Computer Science at Panjab University Chandigarh, India
April 1, 2004 - May 31, 2007

Qualifications

Certified Microsoft Azure Data Engineer Associate
January 11, 2030 - January 9, 2026
Certified Microsoft Azure Fundamentals
January 11, 2030 - January 9, 2026
Certified Denodo Developer
January 11, 2030 - January 9, 2026
Certified Informatica 9.x specialist
January 11, 2030 - January 9, 2026
Certified NSE - NCFM - Financial Markets: A Beginner's module
January 11, 2030 - January 9, 2026
Certified Six Sigma Green Belt
January 11, 2030 - January 9, 2026

Industry Experience

Software & Internet, Professional Services, Computers & Electronics