IQube
A
iQube
é uma empresa de consultoria em IT sediada em Lisboa, Portugal, especializada em acelerar a transformação digital dos seus clientes através de soluções tecnológicas inteligentes e eficientes.
A empresa concentra-se em três áreas principais de serviços:
Outsourcing de IT
(fornecimento de integração escalável de profissionais experientes),
Implementação de Projetos
(desenvolvimento de software personalizado, web e aplicações móveis) e
Consultoria em IA
(ajudando as organizações a implementar e otimizar estratégias de
Inteligência Artificial
, desde avaliações de viabilidade até à construção de sistemas preditivos).
A
iQube
opera com uma abordagem flexível e centrada no cliente, apoiando tanto operações nacionais portuguesas como clientes internacionais através de um modelo nearshore.
Mid-Level SQL & Data Migration Developer (Sintra, Lisbon)
Language:
Fluent in Portuguese (Mandatory)
Experience Level:
Mid-Level (3-5+ Years in Software/Data Development)
Focus:
SQL Server, SSIS, Data Migration, Performance Tuning
About the Role
We are looking for a skilled and proactive SQL Developer to join our team in Lisbon.
This unique role requires a blend of traditional software development knowledge and deep database expertise, specifically focused on migrating critical business data from legacy systems into our main JDE (JD Edwards) platform.
You will be instrumental in the ETL process, using SQL Server Integration Services (SSIS) and advanced T-SQL programming to ensure data integrity, optimize migration performance, and modernize existing database logic.
This is a technical position that requires meticulous attention to detail and a passion for data quality.
Key Responsibilities
Data Migration: Design, develop, and maintain robust SSIS (SQL Server Integration Services) packages to successfully extract, transform, and load data from various legacy systems (including Cobol) into the JDE application environment.
T-SQL Development: Write, test, and optimize complex stored procedures, functions, and triggers within SQL Server to support SSIS operations and enhance overall data processing performance.
Performance Tuning: Analyze and refactor existing legacy procedures (including those originally written in Cobol) by translating and optimizing the logic into highly efficient SQL Server code.
Collaboration: Work closely with the legacy system experts and the JDE functional team to understand source and target data requirements and ensure accurate data mapping.
Documentation: Create and maintain detailed documentation for all SSIS packages, data mappings, and newly developed SQL procedures.
Requirements
Language: Fluent in Portuguese (written and spoken) is mandatory.
Experience: 3+ years of professional experience in software development, with a significant focus on data manipulation and database development.
SQL Server Mastery: Expert-level proficiency in Microsoft SQL Server (T-SQL programming, indexing, query optimization, and execution plan analysis).
ETL Expertise: Strong practical experience designing and implementing complex ETL workflows using SSIS (SQL Server Integration Services).
Data Integration: Experience working with diverse data sources and file formats typical of legacy systems (e.G., flat files, Cobol databases).
Software Development Background: A strong understanding of software development lifecycle (SDLC) concepts, version control, and data structure principles.
Desirable (Bonus) Skills
Prior experience with the JDE (JD Edwards) data structure or other large-scale ERP systems.
Knowledge of relational database design and data warehousing concepts.
Familiarity with PowerShell for automation tasks