Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Data Stage Developer @ Capgemini

Home > Software Development

 Data Stage Developer

Job Description

Key Responsibilities:

  • ETL Design & Development: Create, test, and deploy complex Parallel and Sequencer jobs using DataStage (v11.x preferred).
  • Database Optimization: Write and optimize advanced SQL/PL-SQL queries to extract and load data efficiently across various RDBMS platforms like Oracle, DB2, or SQL Server.
  • Automation: Develop and maintain UNIX Shell Scripts to automate data processing, file manipulation, and job scheduling.
  • Performance Tuning: Identify bottlenecks in the ETL pipeline and implement tuning strategies to improve data throughput.
  • Troubleshooting: Provide root cause analysis (RCA) for job failures in production and ensure data integrity through robust error-handling.
  • Collaboration: Partner with data architects and business analysts to translate functional requirements into technical specifications.

Requirements:

  • Experience: Minimum 4 years of hands-on experience in ETL development using IBM DataStage.
  • SQL Mastery: Strong expertise in writing complex queries, stored procedures, and triggers.
  • UNIX Skills: Proficiency in UNIX/Linux environments and shell scripting (Bash/Korn).
  • Data Warehousing: Deep understanding of DW concepts (Star/Snowflake schema, SCD Type 1/2).
  • Tools: Experience with scheduling tools like Control-M or Autosys is a major plus.
  • Education: Bachelors degree in Computer Science, Information Technology, or a related field.

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: Software Development
Role: Software Development - Other
Employement Type: Full time

Contact Details:

Company: Capgemini
Location(s): Pune

+ View Contactajax loader


Keyskills:   Unix Datastage Ibm Datastage SDLC Life Cycle SQL

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Data Stage Developer

  • Capgemini
  • 4 - 9 years
  • Noida, Gurugram
  • 2 mths ago
₹ Not Disclosed

Capgemini

Capgemini Engg (erstwhile Altran) ranks as the undisputed global leader in Engineering and R&D services (ER&D). The company offers clients an unmatched value proposition to address their transformation and innovation needs. Works alongside its clients, from initial concept through indust...

Job Listings