Descripción general Join CGI! Do you want to be part of one of the world’s top five IT and business consulting firms? At CGI, we are looking for a Data Integration Developer to join an international project in the banking sector. Requirements: - Bachelor degree in Computer Science, Software Engineering, or related fields. - Conversational English (B2 or higher). - Over 5 years of experience in data integration and ETL development. - Over 3 years of hands-on experience in enterprise data warehouse projects. - Proven track record of delivering complex data integration solutions in production environments. - Azure Data Factory – Proven experience in designing and implementing data pipelines, managing triggers, and performance optimization. - Advanced SQL Development – Strong command of SQL programming, query optimization, and database performance tuning. - Informatica Cloud – Hands-on experience with cloud-based data integration, API management, and real-time processing. - Informatica Power Center – Solid experience in traditional ETL development, workflow design, and administration. - QLIK Replication – Experience in real-time data replication, change data capture (CDC), and data synchronization. - Snowflake – Proficiency in the Snowflake cloud data platform, including data storage, data sharing, and performance optimization. - Strong understanding of data warehousing concepts, dimensional modeling, and OLAP principles. - Experience with various data sources including relational databases, APIs, flat files, and cloud platforms. - Knowledge of data quality frameworks and data governance practices. - Proficiency in version control systems and CI/CD practices for data projects. Key Responsibilities: Data Integration Development (30%) - Design, develop, and maintain robust ETL routines to load the data warehouse from multiple source systems. - Implement data integration solutions using Azure Data Factory, Informatica Cloud, Informatica Power Center, and QLIK Replication. - Ensure data quality, accuracy, and consistency across all integration processes. Advanced SQL Development (30%) - Write complex SQL queries, stored procedures, and functions for data extraction, transformation, and loading. - Optimize SQL performance for large-scale data processing. - Develop and maintain database objects that support data warehouse operations. Business Requirements Analysis (15%) - Collaborate with Business Intelligence analysts to identify and understand source systems. - Translate business requirements into technical specifications and data integration solutions. - Participate in requirement gathering sessions and solution design discussions. Data Warehousing Implementation (10%) - Apply theory, best practices, and industry-standard techniques in data warehousing. - Design and implement dimensional models and data mart structures. - Ensure compliance with data governance and data quality standards. Data Mapping and Modeling (5%) - Map data elements from source systems to target data warehouse models. - Document data lineage and transformation logic. - Maintain metadata and data dictionaries. Production Support and Issue Resolution (5%) - Monitor ETL job performance and troubleshoot failures during and outside business hours. - Implement proactive monitoring and alerting mechanisms. - Provide Level 2/3 support for data integration issues. Project Collaboration and Documentation (5%) - Work independently or as part of project teams to deliver data integration solutions. - Create comprehensive project documentation, technical specifications, and support guides. - Participate in code reviews and knowledge-sharing sessions. Nice to Have: Extended Technical Experience - Microsoft Power BI – Experience creating reports, dashboards, and data models. - Micro Strategy – Knowledge of the enterprise reporting and analytics platform. - Tableau – Proficiency in data visualization and self-service analytics. Industry Experience - Experience with large-scale data warehouse implementations in enterprise environments. - Participation in cloud migration projects and hybrid data architectures. - Understanding of data lake concepts and modern data platform architectures. Excellence in Nearshore Collaboration - Proven success working in distributed and nearshore teams. - Strong communication skills in English (written and verbal). Apply now! Join CGI! Do you want to be part of one of the world’s top five IT and business consulting firms? At CGI, we are looking for a Data Integration Developer to join an international project in the banking sector. Requirements: - Bachelor degree in Computer Science, Software Engineering, or related fields. - Conversational English (B2 or higher). - Over 5 years of experience in data integration and ETL development. - Over 3 years of hands-on experience in enterprise data warehouse projects. - Proven track record of delivering complex data integration solutions in production environments. - Azure Data Factory – Proven experience in designing and implementing data pipelines, managing triggers, and performance optimization. - Advanced SQL Development – Strong command of SQL programming, query optimization, and database performance tuning. - Informatica Cloud – Hands-on experience with cloud-based data integration, API management, and real-time processing. - Informatica Power Center – Solid experience in traditional ETL development, workflow design, and administration. - QLIK Replication – Experience in real-time data replication, change data capture (CDC), and data synchronization. - Snowflake – Proficiency in the Snowflake cloud data platform, including data storage, data sharing, and performance optimization. - Strong understanding of data warehousing concepts, dimensional modeling, and OLAP principles. - Experience with various data sources including relational databases, APIs, flat files, and cloud platforms. - Knowledge of data quality frameworks and data governance practices. - Proficiency in version control systems and CI/CD practices for data projects. Key Responsibilities: Data Integration Development (30%) - Design, develop, and maintain robust ETL routines to load the data warehouse from multiple source systems. - Implement data integration solutions using Azure Data Factory, Informatica Cloud, Informatica Power Center, and QLIK Replication. - Ensure data quality, accuracy, and consistency across all integration processes. Advanced SQL Development (30%) - Write complex SQL queries, stored procedures, and functions for data extraction, transformation, and loading. - Optimize SQL performance for large-scale data processing. - Develop and maintain database objects that support data warehouse operations. Business Requirements Analysis (15%) - Collaborate with Business Intelligence analysts to identify and understand source systems. - Translate business requirements into technical specifications and data integration solutions. - Participate in requirement gathering sessions and solution design discussions. Data Warehousing Implementation (10%) - Apply theory, best practices, and industry-standard techniques in data warehousing. - Design and implement dimensional models and data mart structures. - Ensure compliance with data governance and data quality standards. Data Mapping and Modeling (5%) - Map data elements from source systems to target data warehouse models. - Document data lineage and transformation logic. - Maintain metadata and data dictionaries. Production Support and Issue Resolution (5%) - Monitor ETL job performance and troubleshoot failures during and outside business hours. - Implement proactive monitoring and alerting mechanisms. - Provide Level 2/3 support for data integration issues. Project Collaboration and Documentation (5%) - Work independently or as part of project teams to deliver data integration solutions. - Create comprehensive project documentation, technical specifications, and support guides. - Participate in code reviews and knowledge-sharing sessions. Nice to Have: Extended Technical Experience - Microsoft Power BI – Experience creating reports, dashboards, and data models. - Micro Strategy – Knowledge of the enterprise reporting and analytics platform. - Tableau – Proficiency in data visualization and self-service analytics. Industry Experience - Experience with large-scale data warehouse implementations in enterprise environments. - Participation in cloud migration projects and hybrid data architectures. - Understanding of data lake concepts and modern data platform architectures. Excellence in Nearshore Collaboration - Proven success working in distributed and nearshore teams. - Strong communication skills in English (written and verbal). Apply now! Profesional Universitaria Ingeniería de sistemas Computación Ingeniería electrónica Ingeniería mecatrónica Ingeniería telemática Ingenierìa De Software 5 años de experiencia 1 Vacante Habilidades clave Terminos que coinciden entre tu perfil y la oferta de trabajo (agregalos dentro de tu hoja de vida) - Data - SQL - ETL - Data Ware House - Azure Data Factory - ADF - Datos Cargos relacionados - Ingeniero de datos - Analista de datos - Científico de datos