Ing. SAMIT JENA
Angestellt, Senior Data Engineer, Innover Digital
Bhubaneswar, Indien
Über mich
Experienced Senior Data Engineer with over 12 years in IT, specializing in BI and data Engineering products. Possesses extensive technology skills, expertise in Azure Cloud and Microsoft Business Intelligence (MSBI). Proven ability to design end-to-end solutions utilizing Azure Data Factory (ADF), Data bricks, Azure SQL DW, Spark, Python, Scala, SQL, and Power BI. Proficient in data modeling, implementing ETL pipelines, optimizing Spark jobs, and developing insightful reports and dashboards using Power BI and DAX. Skilled in developing cost-effective solutions and effectively communicating with stakeholders.
Werdegang
Berufserfahrung von SAMIT JENA
Bis heute 3 Monate, seit Apr. 2024
Senior Data Engineer
Innover Digital
• Created comprehensive design documents for Azure cloud solutions, ensuring alignment with business requirements and industry best practices. • Mentored junior team members on Azure Databricks and Data Factory, providing guidance on best practices and troubleshooting techniques.
2 Jahre und 2 Monate, Feb. 2022 - März 2024
Senior Data Engineer
Farfetch
• Led end-to-end data integration solutions using Azure Data Factory (ADF) and Azure Databricks to orchestrate data movement and transform from various sources • Implemented dynamic parameterization and logging mechanisms in ADF pipelines, optimizing data processing workflows, and improving overall pipeline efficiency. • Developed Azure Databricks notebooks using PySpark code to efficiently handle large volumes of data and execute complex data transformations.
3 Jahre und 9 Monate, Juni 2018 - Feb. 2022
Senior Data Engineer
Maersk Line
• Designed and implemented efficient Extract, Transform, Load (ETL) pipelines to read and process data using Azure Data Factory (ADF) and Azure Databricks, ensuring timely execution and delivery of critical data • Successfully migrated legacy data workflows to Azure Data Factory, converting SQL code to Databricks notebooks and optimized Spark Jobs by analyzing Directed Acyclic Graph (DAG) execution plans. • Developed SSAS Tabular Model, wrote DAX queries to implement various KPI’s in cube
1 Jahr und 8 Monate, Nov. 2016 - Juni 2018
Senior Software Engineer
Accionlabs India
• Created complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies and implemented Time Intelligence functions in SSAS cubes • Performed the ETL from databases and flat files sources by using SSIS Packages, contributed to building Data Marts and multi-dimensional models like Star Schema and Snowflake schema • Wrote T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers; scheduled and maintained SSIS packages on a daily, weekly and monthly basis
4 Jahre und 10 Monate, Jan. 2012 - Okt. 2016
Senior Software Engineer
IQVIA - Quintiles and IMS Health are now IQVIA
• Formulated and documented detailed business rules and guidelines • Created and maintained 70+ MDX cubes, including complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies • Developed master cube from which all other cubes could be created and deployed; created automated jobs using SSIS for data validation between current cube and previous cube • Worked on complex MDX query and created SSIS packages for reading and processing daily files
Ausbildung von SAMIT JENA
4 Jahre und 1 Monat, Juni 2006 - Juni 2010
Electronics Engineering
BPUT
Mathematics, Physics, Chemistry, Economics, Computer Programming
Sprachen
Englisch
Fließend
Deutsch
Grundlagen