Rohit Raj

Data Engineer

Bengaluru, Karnataka, India3 yrs 9 mos experience

Most Likely To Switch

Key Highlights

Expert in ETL Development and Data Engineering.
Proficient in Microsoft Azure ecosystem.
Skilled in building scalable data architectures.

Stackforce AI infers this person is a Data Engineer specializing in ETL and cloud-based data solutions.

Contact

Skills

Core Skills

Data EngineeringEtl Development

Other Skills

ASP.NET MVCAzure Data FactoryAzure DevOpsAzure FunctionsBIOS APIBack-End Web DevelopmentBig Data AnalyticsCI/CDCSVCascading Style Sheets (CSS)Cloud ComputingCore JavaData MappingData Structures and AlgorithmsData Warehousing

About

Experienced Data Engineer with expertise in ETL Development, Data Engineering, GIT, Python, Data Structures, and OOP. Proficient in the Microsoft Azure ecosystem, including Azure Data Factory, Azure Storage, Azure DevOps, and Azure Functions. Hands-on experience with Azure Data Factory for seamless data integration. Skilled in Python for data manipulation, transformation, and analysis. Well-versed in designing and implementing robust data warehousing solutions. Proficient in SQL, PostgreSQL, and SQL Azure. Adept at harnessing the power of Azure Cloud to build scalable and performant data architectures. Motivated team player with a knack for problem-solving. Thrives in collaborative environments where innovation and efficiency are paramount. Excited about contributing to dynamic projects that push the boundaries of data engineering. Open to connecting and exploring opportunities to drive data-driven excellence together!

Experience

3 yrs 9 mos

Total Experience

1 yr 10 mos

Average Tenure

2 yrs 9 mos

Current Experience

Ust

Associate II - Data Engineer

Jul 2023 – Present · 2 yrs 9 mos · Bengaluru, Karnataka, India · Hybrid

Experience in Semiconductor Sector Data Management for Intel Team -Xeon Processor Integration and Validation – Telemetry (Team size: 8)
● Part of data collection initiatives for Intel's Xeon Processor Integration and Validation – Telemetry Team.
● Managed debugging processes and implemented data validation mechanisms.
● Conducted data cleanup analysis to ensure accuracy and reliability.
● Developed and maintained over 50 PowerBI reports for enhanced data visualization.
● Optimized query performance through SQL modifications and index analysis, improving PowerBI dashboard performance.
Project: Collector (Intel)
● Engineered a robust Extraction tool, retrieving diverse system KPIs for processor components.
● Developed a new power register extractor, enhancing CPU data collection efficiency.
● Introduced a JSON extractor, capturing precise testing metadata on data center platforms.
● Proficiently utilized a dynamic tech stack: Python, Redfish API, BIOS API, Unix API, Socket API, Logger API, Rest API, CSV, Log file, JSON, Putty, GitHub, CI/CD, OOPS.
Project :Harvester (Intel)
● Engineered ETL Tool/Framework for diverse CPU/System data extraction, transformation, and loading into warehouses.
● Developed ETL parser, enhancing Power register data processing within data center systems.
● Developed a next-gen automation ETL parser, capturing data from Intel Internal testing orchestrator.
● Utilized OData API for data retrieval and automated data mapping, elevating score from 30% to 85%.
● Contributed to teamwork, utilizing Python , Pandas, Iron Python, MS-SQL, Postgres SQL, PowerBI, Jenkins, Data warehousing, In-house Data Lake, Swagger API, Rest API, OData API, CSV, JSON, and Log file.

Python (Programming Language)Microsoft SQL ServerPower BIPostgreSQLPandasGithub+6

Metyis

Analyst- Data Engineer

Jun 2022 – Jun 2023 · 1 yr · Bengaluru, Karnataka, India

● Working With Energy Sector’s data for Fortune 500 Company
● Design end-to-end architecture and identify the Azure services used for the project.
● Use ADF ,Azure Functions ,ADLS, SQL for extract transform & load data.
● Developed several Metadata driven pipelines, DWH and Data Lake.
● Worked on both serverless and server orientation architecture for analytics related projects
Project:Telemetry
Created ADF pipeline for collecting telemetry device data for diffrent Business Units.
● Created DWH from Time series data source.
● Collected more than 70M+ data points.
Project: Cloud Centre of Excellence DWH
● Created metadata driven ADF pipelines and DWH for storing and automating Excel report creation.
● Used for creating simplified Power Bi reports for managing various cloud costs.
Customer-360 (Metyis- SHV Energy)
A Generic data warehouse for all Analytics and Development activities
● Migrated Existing Data Architecture and pipelines of Existing BU’s to Azure based and metadata driven architecture.
● Worked with SAP ERP, Business Central,Axapta DB as Source System to handle full load and delta load data.
● Developed a metadata driven Data ETL Pipeline and DWH for several new BU’s to manage and use Product and Customer data.
● Worked as a data owner for Belgium and Luxembourg market.
Infosec( Metyis- SHV Energy) Web App for BU Specific Information Security KPI collection and Dashboarding.
● Added Evidence Copy and Upload Feature.
● Optimized overall application performance by 90%.
● Manage all Azure service related to it.
● Fixed Power BI reports Issues.
● Facilitated 20+ BU's for Information Security Audits at every quarter ending.
● Stakeholders :CTO, CISO , BUISO
● Technologies: C#(.NET), Python, HTML , CSS, jQuery, Azure SQL, Keyvault, Azure Data Lake ,Apps Insights ,AD Groups , ETL ,Data Warehouse, Azure functions ,Postman
● File format : XML , JSON, CSV, PSV ,Text