Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Aishwarya Sankaranarayanan

Chennai

Summary

Results-oriented Data Engineer with a proven track record of successful data migrations and transformations. Leveraging 8 years of IT experience, I have expertise in software product development, support, and data management using Google Cloud, Hadoop Ecosystems, and Mainframes. As a Data Engineer for the past 5 years, I have successfully migrated both RDBMS and file data from on-premises environments to Google Cloud Platform (GCP), Built Data Products for Business Analytics utilizing a variety of GCP services. My technical skills are complemented by strong analytical, communication, and problem-solving abilities. I am a collaborative team player with excellent interpersonal skills, dedicated to delivering high-quality data solutions.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Engineer

Altimetrik India Pvt. Ltd
11.2021 - Current
  • Company Overview: Client: FORD MOTOR COMPANY, GLOBAL
  • Successfully migrated data from on-premises Hadoop environments to Google Cloud Platform (GCP) using Astronomer Airflow to orchestrate data pipelines from Google Cloud Storage (GCS) to BigQuery.
  • Preprocessed complex nested JSON data using Dataproc to efficiently load it into BigQuery tables.
  • Implemented country tagging logics to classify ingested data and make it readily accessible to end users.
  • Developed data products by integrating data from various sources, applying necessary transformations, and delivering the data in a usable format.
  • Utilized Dataform for scheduling these products and migrated Alteryx workflows to GCP.
  • Served as a GCP Resource Manager, responsible for setting up environments, generating Vault Keys for data ingestion, deploying data pipelines to production, updating BigQuery production data, assigning roles for Google Cloud components and Service Accounts, and managing code updates in Git.
  • Ingested data from diverse RDBMS and file-based sources into the Hadoop platform using landing and transformation tools like Qlik Replicate, DDIT, and TEM.
  • Ensured data quality by developing test cases and conducting timely verification and validation processes.
  • Acted as a Release Manager, overseeing the launch of data to production, managing production data updates, and scheduling production jobs.
  • Client: FORD MOTOR COMPANY, GLOBAL

Associate

Cognizant Technology Solutions
04.2016 - Current
  • Company Overview: Client: CARGILL, GLOBAL
  • Data from AS400, Oracle and few ERP systems are being ingested into Hadoop via sqoop and near real time streaming into raw hive tables and then the data is moved into a staging layer after minor transformations.
  • Here the data is modelled using several SQL queries and scripts and sent to final product layers.
  • The final layer table are connected to Power BI reports for reporting and reconciliation purpose by multiple users.
  • Built data pipelines to ingest data from RDBMS or business flat files into Hadoop, employing various transformation techniques tailored to application architectures.
  • Automated processes by scheduling jobs using Rundeck or Oozie.
  • Provided ongoing maintenance and support for applications and end users through calls, emails, batch monitoring, service requests, application backend processing, and enhancements.
  • Ensured high levels of client and business satisfaction by delivering accurate solutions for application issues and fulfilling small work requirements.
  • Met business needs by generating reports, financial and non-financial statements.
  • Conducted thorough code analysis to identify and resolve issues, implementing effective solutions.
  • Worked on new business requirements for datalake applications, including process improvements and automated data reporting.
  • Client: CARGILL, GLOBAL

Education

B.Tech in Informtion Technology -

KGISL Institute of Technology
Coimbatore, India
04-2015

Skills

  • Google cloud - GCS, BigQuery, Dataproc, Cloud Run, Pub/Sub, Dataform, Cloud Composer
  • BigData - Hadoop, HDFS, Hive, Sqoop, Kafka
  • Pyspark
  • Shell scripting
  • Ingestion Tools - Astronomer, Airflow, Qlik, DDIT
  • Version Control - GIT
  • Other Tools - Alteryx, Jenkins, POSTMAN
  • Databases - MySQL, DB2
  • Ticketing Tools - JIRA, BMC Remedy, Service Now
  • Packages - Microsoft Office

Accomplishments

    Appreciated by FORD for migrating and building unique pipelines on Freight cost Dashboard from Alteryx to GCP

Certification

Google certified Professional Data Engineer

Timeline

Senior Engineer

Altimetrik India Pvt. Ltd
11.2021 - Current

Associate

Cognizant Technology Solutions
04.2016 - Current

B.Tech in Informtion Technology -

KGISL Institute of Technology

Similar Profiles

CREATE PROFILE
Aishwarya Sankaranarayanan