Citigroup logo

Data Engineer

Citigroup
NewPosted today

LOCATION

DLF CYBERCITY 12B · Hybrid

EXPERIENCE

2+ Years

TYPE

FullTime

SKILLS REQUIRED

SQLPythonData PipelinesData WarehousingData QualityData ModelingETL/ELTApache AirflowSpark

Job description

Overview

Assist in designing, building, maintaining and optimizing scalable data pipelines, data warehouses and analytics infrastructure, working with senior data engineers, data scientists, software developers and business stakeholders.

What you'll do

  • Assist in developing, testing and maintaining automated ETL/ELT pipelines to ingest structured and unstructured data from diverse sources (APIs, relational databases, streaming services, flat files).
  • Monitor existing data pipelines, troubleshoot data ingestion failures, and implement bug fixes or performance enhancements.
  • Implement data transformation, cleansing and validation routines to maintain high data quality and consistency.
  • Support the design and maintenance of relational schemas, dimensional models (star and snowflake schemas) and data lake storage structures.
  • Write and optimize SQL queries, stored procedures and views to extract and aggregate data efficiently.
  • Assist in partitioning, indexing and organizing datasets for optimal query performance.
  • Collaborate with senior engineers to implement data validation checks, monitoring alerts and data reconciliation processes.
  • Follow enterprise data governance, privacy and security policies (e.g., role-based access control, encryption, data masking).
  • Document data lineage, metadata definitions, schema changes and technical architecture.
  • Participate in agile/scrum ceremonies including daily stand-ups, sprint planning and retrospective meetings.
  • Use version control systems (Git) for code management and follow CI/CD practices.
  • Collaborate with QA teams and business analysts to conduct integration and user acceptance testing (UAT).

What you'll need

  • Bachelor's degree in Computer Science, Information Technology, Data Science, Software Engineering, Applied Mathematics, or a related quantitative field (or equivalent practical experience/bootcamp certification).
  • 2+ years of relevant hands-on experience in data engineering, data analytics, software development, or related academic/internship projects.
  • Python and SQL (mandatory).
  • Relational databases: PostgreSQL, MySQL, MS SQL Server, or Oracle, with proficiency in joins, window functions, indexing and aggregations.
  • Familiarity with data warehousing and lake platforms such as Snowflake, Google BigQuery, AWS Redshift, Databricks, or cloud storage (AWS S3, Azure Blob, GCS).
  • Basic understanding of Apache Spark, PySpark, Pandas or Polars.
  • Exposure to workflow orchestration tools such as Apache Airflow, Prefect, Dagster, or cron-based job scheduling.
  • Git/GitHub/GitLab, basic containerization (Docker), and exposure to CI/CD pipelines.
  • Strong analytical thinking and troubleshooting mindset with attention to detail.
  • Ability to communicate technical concepts clearly to both technical and non-technical stakeholders.
  • Eagerness to learn modern data architectures, cloud technologies and best practices; self-starter with a proactive attitude.
  • Strong collaborative skills and ability to thrive in a team-oriented, fast-paced environment.

Nice to have

  • Java, Scala or Bash scripting.
  • Cloud certification (e.g., AWS Certified Cloud Practitioner / Data Analytics, Azure Data Fundamentals DP-900 / DP-203, or GCP Associate Cloud Engineer).
  • Familiarity with modern data stack tools such as dbt (data build tool), Kafka or Delta Lake.
  • Understanding of basic DevOps and Infrastructure-as-Code concepts (e.g., Terraform, Kubernetes).
  • Familiarity with BI and visualization tools (e.g., Tableau, Power BI, Looker).
  • Hands-on with Shell scripts, PySpark, Hadoop ecosystem.
  • Knowledge of DevOps and CI/CD pipelines.

Details

  • Full-time employment.
  • Location: DLF Cybercity, Gurugram (DLF CYBERCITY 12B).

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Data Engineer