Manoj Behera
WWW: linkedin.com/in/manoj-kumar-behera-7a555b118/
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.
Skills
Cloud Technologies: IICS , Snowflake, DBT ,AWS services ,SNP Programming Languages: Python ,PL/SQL, Unix/Shell
GLUE ,Python scripting
Data Integration/ETL: IICS, DBT, Informatica PC, Python, SQL, BI Tools: Power BI, Tableau
SNP glue , AWS Glue , AWS DMS Project Management Tools: JIRA
Database: Snowflake ,Teradata, Oracle, SQL , Version Control Tools: GitHub,GITLAB
PostgreSQL,AWS Redshift
Experience
ENGINEERING LEAD | 01/2022 - Current
Persistent Systems - Kolkota
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 | 07/2017 - 01/2022
Tata Consultancy Service Private Limited - Bangalore, India
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 and Training
Odisha University of Technology And Research - B.TECH
Mechanical Engineering, 05/2017
Certifications
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.
