UpStack - Grow your team with the top 1% Remote Software Developers

Lijo L.

Pune, India

About Me

Lijo is an expert Data Engineer proficient in analytics, database design, visualization/insight generation, and data modeling. He is hands-on in Big Data solutions and is abreast of data-focused programming/scripting languages, modern data engineering approaches, and best practices. Lijo manages, manipulates, stores, and parses data through ETL for several target sources, building and maintaining data systems and pipelines.

AI, ML & LLM

Airflow

Backend

Python

Database

SQL Data Build Tool (dbt)

DevOps

GCP AWS

Other

Data Integration (ELT/ETL) Data Engineering Snowflake Pyspark Looker Microsoft Excel Analytics Business Reporting Data Reporting

Work history

UpStack

Senior Data Engineer

2021 - Present (4 years)

Remote

Building scalable databases, acquiring and integrating diverse data sources, and implementing efficient data pipelines using Python, Snowflake, BigQuery, DBT, Airflow, and Dagster.
Administering infrastructure solutions to improve data models, increase data accessibility, and foster data-driven solutions for clients.
Implementing monitoring solutions to ensure data integrity and working closely with engineers, product managers, and other stakeholders.

Python SQL GCP ETL AWS Pyspark Data Engineering Big Data SnowflakeBigQuery Data Analysis DBT AirflowDagster LookerData Build Tool (dbt)

Citi

Data Specialist

2013 - 2022 (9 years)

Pune, India

Architected, built, and deployed various data solutions, improving SFTR and CFTC reporting and OCC part 30 regulation.
Designed, developed, deployed, and maintained several data services and pipelines on multiple Python-based projects.
Evangelized best practices and oversaw multiple projects simultaneously under changing requirements and deadlines.

Python SQL ETL Talend GCP Big Data Java QlikView Pyspark AWS Data Engineering

Wipro

ETL Developer

2011 - 2013 (2 years)

Chennai, India

Worked on the Fails and Settlement reporting project and participated in early brainstorming to coding and bug fixing.
Designed and deployed a Java-based rules management tool and created ETL jobs to onboard 100+ systems.
Built and implemented a new data mapping framework in ETL, delivering solutions to reduce development efforts by 50%.

ETL Java SQL Data Engineering

Olam Solutions

Junior Software Engineer

2008 - 2011 (3 years)

Chennai, India

Developed and deployed data pipelines, ETL jobs, and other data services to onboard various data sets into Olam's system.
Implemented new solutions in executing the cost of sales report, improving daily month ends and daily P&L calculations.
Built and deployed a remote syncing tool for online clients and delivered reports using Crystal Reports.

ETL Crystal Reports SQL Java

Showcase

Senior Data Engineer - SFTR reporting

Developed a solution for SFTR reporting, including SLA-driven report delivery and compliance reduction.
Implemented a messaging framework in XML for collateral data across various regulations.
Created ETL for data onboarding into the data warehouse for collaterals and margins.

Senior Data Engineer - MAP (Metrics and Analytics Platform)

MAP is an ETL automation solution for Citi Bank to manage securities exposure.
It includes an ETL data mapping wizard, PL/SQL reporting, and an IBM rule engine.
The solution saved the bank $132 billion in unused funds due to trade failures.

Senior Data Engineer - GCP Data Migration

Implemented a data encoding and migration project for Citi to move data to GCP.
Utilized Python scripts, GCP Dataproc, Netezza, and MySQL for the solution.
Developed a ROT13 encryption process to ensure data format consistency during migration.