ETL developer in data warehousing

грейд
senior
формат
гибрид Лиссабон
язык
Английский B1
опубликована
сегодня

описание

Hybrid working model.

At Decskill, we believe that technological excellence is driven by human talent. We are an IT consulting company with more than 10 years of consolidated experience in the market, focused on building long-term relationships with both our clients and our people. Today, we are a community of over 800 professionals, working from Lisbon, Porto, and Madrid, contributing to impactful technology initiatives. We would like to meet a Senior ETL Developer- Informatica PowerCenter

задачи

  • Design technical architectures for complex data flows, mappings, mapplets and workflows.
  • Develop, test and deploy robust ETL processes using Informatica PowerCenter and, ideally, IICS.
  • Write and optimize complex SQL queries, stored procedures and Shell scripts.
  • Integrate heterogeneous data sources including relational databases, flat files, APIs, XML/JSON and Cloud platforms.
  • Analyze and optimize ETL and database performance.
  • Troubleshoot and resolve complex Level 3 production incidents.
  • Ensure data quality, integrity and security throughout ETL processes.
  • Automate scheduling and workload processes using tools such as Control-M, AutoSys or Dollar Universe.
  • Maintain high-quality technical documentation.
  • Act as a Tech Lead, contribute to code reviews and promote development best practices.
  • Mentor and support other members of the development team.

требования

  • 7+ years of professional experience as an ETL Developer.
  • Advanced expertise in Informatica PowerCenter: Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Strong knowledge of SQL and significant experience with a major DBMS such as Oracle, SQL Server, Teradata or PostgreSQL.
  • Solid Shell/Bash/Unix/Linux scripting experience.
  • Strong understanding of Data Warehousing, including Star/Snowflake schemas, Kimball/Inmon methodologies and SCD.
  • Будет плюсом: Experience with Informatica IICS, IDQ or MDM; Knowledge of AWS, Azure, Snowflake or Google Cloud Platform; Experience with workload automation tools such as Control-M or Jenkins; Experience working in Agile environments (Scrum/Kanban)

условия

  • Long-term projects with national and international context
  • Opportunities to grow technically and professionally
  • A people-first culture, focused on transparency and trust
  • Teams that value ownership, collaboration and stability

навыки

компания

похожие вакансии

статьи для разработчиков