Data Production & ETL Ops Engineer (Hybrid Lisbon)

Tata Consultancy Services; Lisboa; Híbrido; EUR 60 000 - 90 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Competitive salary

Flexible compensation plan

Ticket restaurant plan + Health Ins

Resumo da oferta

Tata Consultancy Services in Lisbon is seeking an experienced Data Production Support/Operational Engineer to own production support for data warehouses and ETL pipelines.

You will monitor ETL workflows, optimize queries, manage incidents, perform RCA, and collaborate with cross‑functional teams in a hybrid work setup. A 6+ year background in data warehousing, Informatica, Airflow, and CI/CD is required to improve data reliability and performance.

Qualificações

• 6+ years in Data Warehouse, ETL, Data Integration, or Production Support.
• 5+ years hands‑on with Informatica PowerCenter and/or IICS/IDMC.
• Strong understanding of ETL, data integration, and data warehouse concepts.
• Advanced SQL knowledge for complex queries and performance optimization.
• Experience with job scheduling/orchestration tools like Airflow and TWS.
• Hands‑on with Git, Azure DevOps and version control best practices.
• Production support and operations management within Data Warehouse environments.
• Experience with incident, problem, change management and RCA.
• Knowledge of SLA management, KPI tracking, and operational reporting.
• Familiarity with CI/CD for ETL and Data Warehouse solutions.

Responsabilidades

• Monitor and support daily Data Warehouse production operations.
• Ensure ETL workflows and batch jobs run reliably and on time.
• Investigate, troubleshoot and resolve production incidents and data load failures.
• Perform RCA and implement preventive measures.
• Coordinate with business and technical teams to resolve issues within SLAs.
• Execute operational tasks like job restarts, reruns, and recovery procedures.
• Analyze SQL queries and assist performance tuning with DB teams.
• Validate data loads and ensure source/target data integrity.
• Support CI/CD deployment for ETL and Data Warehouse solutions.
• Maintain and improve operational runbooks and documentation.

Conhecimentos

Data warehouse

ETL/Data integration

Informatica PowerCenter

Informatica IICS/IDMC

SQL

Airflow

TWS (Tivoli Workload Scheduler)

Git

Azure DevOps

Data modeling

Data Vault

CI/CD

Cloud data integration

Formação académica

Bachelor's or Master's in Computer Science, Information Systems, Data Engineering, or related field

Ferramentas

Informatica PowerCenter

Informatica IICS/IDMC

Airflow

TWS

Git

Azure DevOps

Azure Data Factory

Descrição da oferta de emprego

Tata Consultancy Services in Lisbon is seeking an experienced Data Production Support/Operational Engineer to own production support for data warehouses and ETL pipelines.

You will monitor ETL workflows, optimize queries, manage incidents, perform RCA, and collaborate with cross‑functional teams in a hybrid work setup. A 6+ year background in data warehousing, Informatica, Airflow, and CI/CD is required to improve data reliability and performance.