Skip to main content
Full-Time
On-Site

Sr. ETL Automation with strong SQL, Python good to have

View on Map

Description

CGI is seeking an experienced ETL/SQL/Python Testing Engineer to design, develop, and execute comprehensive test cases for data pipelines, ETL processes, and database systems. The role requires strong expertise in SQL querying, ETL validation, Python scripting, and test automation to ensure data accuracy, completeness, and optimal performance.

What We're Looking For

Develop and execute ETL test cases to validate data extraction, transformation, and loading processes.,Experience in ETL pipeline testing in an ADB environment.,Write complex SQL queries to verify data integrity, consistency, and correctness across source and target systems.,Automate ETL testing workflows using Python, PyTest, or other testing frameworks.,Perform data reconciliation, schema validation, and data quality checks.,Identify and report data anomalies, performance bottlenecks, and defects.,Work closely with Data Engineers, Analysts, and Business Teams to understand data requirements.,Design and maintain test data sets for validation.,Implement CI/CD pipelines for automated ETL testing (Jenkins, GitLab CI, etc.).,Document test results, defects, and validation reports.

Ideal Candidate

Experience with cloud platforms (AWS, Azure).,Knowledge of Data Warehousing concepts (Star Schema, Snowflake Schema).,Certification in ETL Testing, SQL, or Python is a plus.

Hard Skills

ETL Testing (Informatica, Talend, SSIS, Databricks)
SQL (Advanced)
Python (Pandas, PySpark, PyTest)
Databases (RDBMS: Oracle, SQL Server, PostgreSQL, SQLite)
NoSQL (MongoDB, Cassandra)
Big Data Testing (Hadoop, Hive, Spark, Kafka - Good to Have)
Testing Tools (Selenium, Airflow, Great Expectations)
Version Control (Git, GitHub/GitLab)
CI/CD (Jenkins, Azure DevOps)
SCRUM

Soft Skills

Strong analytical skills
Problem-solving skills
Ability to work in Agile/Scrum environments
Good communication skills

Benefits

Competitive compensation package
Opportunities for growth and professional development
Benefits for full-time, permanent members start on the first day of employment
Paid time-off program
Profit participation plan
Stock purchase plans

About the Company

C

CGI Inc.

CGI Inc. is one of the world's largest IT and business consulting firms, providing a comprehensive range of services including strategic consulting, systems integration, managed IT, and business process services. Founded in 1976 and headquartered in Montreal, the company operates across more than 40 countries, helping clients across various industries accelerate their digital transformation and achieve measurable business outcomes.

Ownership-driven
Collaborative
Ethical
Global
Client-centric
View all jobs at CGI Inc.

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.