Passionate tech enthusiast with 4+ years of experience in Google Cloud Platform. Skilled in data analysis, designing fact and dimension tables, and developing complex SQL queries with multiple joins and views. Adept at understanding business requirements, formulating scripts and procedures to fetch data, testing in lower environments, and deploying to production. Resourceful team player with a proven ability to deliver tasks within stringent timelines.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
HCL Technologies
12.2024 - Current
Designed and implemented scalable ETL pipelines using DBT and Ascend, and orchestrated them using Airflow DAGs
Fine-tuned query performance and optimized SQL structures for faster, more accurate data retrieval and reporting.
Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
ETL Developer/ETL Tester
Cognizant Technologies Solutions
06.2021 - 12.2024
Optimized data processing by implementing efficient ETL pipelines and data transformation techniques.
Collaborated with stakeholders to gather requirements from both users and the internal business team.
Designed and implemented scalable ETL pipelines using BigQuery, Data Prep, Airflow, and Ascend.
Involved in the design of the STTM and high level mapping based on project specifications.
Engaged in code reviews, providing insights and solutions to optimize complex code structures.
Automated KPI validation for the ETL pipeline by developing a Collibra job
Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
Took responsible for deploying code to the System Integration Testing (SIT) and production environments utilizing GitLab CI/CD.
Managed the end to end deliverables for integrations and interfaces, ensuring seamless execution.
Served as the development lead on a project, providing mentorship and guidance to developers in the design and implementation of ETL pipelines.
Executed end to end regression testing between the on premises System and GBQ data lake to ensure data integrity and accuracy as per expectations.
Developed a test suite utilizing Jira Zephyr Scale and Zephyr Squad to enhance testing efficiency and effectiveness.
Education
BE - Electronic Engineering
KSR Institutions
Namakkal, India
04-2021
Skills
Cloud Platforms: Google Cloud Platform (GCP)
ETL Tools: DBT, Ascend, Big Query, Data Prep, Airflow, Dataflow, IICS, CA Scheduler
Data quality management using Collibra
Experience in collaborative version control with GitLab
ETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ LtdETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ Ltd