ETL Developer
Offre en anglaisRoles & Responsibilities: Design, develop, and maintain ETL solutions using IBM DataStage. Work on Data Warehouse projects involving data extraction, transformation, and loading from various source systems. Provide production support, troubleshoot ETL failures, and perform root cause analysis. Develop and optimize SQL and PL/SQL queries, stored procedures, and database objects. Build and maintain Unix shell scripts for automation and operational support. Develop Python-based solutions for data processing, validation, and automation requirements. Collaborate with business analysts, architects,…
- Sur place
- ONTARIO
- Publié 24 juill. 2026
- Postuler avant le 23 août 2026
- 1 poste
Résumé du poste
Roles & Responsibilities: Design, develop, and maintain ETL solutions using IBM DataStage. Work on Data Warehouse projects involving data extraction, transformation, and loading from various source systems. Provide production support, troubleshoot ETL failures, and perform root cause analysis. Develop and optimize SQL and PL/SQL queries, stored procedures, and database objects. Build and maintain Unix shell scripts for automation and operational support. Develop Python-based solutions for data processing, validation, and automation requirements. Collaborate with business analysts, architects, and stakeholders to understand data integration requirements. Ensure data quality, performance tuning, and adherence to development standards and best practices. Participate in code reviews, testing, deployment, and documentation activities. Qualifications & Skill s:Strong knowledge of Data Warehousing concepts and ETL methodologie s.Hands-on experience in IBM DataStage development and support project s.Experience in designing and building DataStage solutions and ETL workflow s.Strong proficiency in SQL and PL/SQ L.Hands-on experience with Python scripting and automatio n.Good experience in Unix/Linux scriptin g.Experience working with Hive and/or relational databases such as Oracle, SQL Server, DB2, or PostgreSQ L.Strong analytical, troubleshooting, and problem-solving skill s.Excellent communication and teamwork abilitie s.Ability to work in a fast-paced and collaborative environmen t.
Ce que vous ferez
Design, develop, and maintain ETL solutions using IBM DataStage to integrate data from various source systems into a data warehouse. Provide production support, optimize database queries, and create automation scripts using Python and Unix shell.
Exigences
Requires strong hands-on experience with IBM DataStage, SQL, PL/SQL, and Python scripting. Candidates must be proficient in data warehousing concepts and experienced with relational databases or Hive.
Autres compétences pertinentes
Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.
- IBM DataStage
- ETL
- SQL
- PL/SQL
- Python
- Unix Shell Scripting
- Data Warehousing
- Hive
- Oracle
- SQL Server
- DB2
- PostgreSQL
- Performance Tuning
- Root Cause Analysis
- Data Integration
Renseignements supplémentaires
- Expérience minimale
- 5+ ans
- Postuler avant le
- 23 août 2026