Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Personal Details
Timeline
Career Timeline
Generic

Bijoy Das

Pune,Maharastra

Summary

Dynamic Data Engineering Manager with over 16 years of experience leading high-performing teams in the development and optimization of large-scale data infrastructure. Expertise in collaborating with business stakeholders to translate complex requirements into actionable technical solutions, consistently delivering projects on time and within budget. A strong commitment to mentoring junior data engineers fosters a culture of innovation and continuous improvement, while an amiable leadership style facilitates rapid onboarding of new personnel and the swift initiation of projects. Proven ability to assemble effective teams by leveraging complementary competencies and nurturing collaborative relationships among team members, resulting in exceptional completion metrics.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Tech Lead (VP)

Barclays
08.2017 - Current
  • Developing different Reconciliation Nostro/Depot, Intersystem using Intellimatch tool.
  • Designing a common Informatica ETL framework to process all feeds for INSY, NOSTRO, and DEPOT reconciliation.
  • Worked on designing and developing ETL workflows using Java to fetch data from Trade Store HDFS system for Rec Processing.
  • Hands-on experience in Pyspark and strong knowledge of Dataframes, RDD and SparkSQL.
  • Developed Spark Scripts in Python to fetch information from various sources such as AWS S3, SQL Server, and Oracle for data analysis.
  • Implemented Database Data retention in active table and Historical data archival process in AWS S3 for 18 DB instances.
  • Design and implement scalable and efficient data transformation/storage solutions with open table formats such as Iceberg.
  • Developed dashboards using BO, Tableau, enhancing data visualization, and making data-driven decisions.
  • Tuning existing ETL workflow/new to ensure acceptable application performance.
  • Writing complex SQL and PL SQL programs for data processing and data analysis.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Designed and implemented scalable applications for data extraction and analysis.
  • Identified opportunities to improve business process flows and productivity.

Informatica Lead

RBS India
09.2010 - 08.2017
  • Designing of Data warehouse Component Architecture using Dimension Modeling standards.
  • Designed and developed advanced ETL processes using Informatica, improving data processing speed by 30% and eliminating 99% of manual errors.
  • Analyzed user requirements and developed solutions to meet needs.
  • Followed up with clients to verify optimal customer satisfaction following support engagement and problem resolution.
  • Developed and maintained strong client relationships to deliver exceptional customer service and problem resolution.

Software Developer

United Health Group
09.2007 - 09.2010
  • Design and develop ETL processes using Informatica PowerCenter.
  • Create and maintain mappings, mapplets, sessions, and workflows for data extraction, transformation, and loading.
  • Implement SCD Type-1 and Type-2, incremental loads in Informatica.
  • Conducted data modeling, performance and integration testing.
  • Tested and deployed scalable and highly available software products.
  • Designed and implemented scalable applications for data extraction and analysis.

Education

B.E. - Mech

Jorhat Engineering College
Jorhat, Assam
06.2005

Skills

  • Proficient in big data technologies
  • Data warehousing solutions with Informatica
  • Database management: SQL Server, Oracle, NoSQL
  • Proficient in data analysis tools: Python, SQL, Tableau
  • Proficient in AWS EC2, S3, Redshift, and Cloud Watch
  • Project management with JIRA
  • Hadoop and Spark development
  • AWS Certified Cloud Practitioner
  • Comprehensive Python training

Accomplishments

  • Received Best Performer Awards.
  • Received Manager’s choice Awards.
  • Received Best Team of the Month Award, Champion of Change Award

Certification

Big Data Hadoop and Spark Developer by Simply learn.

AWS Certified Associate

Personal Details

Languages Known: English, Hindi, Assamese

Timeline

Tech Lead (VP)

Barclays
08.2017 - Current

Informatica Lead

RBS India
09.2010 - 08.2017

Software Developer

United Health Group
09.2007 - 09.2010

B.E. - Mech

Jorhat Engineering College

Career Timeline

  • Sep/2007 – Sep/2010: United Health Group Limited
  • Sep/2010 – Aug/2017: RBS INDIA Development Centre
  • Aug/2017 – Till Date: Barclays India Pvt Ltd
Bijoy Das