Back to jobs
G

Senior Engineer - IT

ChennaiPosted Yesterday
Full-timehybrid

Job Description

Job Description:

Key Responsibilities

  • Design, develop, and maintain scalable data pipelines using Databricks and PySpark
  • Build robust ETL/ELT workflows for batch and near real‑time data processing
  • Write optimized and efficient SQL queries for data transformation, validation, and analysis
  • Work with large-scale distributed datasets using Spark-based processing frameworks
  • Perform data ingestion from multiple sources (APIs, files, databases) into data lake/lakehouse architecture
  • Ensure data quality, integrity, and consistency through validations and monitoring
  • Optimize pipeline performance and cost (partitioning, caching, query tuning, etc.)
  • Collaborate with cross-functional teams (Data Ops, Business, Analytics) to deliver data solutions
  • Troubleshoot pipeline failures and implement proactive monitoring and alerting
  • Maintain proper documentation for data models, transformations, and workflows

Required Skills & Experience

  • Strong hands-on experience in:
    • Databricks (Lakehouse platform, notebooks, jobs, clusters)
    • PySpark / Apache Spark
    • Advanced SQL (joins, window functions, performance tuning)
  • Solid understanding of ETL concepts, data warehousing, and data modeling
  • Experience building scalable data pipelines for structured and semi-structured data
  • Familiarity with data lake / delta lake architecture
  • Good understanding of performance optimization techniques in Spark and SQL
  • Experience with version control (Git) and deployment practices
  • Strong problem-solving and analytical skills

Good to Have

  • Experience with cloud platforms (AWS preferably)
  • Exposure to CI/CD pipelines (Jenkins)
  • Knowledge of Delta Lake, Unity Catalog, or similar governance tools
  • Understanding of data quality frameworks / monitoring tools
  • Experience working in Agile / Scrum teams

Location:

This position can be based in any of the following locations:

Chennai

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday

Senior Engineer - IT at Guardianlife | Renata