Datastage Developer - ETL / Data Warehousing

Key Responsibilities :

• Lead the design, development, testing, and deployment of complex ETL processes using IBM DataStage.
• Develop and optimize data pipelines for efficient data extraction, transformation, and loading from various sources into data warehouses.
• Utilize IBM InfoSphere suite of tools for data integration and data quality initiatives.
• Collaborate with business analysts, data architects, and other stakeholders to understand data requirements and translate them into technical specifications.
• Design and implement effective data models for data warehousing solutions.
• Work with Azure Data Factory for cloud-based data integration and orchestration where applicable.
• Perform data warehousing design, development, and maintenance activities.
• Write and optimize complex SQL queries for data manipulation and analysis.
• Develop and maintain scripts for automation and job scheduling in UNIX / Linux environments.
• Ensure data quality, integrity, and consistency across all ETL processes.
• Provide technical guidance and mentorship to junior developers.
• Participate in code reviews and ensure adherence to best practices and coding standards.
• Troubleshoot and resolve data-related issues and performance Skills & Qualifications :
• 8-11 years of hands-on experience as a DataStage Developer.
• Proven expertise in IBM DataStage for ETL development.
• Strong understanding and experience with ETL methodologies and best practices.
• Proficiency in IBM InfoSphere suite of tools.
• Extensive experience in designing and implementing data pipelines.
• Solid understanding of data modeling concepts and their application in data warehousing.
• Experience with Azure Data Factory is highly desirable.
• In-depth knowledge of data warehousing principles and architectures.
• Advanced SQL skills for data querying, manipulation, and optimization.
• Proficiency in UNIX / Linux command-line and scripting.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and as part of a collaborative team in a hybrid work :
• Immediate Joiners Preferred.

ref : hirist.tech)