ETL Testing, SQL with Python good to have
Share
Job Location:
Monthly Salary:
Posted on:
11 hours ago
Vacancies:
1 Vacancy
Job Summary
Position Description:
Experience: 3-9 Years
Title: ETL Testing Engineer
Shift: 1PM to 10PM
Main location: Bangalore/Chennai
Employment Type: Full Time
We are seeking an experienced ETL/SQL/Python Testing Engineer to design develop and execute test cases for data pipelines ETL processes and database systems. The ideal candidate will possess strong expertise in SQL querying ETL validation Python scripting and test automation to ensure data accuracy completeness and optimal performance.
Your future duties and responsibilities:
Develop and execute ETL test cases to validate data extraction transformation and loading processes.
Perform ETL pipeline testing in an ADB (Azure Databricks) 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 similar testing frameworks.
Conduct data reconciliation schema validation and comprehensive data quality checks.
Identify and report data anomalies performance issues and defects.
Collaborate closely with Data Engineers Analysts and Business Teams to understand data requirements.
Design and maintain test datasets for validation activities.
Implement CI/CD pipelines for automated ETL testing (e.g. Jenkins GitLab CI).
Document test results defects and detailed validation reports.
Required qualifications to be successful in this role:
ETL Testing: Strong hands-on experience with Informatica Talend SSIS Databricks or similar ETL tools.
SQL: Advanced SQL skills including joins aggregations subqueries and stored procedures.
Python: Proficiency in Python for automation including Pandas PySpark and PyTest.
Databases: Experience with RDBMS (Oracle SQL Server PostgreSQL) and NoSQL databases (MongoDB Cassandra).
Big Data (Good to Have): Experience with Hadoop Hive Spark Kafka.
Testing Tools: Familiarity with Selenium Airflow Great Expectations or similar frameworks.
Version Control: Git GitHub/GitLab.
CI/CD: Experience with Jenkins Azure DevOps or similar tools.
Skills:
- ETL
- SQLite
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.
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
About Company
The COMPANY is one of the few end-to-end consulting firms with the scale, reach, capabilities and commitment to meet clients’ enterprise digital transformation needs. Our 77,500 consultants and professionals work side-by-side with clients in 10 industries across more than 400 location ... View more
