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