Senior ETL Developer – Ab Initio & Informatica IDMC, Madrid, Madrid, Spain

Senior ETL Developer – Ab Initio & Informatica IDMC
Remote · Spain

About the role

We're looking for a Senior ETL Developer to design, develop, and maintain scalable data integration solutions as part of a large-scale Ab Initio to Informatica IDMC migration programme, including a Teradata-to-Snowflake data migration. If you have deep hands-on experience with both Ab Initio and Informatica IDMC, strong SQL and data warehousing skills, and a track record delivering in Agile environments — this role is for you.

Why join us?

HIGH-IMPACT PROJECTS — Work on demanding digitalization initiatives or build solutions from the ground up. This is where your expertise makes a real difference.

CUTTING-EDGE TECH — Stay sharp with the latest data management technologies and cloud platforms. We invest in keeping you ahead of the curve.

FULLY REMOTE IN SPAIN — Work from wherever you're most productive. No relocation, no commute, full flexibility.

CONTINUOUS LEARNING — Access to top learning platforms to deepen your expertise or pick up new skills you've been putting off.

A TEAM THAT HAS YOUR BACK — Talented colleagues who collaborate, support, and push each other to deliver quality work.

GLOBAL EXPOSURE — Work alongside international teams in a truly multicultural environment.

A CLEAR CAREER PATH — Grow vertically into greater responsibility or horizontally into new technologies. You decide the direction.

What's in it for you

Restaurant tickets for every working day
Permanent contract — we're investing in a long-term relationship
Flexible benefits: Gympass and nursery tickets through our flexible retribution scheme
Referral bonus — bring great people in and get rewarded
Competitive salary and bonuses — let's talk numbers on our first call

What you'll bring

5 to 10 years of experience in ETL development, data integration, or data warehousing
Hands-on experience with Ab Initio — required
Strong hands-on experience with Informatica IDMC for building cloud-native data integration solutions
Experience analysing and migrating Ab Initio ETL workflows and logic into Informatica IDMC
Strong experience with Teradata: SQL development, performance tuning, data warehouse concepts, and legacy ETL analysis
Strong experience with Snowflake: schema design, data loading, transformations, performance optimization, and cloud-native development patterns
Proven experience in Teradata on-premise to Snowflake cloud migration projects
Solid understanding of data warehouse architecture, dimensional modelling, and data transformation frameworks
Experience developing and optimizing ETL/ELT pipelines in hybrid and cloud environments
Good understanding of data reconciliation, migration validation, and test support during platform modernization
Experience working in SAFe Agile delivery environments, with active participation in sprint and PI-level planning
Experience supporting CI/CD-enabled deployments in cloud data environments
Strong analytical, troubleshooting, and problem-solving skills
Fluent English and professional working proficiency in Spanish (B2 or above) — required for client-facing meetings, calls, and workshops

What you'll do

Design, develop, and maintain scalable ETL/ELT pipelines using Informatica IDMC for enterprise data integration needs
Analyse existing Ab Initio ETL workflows, logic, and data models and redesign them for optimised implementation in Informatica IDMC
Work on migration initiatives from Teradata on-premise to Snowflake cloud, including data extraction, transformation, validation, reconciliation, and deployment
Analyse existing Teradata-based ETL workflows, data models, and SQL logic and redesign them for optimised implementation in Snowflake
Develop and optimise complex SQL queries, transformation logic, stored procedures, and performance-tuned data pipelines across Teradata and Snowflake
Build robust ingestion and transformation frameworks for structured and semi-structured data in cloud environments
Ensure high data quality, consistency, and integrity during migration and post-migration stabilisation
Support data validation, reconciliation, and testing activities during migration from legacy on-premise environments to cloud
Participate in SAFe Agile ceremonies including PI planning, sprint planning, daily stand-ups, backlog refinement, retrospectives, and demos
Contribute to technical documentation including source-to-target mappings, design specifications, migration approach documents, and operational runbooks
Troubleshoot and resolve ETL and data integration issues, performance bottlenecks, and production incidents
Work closely with DevOps and platform teams to support CI/CD-enabled deployments and release processes
Follow enterprise standards for security, governance, metadata management, and data engineering best practices
Collaborate with architects, data engineers, analysts, product owners, and business stakeholders to define technical solutions aligned with business requirements

Ready to modernise enterprise data at cloud scale? Apply now and let's talk.

Sobre a Cognizant
Cognizant (NASDAQ: CTSH) é uma construtora de IA e fornecedora de serviços de tecnologia, criando a ponte entre o investimento em IA e o valor para as empresas por meio do desenvolvimento de soluções de IA completas para nossos clientes. Nossa profunda experiência em setores, processos e engenharia nos permite incorporar o contexto único de cada organização em sistemas tecnológicos que potencializam a capacidade humana, geram resultados tangíveis e mantêm empresas globais à frente em um mundo em rápida transformação. Saiba mais em cognizant.ai ou @cognizant.

A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.

Informações adicionais de emprego
Os candidatos podem ser obrigados a comparecer a entrevistas presenciais ou por videoconferência. Além disso, os candidatos podem ser obrigados a apresentar seu documento de identificação emitido pelo estado ou governo atual durante cada entrevista.

Embora nosso sistema permita a candidatura em todos os idiomas, o(s) idioma(s) e o(s) nível(is) de proficiência exigidos para o trabalho variam. No entanto, é necessário um nível básico de inglês para fins de comunicação em toda a empresa.

Se você tem uma deficiência que requer adaptações razoáveis para procurar uma vaga de emprego ou enviar uma candidatura, envie um e-mail para [email protected] com sua solicitação e informações de contato.