Senior ETL Tester

Position Description:

We are seeking an experienced ETL Tester to join our Quality Assurance this role you will be responsible for validating data transformations and ensuring the accuracy integrity and reliability of data as it moves from source to target systems. You will design develop and execute comprehensive test plans and test cases to verify the functionality and performance of our ETL processes and data warehouse implementations.
Company profile:
Founded in 1976 CGI is among the largest independent IT and business consulting services firms in the world. With 94000 consultants and professionals across the globe CGI delivers an end-to-end portfolio of capabilities from strategic IT and business consulting to systems integration managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at .

Position: ETL Tester / QA Analyst - Data & Integrations
Experience: 4 to 7 Years
Category: Software Development/ Engineering
Shift: 1 PM to 10 PM
Main location: India Hyderbad
Position ID: J0426-0932
Employment Type: Full Time
#LI-SP40

Education Qualification: Bachelors degree in computer science or related field or higher with minimum 3 years of relevant experience.

Your future duties and responsibilities:

*Analyze business requirements and technical specifications to create detailed and well-structured test strategies test plans and test cases.
*Write complex SQL queries to perform rigorous data validation across different databases and systems ensuring data quality and accuracy.
*Execute manual and automated tests for ETL jobs data transformations and data loading processes to identify defects and inconsistencies.
*Identify document and track defects from discovery through to resolution using defect tracking tools like JIRA. Work closely with the development team to ensure defects are resolved in a timely manner.
*Perform end-to-end testing of data workflows from source data extraction to final report generation to ensure the entire data pipeline meets requirements.
*Create and maintain clear and concise testing artifacts including test evidence summary reports and final signoffs.

Required qualifications to be successful in this role:

Experience: 4 5 years of proven experience as an ETL Tester or Data Quality Analyst.
SQL Proficiency: Expert-level ability to write complex SQL queries (including joins subqueries and aggregate functions) for data validation.
ETL & Data Warehousing: Strong understanding of ETL concepts and data warehousing principles (e.g. Star Schema Snowflake Schema Dimensions Facts).
Testing Methodology: Solid knowledge of software QA methodologies tools and processes.
ETL Tools: Hands-on experience testing with one or more major ETL tools (e.g. Informatica PowerCenter Talend IBM DataStage Microsoft SSIS).
Problem-Solving: Excellent analytical and problem-solving skills with a keen eye for detail.

Good-to-Have Skills:
Domain Knowledge: Experience in the Banking or Financial Services domain is a significant plus.
Cloud Platforms: Familiarity with cloud-based data platforms such as Azure Data Factory AWS Glue or Google Cloud Dataflow.
Big Data Technologies: Exposure to testing Big Data technologies like Hadoop Spark or Hive.
Test Automation: Experience with scripting languages (e.g. Python Shell) for automating data validation processes.
Reporting Tools: Experience validating data in BI and reporting tools like Power BI Tableau or Qlik.

Skills:

• ETL
• Informatica
• SQL
• Test Case / Script Development

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.