Job Title: Senior QA Engineer II – SSIS
Job ID: JR101882
Location: Bangalore, Karnataka, India
Experience: 6+ Years
Job Type: Full-Time
As a Senior QA Engineer II – SSIS, you will play a critical role in ensuring high-quality data pipelines and integrations within o9’s AI-powered planning platform.
You will lead the testing efforts for ETL workflows using SSIS, Hadoop, and other technologies in a fast-paced, agile product environment.
Design comprehensive test cases covering all basic, alternate, and exception scenarios based on business requirements and user stories.
Identify testing gaps and enhance test coverage across the data lifecycle.
Perform DWH and ETL testing using tools such as SSIS, Hadoop, or equivalent.
Set up SSIS batches in QA environments and automate functional/regression test runs using Jenkins.
Modify complex ETL jobs to replicate real-time scenarios in test environments.
Execute backend data validations and automate repetitive data testing processes.
Collaborate with cross-functional teams across multiple projects and releases.
6+ years of hands-on experience in ETL Testing, with expertise in SSIS and Hadoop workflows.
Strong SQL skills with hands-on experience in SQL, Hive, and NoSQL databases.
Proficient in scripting languages such as UNIX, Shell, PowerShell, Bash, or Python.
Familiarity with DevOps automation using Jenkins.
Experience in functional, integration, system, and regression testing types.
Knowledge of software configuration management tools like Git or TFS.
Expertise in writing and executing test strategies, test plans, and test cases.
Hands-on experience in executing manual test cases and validating ETL jobs through scripting.
Experience working in the Supply Chain Management (SCM) domain is preferred.
Bachelor’s degree (B.E.) in Computer Science, Software Engineering, or a related field.
Strong team player with excellent communication and collaboration skills.
Ability to manage multiple priorities in a dynamic environment.
Proactive and solution-oriented mindset.
Eagerness to contribute to the product quality and success of enterprise platforms.
Competitive salary and performance-based recognition.
Flexible work policy – work from home options available.
Flat organizational structure with a strong entrepreneurial culture.
Engaging team events and Friday socials – remote or in-person.
Inclusive and diverse work environment.
Mentorship and continuous learning opportunities.
Application Submission
Initial Screening – Video or phone call with hiring team
Technical Interviews – 2 to 3 rounds (1–1.5 hours each)
Written Assignment – Scenario-based problem solving
Managerial & HR Interviews – Culture fit and final evaluation
Offer & Onboarding – Welcome to o9!
