ETL Data Engineer

Willware Technologies

Location: Bengaluru, Karnataka, India
Job type: Full-time

Required skills

AWS
big data technologies
Business Intelligence
data engineer
data ingestion
data modeling
data models
data solutions
ETL
Lambda
Oracle
Root Cause Analysis
Snowflake
SQL

About the role

Willware Technologies

Website: willwaretech.com
Job details:

Company Name: WillwareTechnologies

Role: ETL Data Engineer

Experience:10+ Years

WorkMode:Onsite

Job Description:

We are looking for a highly experienced Senior Data Engineer with strong expertise in AWS data services, ETL development, and data warehousing. The ideal candidate will design and build scalable data pipelines and architectures to support analytics and business intelligence initiatives.

Key Responsibilities

Collaborate with business users and analysts to gather data requirements and deliver scalable data solutions
Design, develop, and optimize ETL pipelines using AWS services such as Glue, Lambda, EMR, Kinesis, and Step Functions
Build and manage data lakes and data warehouses using Amazon S3 and Redshift
Develop and maintain SQL queries, stored procedures, and data transformation logic
Enable self-service analytics using Athena, Redshift Spectrum, and Glue Data Catalog
Implement data ingestion pipelines from multiple sources (RDBMS, APIs, flat files)
Design scalable data models using Star and Snowflake schemas
Perform data profiling, root cause analysis, and resolve data quality issues
Maintain documentation including data dictionaries, data flow diagrams, and mappings
Support production pipelines and troubleshoot failures or outages
Monitor and optimize pipeline performance, cost, and reliability across AWS services

Required Skills & Qualifications

10+ years of experience in data engineering, ETL, and data warehousing
Strong hands-on experience with AWS data services (Glue, Lambda, EMR, Kinesis, S3, Redshift)
Proficiency in SQL with experience in relational databases (SQL Server, Oracle, etc.)
Strong understanding of data modeling techniques (Star & Snowflake schemas)
Experience in building and managing data pipelines from diverse sources
Strong problem-solving and analytical skills
Ability to debug data issues and optimize performance
Experience working directly with business stakeholders
Ability to handle multiple projects in a fast-paced environment
Excellent communication and documentation skills

Preferred Skills

Experience with Big Data technologies
Knowledge of data governance and data quality frameworks
Familiarity with CI/CD pipelines for data engineering
Experience with real-time data processing

Click on Apply to know more.

This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.