Data Integration Developer - Intermediate
Data Integration Developer - Intermediate
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Position Description:
Join CGI!
Do you want to be part of one of the worlds 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 PowerCenter 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 PowerCenter 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.
- MicroStrategy 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).
Additional Skills:
- We are looking for an experienced Data Developer to join our Data Integration team in a nearshore collaboration model. This role focuses on developing and maintaining robust data integration solutions using top-tier enterprise tools like Azure Data Factory Informatica Cloud Informatica PowerCenter and QLIK Replication.
The selected candidate will play a key role in building and optimizing ETL processes supporting data warehouse operations and collaborating with cross-functional teams to deliver high-quality data solutions that support business intelligence and analytics initiatives. Soft skills include:
- Strong analytical and problem-solving skills.
- Excellent communication skills with both technical and non-technical audiences.
- Ability to work independently and manage multiple priorities.
- Experience working in Agile development environments.
Apply now!
#LI-AD3
What you can expect from us:
Together as owners lets turn meaningful insights into action.
Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because
You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.
Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.
Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our teamone of the largest IT and business consulting services firms in the world.
Employment Type
Full-Time
