Key Skills

Job Description

Role- Senior ETL DataStage Specialist (Oracle Exadata) Location - Amsterdam, Netherlands experience - 8+ Years Job Description: We are seeking a highly experienced Senior ETL DataStage Specialist with deep expertise in IBM InfoSphere DataStage, Oracle Exadata, and enterprise data warehousing environments. The ideal candidate combines strong technical knowledge with an automation-first mindset, ensuring scalable, reliable, and efficient data integration solutions. This role requires end-to-end ownership of data ingestion, transformation, and delivery processes while contributing to data architecture, data modeling, performance optimization, and continuous improvement initiatives. The successful candidate will work closely with Data Architects, Business Analysts, Data Engineers, and Platform teams to deliver high-quality data solutions supporting critical business processes. Key Responsibilities ETL Development & Engineering Design, develop, enhance, and maintain complex ETL processes using IBM InfoSphere DataStage. Build scalable and reusable ETL frameworks, components, and standards. Develop and optimize batch and near real-time data integration solutions. Ensure data quality, reconciliation, and validation mechanisms are embedded within ETL pipelines. Troubleshoot and resolve ETL failures, performance bottlenecks, and production incidents. Oracle Exadata & Database Engineering Design and optimize ETL workloads for Oracle Exadata environments. Leverage Exadata capabilities for high-performance data processing and query execution. Optimize SQL, PL/SQL, partitioning strategies, indexing, and parallel execution plans. Collaborate with DBAs to improve system performance, capacity utilization, and reliability. Data Modeling & Data Warehousing Contribute to enterprise data warehouse and data mart design. Translate business requirements into logical and physical data models. Apply dimensional modeling techniques including: Star Schemas Snowflake Schemas Fact and Dimension Design Slowly Changing Dimensions (SCD) Support data lineage, metadata management, and data governance initiatives. Automation & DevOps Champion an automation-first culture across the data engineering landscape. Develop automated deployment, testing, monitoring, and operational processes. Implement CI/CD pipelines for ETL development and releases. Automate recurring operational tasks and controls. Introduce Infrastructure as Code and configuration management practices where applicable. Drive improvements in observability, monitoring, alerting, and self-healing capabilities. Architecture & Technical Leadership Provide technical leadership and mentoring to Data Engineers and ETL developers. Define best practices, design standards, coding guidelines, and review processes. Participate in solution architecture discussions and strategic platform initiatives. Support cloud migration and modernization programs where applicable. Act as a subject matter expert for DataStage, ETL architecture, and Oracle-based data platforms. Required Skills & Experience Technical Expertise 8+ years of experience in Data Warehouse and ETL development. Strong hands-on experience with: IBM InfoSphere DataStage Oracle Database Oracle Exadata SQL and PL/SQL Extensive experience designing and optimizing large-scale ETL solutions. Strong understanding of enterprise data warehousing principles. Proven experience with logical and physical data modeling. Experience implementing data quality controls and reconciliation processes. Knowledge of metadata, data lineage, and governance concepts. Automation & Engineering Practices Experience with DevOps principles and CI/CD processes. Strong scripting capabilities (Shell, Python, PowerShell, or equivalent). Experience with source control systems such as Git. Familiarity with automated testing frameworks and deployment pipelines. Mindset focused on standardization, simplification, and operational excellence. Performance & Scalability Strong SQL tuning and ETL performance optimization expertise. Experience handling large data volumes and high-performance processing environments. Understanding of workload management, partitioning, and parallel processing concepts. Preferred Qualifications Experience with modern data platforms and cloud technologies (Azure, AWS, or GCP). Knowledge of Data Vault, Kimball, and Inmon methodologies. Experience with scheduling/orchestration tools such as Airflow, UAC. Familiarity with data governance and regulatory requirements. Understanding of Agile, Scrum, and SAFe delivery frameworks. IBM DataStage certification and/or Oracle certification. For more information on how we process your personal data, please refer to HCLTech’s Candidate Data Privacy Notice.

Core Responsibilities

Design, develop, and optimize scalable DataStage ETL pipelines and Oracle Exadata workloads, ensuring data quality, performance, and reliable delivery. Provide technical leadership, contribute to data architecture and modeling, and advance automation, CI/CD, monitoring, and operational practices.

Requirements

Requires 8+ years of data warehousing and ETL development experience, with strong hands-on expertise in IBM InfoSphere DataStage, Oracle Database and Exadata, SQL, and PL/SQL. Candidates should also have experience with data modeling, large-scale ETL performance optimization, data quality controls, DevOps and CI/CD, scripting, and source control.