ETL Testing - Python/Pyspark Professional

CGI

6 - 8 years

5 - 9 Lacs

bengaluru

Posted:1 day ago| Platform:

Apply

Skills Required

ms sql manager quality assurance data modeling cognos http scrum informatica selenium ssis python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Works independently under limited supervision and applies knowledge of subject matter in Applications Development.
Possess sufficient knowledge and skills to effectively deal with issues, challenges within field of specialization to develop simple applications solutions. Second level professional with direct impact on results and outcome.
ETL tester should work in agile env, and develop unit test scripts along with development team.
Understanding of enterprise data warehousing best practices and standards.
Experience leading QA Analysts on a project team.
Excellent verbal and written communications skills.
Highly motivated with strong organizational, analytical, and problem-solving skills.
Ability to effectively prioritize and execute tasks.

Required qualifications to be successful in this role:

Must-Have Skills:

SQL - Expert level of knowledge in core concepts of SQL and query.
Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and test automation frameworks.
Create and review complex test cases, test scripts, and test data for ETL processes.
ETL Automation - Experience in Datagap, Good to have experience in tools like Informatica, Talend and Ab initio.
Execute test cases, validate data transformat ions, and ensure data accuracy and consistency across source and target systems
Experience in query optimization, stored procedures/views and functions.
Strong familiarity of data warehouse projects and data modeling.
Understanding of BI concepts - OLAP vs OLTP and deploying the applications on cloud servers.
Preferably good understanding of Design, Development, and enhancement of SQL server DW using tools (SSIS,SSMS, PowerBI/Cognos/Informatica, etc.)
Develop and maintain ETL test automation frameworks to enhance testing efficiency and coverage.
Integrate automated tests into the CI/CD pipeline to ensure continuous validation of ETL processes.
Azure DevOps/JIRA - Hands on experience on any test management tools preferably ADO or JIRA.
Agile concepts - Good experience in understanding agile methodology (scrum, lean etc.)

More Jobs at CGI

Sap Abap Consultant

Bengaluru, Hyderabad

4 - 8 yrs

INR 12 - 19 Lacs

Junior position Software Engineer/Lead Java Fullstack

Hyderabad, Telangana, India

Experience: Not specified

Salary: Not disclosed

Lead Analyst - SAP ABAP

Hyderabad, Telangana, India

Experience: Not specified

Salary: Not disclosed

Power Bi Developer

Mumbai

5 - 8 yrs

INR 0 - 0 Lacs

Python Software Developer

Mumbai

5 - 8 yrs

INR 0 - 0 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.