Sivaraj Venkatachalam

WORK HISTORY

EDUCATION

ABOUT SIVARAJ VENKATACHALAM

12+ years of experience with strong technical skill set in Requirement Gathering, Designing, Building, Testing, Implementing and Maintaining Applications for various Data Lake Implementation, Data Integration, Data Migration, Data Analytics, Data Warehouse and Business Intelligence related projects under Banking and Financial Services domain. • Worked for various banking clients such as Swedbank Nordic-Baltic, Barclays UK, Discover US, KeyBank US, Capital One US, Citibank US and provided data solutions for various business use cases namely AML (Anti-Money Laundering), RDW (Risk Data Warehouse), HRDW (Human Resource Data Warehouse), CRR (Credit Risk Reporting), Account GL (General Ledger). • Performed various roles at both onsite and offshore as Data Engineer, Data Analyst, Data Warehouse Developer, Test Analyst, Team Lead, Onshore-Offshore Co-Ordinator. • Strong work experience in ETL Ab>Initio products (GDE, Co>OP, EME, Conduct>IT, Control>Centre, Metadata Hub, Express>IT) and implement data solution using the same. • Work experience in Integration of Ab>Initio with Azure, AWS, GCP and Kafka. • Worked on multiple projects for Legacy Platform Modernization, Data Migration from On-Prem (Teradata, MS SQL Server, Hadoop - HDFS, Hive, IBM Big SQL) to Cloud Azure (Azure Databricks, Cloud Storage Datalakegen2, Virtual Machine, Azure SQL Server, Azure Data Factory), AWS (EC2, EMR, S3, SQS, SNS, AWS Glue, CloudWatch and Redshift), GCP (Google Big Query, Google Cloud Storage, Google Compute Engine), Snowflake (Snowpipe, SnowSQL) platforms. • Hands-on experience in handling various file types such as AVRO, ORC, Parquet, XML, JSON, COBOL, CSV, Excel Spreadsheets. • Solid knowledge in performing Data Analysis and providing solutions using SQL, PL/SQL. • Utilized CI/CD Azure DevOps, Jenkins pipelines for code deployments and GitHub for code repository. • Developed Generic ETL Frameworks (CDC – Change Data Capture, DB Load, DB Extract, Data Quality Checks etc.) for handling different ETL operations and created many automation scripts using Unix Shell Scripting (ETL Job Automation, Job Monitoring Statistics, File Monitoring, DB Table Load Monitoring, User Directory Space Monitoring etc.). • Strong team player with ability to communicate, contribute, take decisions, and have experience of Agile Framework and agile way of working.