Data Engineer II - Snowflake, DBT, AWS

First Citizens India; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

First Citizens India in Bengaluru is searching for a Data Engineer II who will be responsible for building and maintaining data platforms crucial for enterprise data integration. This hybrid role requires expertise in data engineering, data warehousing, and strong collaboration skills.

The ideal candidate has solid experience with SQL and ETL tools, and is committed to excellence in supporting the organization's data objectives.

Join a company that values inclusivity and transparency in the fast-paced financial sector.

Qualifications

• Experience in designing and building Data Warehouse and Data lakes.
• Good knowledge of data warehouse principles and concepts.
• Technical expertise working in large scale Data Warehousing applications.

Responsibilities

• Build and maintain data platform that supports data integrations.
• Create data ingestion pipelines for various sources.
• Build reusable Data pipelines/frameworks using Python.

Skills

Team Player

Excellent verbal, written, and interpersonal communication skills

Problem Solving

Partnership and Collaboration

Attention to Detail

Design and building Data Warehouse and Data lakes

Large scale Data Warehousing applications

Public cloud-based data platforms

Complex data pipelines

Expert in SQL

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle

Netezza

SQL Server

Snowflake

AWS

Gitlab

Job description

Job Details

Position Title: Data Engineer II
Career Level: P2
Job Category: Senior Associate
Role Type: Hybrid
Job Location: Bangalore

Impact

Enterprise data warehouse supports several critical business functions for the bank including Regulatory Reporting, Finance, Risk steering, and Customer 360. This role is vital for building and maintaining enterprise data platform, data processes, and to support business objectives. Our values — inclusivity, transparency, and excellence — drive everything we do. Join us and make a meaningful impact on the organization.

Key Deliverables (Duties and Responsibilities)

• Responsible for building and maintaining data platform that supports data integrations for Enterprise Data Warehouse, Operational Data Store or Data Marts etc. with appropriate data access, data security, data privacy and data governance.
• Create data ingestion pipelines in data warehouses and other large-scale data platforms.
• Create Data Ingestion pipeline for a variety of sources – File (Flat, delimited, Excel), DB, API (With Apigee integration), and SharePoint.
• Build reusable Data pipelines / frameworks using Python.
• Creating scheduled as well as trigger-based ingestion patterns using scheduling tools.
• Create performance optimized DDLs for any row-based or columnar databases such as Oracle, Postgres, Netezza database per Logical Data Model.
• Performance tuning of complex data pipelines and SQL queries.
• Performs impact analysis of proposed changes on existing architecture, capabilities, system priorities, and technology solutions.
• Working in Agile Framework, participating in various agile ceremonies, co‑ordination with scrum master, tech lead, and PO on sprint planning, backlog creation, refinement, demo, and retrospection.
• Working with Product Owners to understand PI goals, PI planning, requirement clarification, and delivery coordination.
• Technical support for production incidents and failures
• Work with global technology teams across different time zones (primarily US) to deliver timely business value.

Skills and Qualifications

Functional Skills

• Team Player: Support peers, team, and department management.
• Communication: Excellent verbal, written, and interpersonal communication skills.
• Problem Solving: Excellent problem‑solving skills, incident management, root cause analysis, and proactive solutions to improve quality.
• Partnership and Collaboration: Develop and maintain partnership with business and IT stakeholders
• Attention to Detail: Ensure accuracy and thoroughness in all tasks.

Technical/Business Skills

• Data Engineering:
  • Experience in designing and building Data Warehouse and Data lakes. Good knowledge of data warehouse principles, and concepts.
  • Technical expertise working in large scale Data Warehousing applications and databases such as Oracle, Netezza, and SQL Server.
  • Experience with public cloud-based data platforms especially Snowflake and AWS.
• Data integration skills:
  • Expertise in design and development of complex data pipelines
  • Solutions using any industry leading ETL tools such as IBM Data Stage and/or SAP BODS
  • Basic knowledge of ELT tools such as DBT (Data Build Tool), Fivetran, and AWS Glue
• Expert in SQL - development experience in at least one scripting language (Python etc.), adept in tracing and resolving data integrity issues.
• Data Model: Knowledge of Logical and Physical Data Model using Relational or Dimensional Modeling practices, high volume ETL/ELT processes.
• Performance tuning of data pipelines and DB Objects to deliver optimal performance.
• Experience in Gitlab version control and CI/CD processes.
• Experience working in Financial Industry is a plus.

Equal Employment Opportunity

FC Global Services India LLP (First Citizens India) is an Equal Employment Opportunity Employer. We are committed to fostering an inclusive and accessible environment and prohibit all forms of discrimination on the basis of gender, religion, caste, disability, sexual orientation, economic status or any other characteristics protected by the law. We strive to foster a safe and respectful environment in which all individuals are treated with respect and dignity. Our EEO policy ensures fairness throughout the employee life cycle.