> Markdown version of [/jobs/ext/1260045-senior-etl-developer-ab-initio-informatica-idmc](https://www.wearedevelopers.com/jobs/ext/1260045-senior-etl-developer-ab-initio-informatica-idmc). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior ETL Developer - Ab Initio & Informatica IDMC

- **Company:** Cognizant
- **Location:** Madrid, Spain (Remote available)
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Data Analysis, Cloud Computing, Cloud Database, Continuous Integration, Data Validation, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Mining, Data Warehousing, Database Development, DevOps, Dimensional Modeling, Meta-Data Management, Performance Tuning, Scrum Methodology, Cloud Services, Standard Sql, DataOps, SQL Stored Procedures, SQL Databases, Teradata SQL, Freeform SQL, Cloud Platform System, Snowflake, Ab Initio, Semi-structured Data, Enterprise Integration, Data Management, Cloud Migration, Data Pipelines
- **Published:** July 14, 2026
- **Apply:** https://dejobs.org/x/x/B469A9B421864A7688CB8C5AC0DD6A05/job/

## About the Role

* 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

## Description

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., * 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


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment)
- [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Spanish Business Culture and Etiquette](https://www.wearedevelopers.com/magazine/353-spanish-business-culture-and-etiquette)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)