MUMBAI · FULLTIME
Sr. Data Engineer
ONETICK TECHNOLOGIES
Mumbai · onsite · Posted 28d ago
Sourced from
Undisclosed3–5 yrsfulltimeMumbai
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.2s
- Found the form on Naukri · 10 questions to answer1.5s
- Decided the answers for all of them2.7s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Experience: 3-5 Years
Employment Type: Full-time
Position Overview:
We are looking for a highly skilled and hands-on Senior Data Engineer to join our growing data engineering practice in Mumbai. This role requires deep technical expertise in building and managing enterprise-grade data pipelines, with a primary focus on Amazon Redshift, AWS Glue, and data orchestration using Airflow or Step Functions. You will be responsible for building scalable, high-performance data workflows that ingest and process multi-terabyte-scale data across complex, concurrent environments.
The ideal candidate is someone who thrives in solving performance bottlenecks, has led or participated in data warehouse migrations (e.g., Azure to Redshift), and is confident interfacing with business stakeholders to translate requirements into robust data solutions.
Key Responsibilities:
- Design, develop, and maintain high-throughput ETL/ELT pipelines using AWS Glue (PySpark), orchestrated via Apache Airflow or AWS Step Functions.
- Own and optimize large-scale Amazon Redshift clusters and managing high concurrency workloads for very large user base:
- Lead and contribute to migration projects from Azure or traditional RDBMS to Redshift, ensuring minimal downtime and robust validation.
- Integrate and normalize data from heterogeneous sources including REST APIs, AWS Aurora (MySQL/Postgres), streaming inputs, and flat files.
- Implement intelligent caching strategies, leverage EC2 and serverless compute (Lambda, Glue) for custom transformations and processing at scale.
- Write advanced SQL for analytics, data reconciliation, and validation, demonstrating strong SQL development and tuning experience.
- Implement comprehensive monitoring, alerting, and logging for all data pipelines to ensure reliability, availability, and cost optimization.
- Collaborate directly with product managers, analysts, and client-facing teams to gather requirements and deliver insights-ready datasets.
- Champion data governance, security, and lineage, ensuring data is auditable and well-documented across all environments.
Required Qualifications Experience:
- 3-5 years of core data engineering experience, especially focused in Amazon Redshift hands-on performance tuning and large-scale management capacity.
- Demonstrated experience handling multi-terabyte Redshift clusters, concurrent query loads, and managing complex workload segmentation and queue priorities.
- Strong experience with AWS Glue (PySpark) for large-scale ETL jobs.
- Solid understanding and implementation experience of workflow orchestration using Apache Airflow or AWS Step Functions.
- Strong proficiency in Python, advanced SQL, and data modeling concepts.
- Familiarity with CI/CD pipelines, Git, DevOps processes, and infrastructure-as-code concepts.
Preferred/Bonus Skills:
- Experience with Amazon Athena, Lake Formation, or S3-based data lakes.
- Hands-on participation in Azure, BigQuery, or Teradata migration projects.
- AWS Certifications such as:
- AWS Certified Data Analytics Specialty
- AWS Certified Solutions Architect Associate/Professional
- Exposure to real-time streaming architectures or Lambda architectures.
Soft Skills Expectations:
- Excellent communication skills must be able to confidently engage with both technical and non-technical stakeholders, including clients.
- Strong problem-solving mindset and a keen attention to performance, scalability, and reliability.
- Demonstrated ability to work independently, lead tasks, and take ownership of large-scale systems.
- Comfortable working in a fast-paced, dynamic, and client-facing environment.
Required Skills
Disclaimer: This job posting and location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Section · 02
Skills
Aws GlueCI/CD PipelinesAuroraapisApacheadvanced sqlcachingamazon web servicesredshiftapache airflowCore DatabigqueryAnalyticsAws AuroraConcurrencyData AnalyticsconcurrentCommunication SkillsAWS CertifiedMicrosoft Azure
Section · Company
About ONETICK TECHNOLOGIES
ONETICK TECHNOLOGIES
Software Product
35
employees
2014
12 years old
Faridabad
IN
₹4.5L PA avg
Avg at ONETICK TECHNOLOGIES
About
Onetick Technologies offers IT services that transform businesses digitally, focusing on web solutions and software applications to enhance operational efficiency.
Industries
Software Product
Employee ratings
10 reviews
4.2/ 5
Culture
4.2
Career growth
4.1
Work-life
4.1
Employees rate it well for
Skill Development43Company Culture42
Find them on