Roja Gari
Data Engineer @CBRE
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @CBRE
Toronto, ON, CA
Developed Airflow Bigdata jobs to load large volume of data into S3 data lake and then into Snowflake. working with GraphQL schema, queries and mutations to interact with Mongo DB and several other data layers. working with Apollo client to interact with GraphQL server. Responsible for design and development of Spark SQL Scripts based on Functional Specifications Involved in Migrating Objects from Teradata, SQL Server to S3 and then on Snowflake. Developed highly optimized Spark applications to perform data cleansing, validation, transformation, and summarization activities Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases. As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company. Fine-tuning spark applications/jobs to improve the efficiency and overall processing time for the pipelines. Good Work experience of Embedded SQL and C Sybase Open servers and remote Procedures. Sybase to SQL Server migration lead responsible for migration assessment, developing migration plan of objects and data and leading the effort. Used SQL Server to Sybase Migration Assistant tool for assessment as well as to migrate database objects. Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment. Implemented & followed organization level Informatica best Standards & Procedures. Docker Hub, Docker Compose, Docker-registries, and Kubernetes. Working on migrating Data pipelines to in-house MAP-AIRFLOW from legacy Airflow cluster.sql Creating, cloning Linux Virtual Machines, templates using VMware 4/5 and migrating servers between ESX hosts.
ABOUT ROJA GARI
Senior Consultant Data Engineer with 5+ years of experience in building data intensive applications, tackling challenging architectural and scalability problems. Experience in dimensional data modeling, ETL development, and Data Warehousing. Experience in creating reports and visualizations in ThoughtSpot, a BI tool hosted on cloud. Experienced in building optimized and scalable extremely large ELT jobs on TBs of data. Provided meaningful insights by crunching lots of data bits. Experienced in optimizing compute applications. Experience in Java, Python,SQL, c++,PHP,Ruby,Node.js, Dot net Defined Use cases from requirements and helped convert them into report specifications. Created Unit testing, System testing, and Performance testing for enterprise deployments and conversions. Provisioned servers for production, UAT and development environments including replication, mirroring and clustering. Extensive experience in MS, SQL Server 2016 (TSQL) database design and development in writing Constraints, Indexes, Views, and Stored Procedures. Analyze tables and structure of company databases to establish knowledge of data for accurate retrieval and use in report writing.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.