refresh

トレンド企業

Trending

採用

JobsCitigroup

Senior Data Engineer - Assistant Vice President

Citigroup

Senior Data Engineer - Assistant Vice President

Citigroup

chennai

·

On-site

·

Full-time

·

2w ago

Benefits & Perks

Healthcare

401(k)

Paid Time Off

Healthcare

401k

Required Skills

PySpark

Python

Hive

Hadoop

SQL

Shell scripting

ETL

We are seeking a highly skilled and motivated Big Data Engineer to join our dynamic team. The ideal candidate will have extensive experience in designing, developing, and optimizing scalable data solutions using the Hadoop ecosystem, with a strong focus on Py Spark and Hive. This role is crucial for building robust ETL pipelines, ensuring data quality, and driving performance improvements across our Big Data initiatives.

Key Responsibilities

  • Design, develop, and maintain efficient and scalable Big Data solutions using Py Spark, Apache Hive, and Hadoop ecosystem tools (e.g., Sqoop).

  • Should have strong Python knowledge

  • Implement and optimize ETL (Extract, Transform, Load) processes and data warehousing solutions, including Fact, Dimension, and Slowly Changing Dimensions (SCD-2).

  • Conduct in-depth data analysis, troubleshoot complex data issues, and ensure the accuracy, reliability, and integrity of data.

  • Optimize Big Data workflows, including Spark job tuning and Hive query optimization, leveraging partitioning strategies and indexing techniques in distributed storage systems.

  • Perform rigorous unit testing and validation of data pipelines and transformations.

  • Collaborate with data scientists, analysts, and other engineers to understand data requirements and deliver robust data solutions.

Technical Qualifications

  • Big Data Technologies: Demonstrated proficiency with Apache Hadoop, Apache Hive, and Py Spark for data processing and analysis.

  • Data Warehousing & Modeling: Strong understanding and practical experience with data warehousing concepts, dimensional modeling, and SCD-2 implementation.

  • ETL Development: Proven experience in designing and developing ETL pipelines; familiarity with various ETL tools is an advantage.

  • Database & SQL: Advanced SQL knowledge, including complex joins, subqueries, and performance tuning of SQL queries.

  • Scripting: Proficient in shell scripting for automation of batch processes.

  • DevOps & CI/CD: Experience with CI/CD tools such as Bitbucket and Jenkins.

  • BI Tools: Familiarity with business intelligence (BI) reporting tools like Tableau.

Desirable Qualifications (Added Advantage)

  • Experience and/or certifications with major cloud platforms and their Big Data services (e.g., AWS, Azure Databricks, Google Cloud).

  • Advanced knowledge of Unix shell scripting for system administration and automation.

Skills & Attributes

  • Excellent critical thinking and problem-solving skills with a strong analytical mindset.

  • Ability to work independently and collaboratively in a fast-paced environment.

  • Strong communication skills to articulate technical concepts and solutions effectively.

Education:

  • Bachelor’s degree/University degree or equivalent experience

If you are a passionate Big Data Engineer looking to make a significant impact, we encourage you to apply!

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Job Family Group:

Technology

Job Family:

Applications Development

Time Type:

Full time

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

*If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review *Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.

Total Views

0

Apply Clicks

0

Mock Applicants

0

Scraps

0

About Citigroup

Citigroup

Citigroup

Public

Citigroup Inc. or Citi is an American multinational investment bank and financial services company based in New York City. The company was formed in 1998 by the merger of Citicorp, the bank holding company for Citibank, and Travelers; Travelers was spun off from the company in 2002.

10,001+

Employees

New York City

Headquarters

Reviews

3.3

4 reviews

Work Life Balance

3.0

Compensation

3.2

Culture

2.8

Career

2.5

Management

2.7

35%

Recommend to a Friend

Pros

Compensation increases for investment banking roles

Legitimate investment banking employer

Internship opportunities available

Cons

Unclear career progression paths

Limited meaningful experience in internships

Compensation raises lower than competitors

Salary Ranges

28 data points

Mid/L4

Senior/L5

Staff/L6

Mid/L4 · Business Risk Intermediate Analyst

1 reports

$77,165

total / year

Base

$67,100

Stock

-

Bonus

-

$77,165

$77,165

Interview Experience

5 interviews

Difficulty

2.8

/ 5

Duration

14-28 weeks

Experience

Positive 0%

Neutral 40%

Negative 60%

Interview Process

1

Application Review

2

Recruiter Screen

3

Programming Assessment

4

Hiring Manager Interview

5

Panel/Superday Interviews

6

Final Decision

Common Questions

Technical Knowledge

Case Study

Behavioral/STAR

Past Experience

Culture Fit