Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Manoj Behera

Kolkata,India

Summary

Data Engineer with over 7 years of experience in designing and implementing advanced data integration solutions. Skilled in leveraging cloud technologies such as IICS ,AWS, Snowflake, and DBT, SNP Glue ,Python as well as relational databases like Oracle and Teradata. Demonstrates a strong ability to lead large-scale data warehousing projects, optimizing performance and ensuring high data quality. Passionate about driving innovation and efficiency in data engineering.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Engineering Lead

Persistent Systems
Kolkota
01.2022 - Current
  • Led a team of 5 engineers on building a Unified Data Platform (UDP) platform hosted on AWS and utilizing Snowflake for cloud data warehousing.
  • Designed the automated and standardized pipelines to ingest data from multiple source systems such as SAP, TOTVS, AXAPTA, and external files using modern tools and technologies such as IICS, AWS Glue, SNP Glue, and AWS DMS.
  • Designed automated solution for data reconciliation and controls on data ingested with an Audit Trail capability.
  • Designed automation of job scheduling and execution using Amazon EventBridge, Lambda, and Step Functions, and designed end-to-end orchestration.
  • Design, develop, and maintain scalable data models and transformations using DBT in conjunction with Snowflake. Ensure the effective transformation and loading of data from diverse sources into the data warehouse.

IT Analyst

Tata Consultancy Service Private Limited
Bangalore, India
07.2017 - 01.2022
  • Analyzed data flow requirements and developed a scalable architecture for staging and loading data. Translated business rules and functionality requirements into ETL procedures.
  • Extensive experience in Informatica (9.x) applications. Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations, and scheduled the Workflows and Sessions.
  • Optimized SQL queries for data extraction, which decreased run time by 20% and significantly improved the performance of data loads.
  • Developed ETL pipeline for extraction of data from various source systems, ranging from Mainframes like DB2, Flat Files, VSAM files, etc. To RDBMS like Oracle, SQL Server, Teradata, etc.
  • Worked on optimizing the mappings by creating reusable transformations and Mapplets. Created debugging and performance tuning of sources, targets, mappings, transformations, and sessions.

Education

B.TECH - Mechanical Engineering

Odisha University of Technology And Research
05-2017

Skills

Cloud Technologies: IICS , Snowflake, DBT ,AWS services ,SNP GLUE ,Python

Data Integration/ETL: IICS, DBT, Informatica PC, Python, SQL, SNP glue , AWS Glue , AWS DMS

Database: Snowflake ,Teradata, Oracle, SQL , PostgreSQL,AWS Redshift

Programming Languages: Python ,PL/SQL, Unix/Shell scripting

BI Tools: Power BI, Tableau

Project Management Tools: JIRA
Version Control Tools: GitHub,GITLAB

Certification

  • Snowflake Snow Pro Core
  • AWS Developer - Associate

Accomplishments

  • Top Talent for 2 consecutive years for FY24 and FY23 at Persistent Systems.
  • Team Excellence Awards of FY23
  • Received Bravo and High five awards multiple times for splendid effort and contribution to the project.
  • Awarded Achiever of the Quarter by organization and outstanding performer by client multiple times for the contribution to the project.

Timeline

Engineering Lead

Persistent Systems
01.2022 - Current

IT Analyst

Tata Consultancy Service Private Limited
07.2017 - 01.2022

B.TECH - Mechanical Engineering

Odisha University of Technology And Research

Similar Profiles

CREATE PROFILE
Manoj Behera