🇪🇸 Madrid, Spain · 3w ago
Senior ETL Developer – Ab Initio & Informatica IDMC
Cognizant
LinkedInseniorEnglish-friendly
Remote SpainAbout The RoleWe'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 YouRestaurant tickets for every working dayPermanent contract — we're investing in a long-term relationshipFlexible benefits: Gympass and nursery tickets through our flexible retribution schemeReferral bonus — bring great people in and get rewardedCompetitive salary and bonuses — let's talk numbers on our first callWhat You'll Bring5 to 10 years of experience in ETL development, data integration, or data warehousingHands-on experience with Ab Initio — requiredStrong hands-on experience with Informatica IDMC for building cloud-native data integration solutionsExperience analysing and migrating Ab Initio ETL workflows and logic into Informatica IDMCStrong experience with Teradata: SQL development, performance tuning, data warehouse concepts, and legacy ETL analysisStrong experience with Snowflake: schema design, data loading, transformations, performance optimization, and cloud-native development patternsProven experience in Teradata on-premise to Snowflake cloud migration projectsSolid understanding of data warehouse architecture, dimensional modelling, and data transformation frameworksExperience developing and optimizing ETL/ELT pipelines in hybrid and cloud environmentsGood understanding of data reconciliation, migration validation, and test support during platform modernizationExperience working in SAFe Agile delivery environments, with active participation in sprint and PI-level planningExperience supporting CI/CD-enabled deployments in cloud data environmentsStrong analytical, troubleshooting, and problem-solving skillsFluent English and professional working proficiency in Spanish (B2 or above) — required for client-facing meetings, calls, and workshopsWhat You'll DoDesign, develop, and maintain scalable ETL/ELT pipelines using Informatica IDMC for enterprise data integration needsAnalyse existing Ab Initio ETL workflows, logic, and data models and redesign them for optimised implementation in Informatica IDMCWork on migration initiatives from Teradata on-premise to Snowflake cloud, including data extraction, transformation, validation, reconciliation, and deploymentAnalyse existing Teradata-based ETL workflows, data models, and SQL logic and redesign them for optimised implementation in SnowflakeDevelop and optimise complex SQL queries, transformation logic, stored procedures, and performance-tuned data pipelines across Teradata and SnowflakeBuild robust ingestion and transformation frameworks for structured and semi-structured data in cloud environmentsEnsure high data quality, consistency, and integrity during migration and post-migration stabilisationSupport data validation, reconciliation, and testing activities during migration from legacy on-premise environments to cloudParticipate in SAFe Agile ceremonies including PI planning, sprint planning, daily stand-ups, backlog refinement, retrospectives, and demosContribute to technical documentation including source-to-target mappings, design specifications, migration approach documents, and operational runbooksTroubleshoot and resolve ETL and data integration issues, performance bottlenecks, and production incidentsWork closely with DevOps and platform teams to support CI/CD-enabled deployments and release processesFollow enterprise standards for security, governance, metadata management, and data engineering best practicesCollaborate with architects, data engineers, analysts, product owners, and business stakeholders to define technical solutions aligned with business requirementsReady to modernise enterprise data at cloud scale? Apply now and let's talk.Sourced from LinkedIn. Relocantly aggregates public job postings; apply on the original site.