Capco

2 weeks ago

Senior Data Engineering

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 3 hours agoStatus: Live

Job Summary

Design, build, and continuously improve scalable ETL/ELT pipelines that transform structured and semi-structured data into reliable, high-quality outputs. Build data warehouse and data mart models, optimize SQL and database performance, and integrate data from APIs, databases, and flat files. Partner with Data Analysts, Data Scientists, and product teams through code reviews and documentation, with cloud and GCP (e.g., BigQuery, Dataflow, Pub/Sub) as a preferred focus.

Location: Bengaluru

Workplace: Onsite

Employment Type: Full time

Job Function: Solutions Engineering & Sales Engineering

Seniority: Mid level

Key Responsibilities

•Design, develop, and maintain scalable ETL/ELT pipelines.
•Write and optimize complex SQL, stored procedures, functions, and triggers to improve performance.
•Build and maintain data warehouse and data mart structures with robust data modeling and quality checks.
•Integrate data from multiple sources (APIs, databases, flat files) and deliver batch and near real-time pipelines.
•Collaborate with data and product teams, participate in code reviews, and maintain documentation.

Key Requirements

•Strong hands-on SQL with advanced concepts (joins, window functions, CTEs, aggregations) and PL/SQL (procedures, packages, cursors).
•Experience developing and maintaining ETL/ELT pipelines and handling large datasets.
•Ability to design data warehouse/data mart structures and implement star and snowflake schema data models while ensuring data quality and integrity.
•Database experience with Oracle, SQL Server, PostgreSQL, or MySQL, plus performance optimization (indexing, query tuning, partitioning).
•Experience with GCP ecosystem and modern orchestration/tools is a plus (BigQuery, Cloud Composer/Airflow, Dataflow/Apache Beam, Cloud Storage, Pub/Sub).

Experience:3+ years

Skills:CollaborationDeliveryDocumentationEngineering quality focus

Languages:English

Tech Stack:SQLPL/SQLETLELTOracleSQL ServerPostgreSQLMySQLGCPBigQueryCloud StorageDataflowDataprocPub/SubCloud ComposerAirflowApache BeamPythonShell scriptingInformatica

Company Brief

Capco

Global management and technology consultancy specializing in financial services. Capco advises banks, insurers, and capital markets firms on digital transformation, risk and compliance, technology implementation, and operational improvement, combining industry expertise with advisory and engineering capabilities.

Industry: Management Consulting

Company Size: Enterprise (1,001+ employees)

Growth: Established Company

Headquarters: London, United Kingdom

Founded: 1998

Glassdoor: 3.7

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

Capco

2 weeks ago

Senior Data Engineering

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 3 hours agoStatus: Live

Job Summary

Location: Bengaluru

Workplace: Onsite

Employment Type: Full time

Job Function: Solutions Engineering & Sales Engineering

Seniority: Mid level

Key Responsibilities

•Design, develop, and maintain scalable ETL/ELT pipelines.
•Write and optimize complex SQL, stored procedures, functions, and triggers to improve performance.
•Build and maintain data warehouse and data mart structures with robust data modeling and quality checks.
•Integrate data from multiple sources (APIs, databases, flat files) and deliver batch and near real-time pipelines.
•Collaborate with data and product teams, participate in code reviews, and maintain documentation.

Key Requirements

•Strong hands-on SQL with advanced concepts (joins, window functions, CTEs, aggregations) and PL/SQL (procedures, packages, cursors).
•Experience developing and maintaining ETL/ELT pipelines and handling large datasets.
•Ability to design data warehouse/data mart structures and implement star and snowflake schema data models while ensuring data quality and integrity.
•Database experience with Oracle, SQL Server, PostgreSQL, or MySQL, plus performance optimization (indexing, query tuning, partitioning).
•Experience with GCP ecosystem and modern orchestration/tools is a plus (BigQuery, Cloud Composer/Airflow, Dataflow/Apache Beam, Cloud Storage, Pub/Sub).

Experience:3+ years

Skills:CollaborationDeliveryDocumentationEngineering quality focus

Languages:English

Tech Stack:SQLPL/SQLETLELTOracleSQL ServerPostgreSQLMySQLGCPBigQueryCloud StorageDataflowDataprocPub/SubCloud ComposerAirflowApache BeamPythonShell scriptingInformatica

Company Brief

Capco

Industry: Management Consulting

Company Size: Enterprise (1,001+ employees)

Growth: Established Company

Headquarters: London, United Kingdom

Founded: 1998

Glassdoor: 3.7

Website LinkedIn