Job Title: Senior DataStage Engineer (B2) Experience: 5–8 years
Project Type – L3 Support
Shift working – Yes rotational
Interview- 3 rounds, one round Face-to-face at office
Job Details: As a Senior DataStage/Netezza Engineer, you will contribute to the design, development, and maintenance of enterprise data warehouse solutions. You will ensure high performance, data integrity, and availability of mission-critical systems that support business operations across the bank.
Key Responsibilities:
Develop and maintain DataStage/Netezza-based data warehouse objects (tables, views, stored procedures, scripts).
Design, build, and optimize DataStage ETL jobs and DB2 SQL queries for complex data transformations.
Perform database administration tasks including schema design, access control, and system monitoring.
Support database backup, recovery, and migration activities.
Ensure compliance with security and data governance guidelines for sensitive information.
Partner with IT and business teams to deliver accurate and timely data solutions.
Analyze logs, troubleshoot performance issues, and recommend enhancements.
Document processes, workflows, and technical solutions.
Requirements:
Bachelor’s degree in Computer Science, Engineering, or related discipline.
5–8 years of strong experience in Netezza, DataStage, DB2, and SQL.
Proficient in database performance monitoring and optimization.
Working knowledge of Linux/Unix environments and shell scripting.
Solid problem-solving, debugging, and collaboration skills.
Nice to Have:
Familiarity with cloud technologies (Azure, AWS, Snowflake).
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
