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

Lijo L.

Senior Data Engineer

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.

Data Integration (ELT/ETL) 10 years SQL 10 years Data Engineering 10 years Python 7 years Java 3 years GCP 3 years Pyspark AWS 3 years

Work history

UpStack

Senior Data Engineer

2021 - Present (3 years)

Remote

Building and improving databases, acquiring data, ETL/ELT, Big Data pipelines, and deploying cloud services on projects.
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 Java Data Engineering Big Data Java QlikView SnowflakeBigQuery Data Analysis 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

Portfolio

Senior Data Engineer - SFTR reporting

Worked on the collateral and margin module for SFTR reporting, liaising with stakeholders on requirement gathering and reporting. The solution enables the bank to send SFTR reports per SLA, reducing the number of NACKS for compliance. Interacted with data generators to deliver data in a specific format, implemented a messaging framework in XML to handle collateral data across various data regulations, and developed the ETL for data onboarding into the data warehouse for collaterals and margins. Deployed a tool for collateral allocation, created CI/CD pipelines, and participated in performance tuning of SQL queries for reporting.

Senior Data Engineer - MAP (Metrics and Analytics Platform)

MAP is an ETL automation solution developed for Citi Bank to automate their exposure to securities. Developed an ETL data mapping wizard to handle data onboarding to various systems, wrote PL/SQL in Oracle for reporting, and implemented an IBM-based rule engine for the solution. The MAP saved the bank an amount of $132 billion in unused funds with clients due to trade fails.

Senior Data Engineer - GCP Data Migration

Designed and implemented a data encoding and migration project for Citi to migrate data to GCP, delivering solutions with Python scripts, GCP Dataproc, Netezza, and MySQL. Supervised the migration process and created a ROT13 encryption process to deliver the same data format on the solution.