Vijayakumar Zayapalane
Data Engineer
Bengaluru, Karnataka, India
0
Followers0
FollowingSkilled data engineer and analytics professional with 6+ years of experience. I am passionate about using my skills to help organizations make data-driven decisions and achieve their goals. I hold a Bachelor of Technology in Computer Engineering from Pondicherry Engineering College. • Banking, Data Warehouse, Retail, Insurance, E-commerce, Logistics • Data Streaming and Data Integration of B2B Applications • AWS, AWS Glue, S3, Lambda, Linux • Azure Data Factory, Azure Databricks, ADLS2 • Database: Postgres, MySQL, AWS RDS, MongoDB • Data Warehouse: AWS Redshift, Snowflake • SQL, Python, Java, Shell Script, Google App Script • Spark, Airflow, MQ, Kafka, Druid, CI/CD, Github, SVN, Jenkins, REST APIs, Docker • ETL Tools: Airbyte, Talend (Open Source Version), dbt (data build tool) • Visualization tools: Tableau, Knowi, Apache Superset • Business and Data Analysis
Careers
Data Engineer
DocuSign
Full time05/2023 -
- Designing and implementing data pipelines using Snowflake ensuring efficient data storage and retrieval
- o Using dbtTM to develop and maintain data models and transformations, ensuring data consistency and quality
- o Orchestrating data workflows and scheduling tasks using Airflow, improving data processing efficiency
- o Developed Python scripts to access and retrieve data from various B2B data providers, including Dun & Bradstreet, through their REST APIs for Master Data Management (MDM) purposes. This involves authentication setup, endpoint requests, rate limiting, transformation, error handling, and seamless data loading into MDM systems.
Principal Data Engineer
Prescience Decision Solutions
Full time11/2021 - 05/2023
- o Researching, designing, and developing ETL and Data Pipeline components and visualization reports required for the analytical of the E-commerce domain
- o Writing complex queries on PostgreSQL/ Redshift for the Data Pipelines and Reports
- o Automated customer segmentation analysis for marketing activities using Python, pandas, and NumPy,
- resulting in a 63% increase in customer conversion rate
- o Developed and optimized PySpark data processing pipelines for batch processing
- o Deploying the analytics code using AWS Services like Lambda, Glue, S3, Redshift, Cloud Watch
- o Successfully implemented open-source software and tools for both internal use cases and client projects,
- resulting in a 20% reduction in budget
- o Mentoring the junior engineers and guiding the team members on the assigned tasks migrating of the
- SAS Analytics code to Pyspark code / Spark SQL using Azure Databricks and Azure Services
Data Engineer
Tata Consultancy Services
Full time11/2017 - 11/2021
- o Responsible for the ETL and Data Engineering tasks on the product development
- o Complex transformation logic using PostgreSQL and Spark SQL / Pyspark / SQL
- o Implemented monitoring Proof of Concept to reduce manual intervention by 90%
- o Designing Airflow DAG for ETL Workflow Orchestrations, Job Automation using shell scripts
- o Working on Product Division of TCS Digital Software and Solution Group. Our group develops
- various analytical products in different domains
- o Implementation of Digital Persona for the customer using K-Mean clustering algorithm using Apache
- Spark, Apache Airflow
- o Data Streaming and Integration for the various B2B applications using Messaging Queue (MQ) Using
- various adapters for Data ingestion and Data Streaming
- o Responsible for managing the production team for the seamless data steaming between applications
Education
Pondicherry Engineering College
Computer Engineering
02/2013 - 02/2017Bachelor's DegreeClass of 2017
Skills
SQLSparkApache AirflowData EngineeringPythonAWS S3PysparkAWS RedshiftdbtSnowflake
Experience5-8 years
Hourly rate$20/hr
Open to
remotehybridonsite
Welcome to Outdefine
A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!
Join for free