JC09122025-Datastage Developer

Amakshar; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading data solutions provider is seeking a skilled professional with over 5 years of experience in DataStage and Talend, focusing on ETL processes and BI/Data Warehousing solutions. The ideal candidate should be proficient in Oracle PL/SQL, Unix shell scripting, and cloud databases such as Snowflake. This role will involve analyzing project requirements, developing software, and executing test plans in an Agile environment, ensuring adherence to best practices in business intelligence.

Responsibilities

• Analyze requirements and develop software according to defined processes.
• Develop and peer review Low-Level Designs (LLD).
• Execute test plans and contribute to the software development lifecycle.

Skills

DataStage 9.x or above

Oracle PL/SQL

Unix shell scripting

Talend

Cloud databases (e.g., Snowflake)

DWH concepts

Performance Tuning and Query Optimization

Agile Environment

Job description

Experience - 5+ Years

Location - Bangalore/Chennai

Technical Skills:

• 5+ years of experience in DataStage 9.x or above.
• Should be conversant in using various stages, sequence Activities, dynamic loading of data from different file formats and Oracle and SQL Server
• Should be familiar with modifying stage properties for a given requirement.
• Good to have proficiency in using Oracle PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables,
• Should have hands‑on Unix shell scripting
• Strong experience in a BI/Data Warehouse environment with involvement in design, development, implementation, Unit Testing troubleshooting and support of ETL process using Talend (Necessary) and DataStage (Preferable)
• Experience in defining DataStage ETL development standard and best practices
• Experience in cloud database e.g. snowflake
• Experience in developing Data Marts, Data warehousing and Operational Data Store (ODS) on any of the databases or Hadoop environments
• Should be having good experience with DWH concepts, and other DWH related terms
• Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and De‑normalization
• Should be well versed with migration strategies by manual and automated processes
• Should have experience in supporting the environment team for all the migrations, and other activities
• Extensive knowledge of business intelligence best practices, processes, and methodologies.
• Good to have programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using SQL or T‑SQL
• Excellent interpersonal, communication skills (both verbal and written), and ability to interact with and effectively address concerns
• Excellent prioritization, time management, analytical, and organization skills - able to determine
• Experience working in an Agile Environment, preferred

Process Skills:

• Capable of analyzing requirements and develop software as per project defined software process
• Develop and peer review of LLD (Initiate/ participate in peer reviews)
• Work on the agile improvements by sharing experiences and knowledge with the team.
• Ability to execute test plans, create test cases test data and contribute to appropriate software (including programming languages) development life cycle methodology and application of specialized business and technical knowledge.