Data Warehousing Specialist

2 weeks ago

London, Greater London, United Kingdom Pontoon Full time
About the Role

Pontoon is seeking a highly skilled Data Warehousing Specialist to join our client's team. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage.

Key Responsibilities
  • Translate business requirements into technical ETL designs
  • Create and review high-level solution designs
  • Develop, enhance, and maintain ETL code following best practices and standards
  • Perform technical walkthroughs of amended DataStage ETL solutions for peer reviews
  • Debug and problem-solve issues found during testing and/or production
  • Promote DataStage ETL code using Perforce and Urban Code deployment tools
  • Evaluate data for completeness and correctness, validate that ETL code is working as expected
  • Communicate status, issues, blockers to project manager and ETL team lead
  • Support continuous improvement of ETL interfaces by identifying and solving opportunities
  • Update and publish documentation, system diagrams, presentations, workflows, project plans, log issues, and unit testing logs
  • Attend project and ETL meetings
  • Perform knowledge transfer sessions to ETL Production support and Development team
  • Assist Production support team on the resolution of production incidents related to ETL processes when required
Accountabilities
  • Ensure all deliverables meet internal standards, industry best practices within the agreed timeframe
  • Ensure clear and transparent communication to all key stakeholders
  • Be responsible for the project deliverables related to assigned initiatives
  • Be responsible for IT-related risks, issues, and ensure appropriate escalation to appropriate management
  • Support strategic discussions and propose appropriate recommendations to IT management
  • Be responsible for troubleshooting, root cause analysis, data analysis related to BAU support requests
  • Ensure appropriate tracking and escalation of IT-related risks and issues observed
Requirements
  • IBM DataStage: Understanding of DataStage architecture and components. Familiarity with DataStage Designer, Director, and Administrator. Knowledge of DataStage jobs, stages, and data connections. Experience with parallel job design and development
  • Database Systems: Relational databases (e.g., IBM Db2, Oracle, SQL Server). SQL and PL/SQL programming
  • ETL development: Designing, developing, and deploying DataStage jobs. Creating complex ETL processes using DataStage and connectors. Performance tuning of DataStage jobs
  • Data Transformation and Cleansing: Applying data transformation rules. Implementing data quality and data cleansing routines
  • Data Integration: Integrating data from various sources (e.g., databases, flat files, XML). Handling structured and unstructured data
  • Problem Solving and Debugging: Identifying and resolving ETL job failures. Troubleshooting performance issues
  • Hands-on Experience with IBM DataStage: Several years of experience developing ETL solutions using IBM DataStage. Experience with different DataStage versions
  • Project Experience: Involvement in full project life cycles, from requirements gathering to deployment and maintenance. Working in Agile or Waterfall project environments
  • Database and SQL Experience: Writing complex SQL queries and stored procedures. Working with large datasets and optimising queries for performance

  • Data Warehousing Specialist

    5 days ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    Job DescriptionJob Title: Data Warehousing SpecialistJob Summary:We are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage. Your expertise in data transformation, data cleansing, and...

  • Data Warehousing Specialist

    5 days ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    Job DescriptionJob Title: Data Warehousing SpecialistJob Summary:We are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage. Your expertise in data transformation, data cleansing, and...

  • Data Warehousing Specialist

    1 week ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    Job DescriptionJob Title: Data Warehousing SpecialistJob Summary:We are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage. Your expertise in data transformation, data cleansing, and...

  • Data Warehousing Specialist

    1 week ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    Job DescriptionJob Title: Data Warehousing SpecialistJob Summary:We are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage. Your expertise in data transformation, data cleansing, and...

  • Data Warehousing Specialist

    21 hours ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    About the RoleWe are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a key member of our team, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage.Key ResponsibilitiesTranslate business requirements into technical ETL designsCreate and review high-level solution...

  • Data Warehousing Specialist

    19 hours ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    About the RoleWe are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a key member of our team, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage.Key ResponsibilitiesTranslate business requirements into technical ETL designsCreate and review high-level solution...

  • Data Warehousing Specialist

    1 week ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    Job DescriptionJob Title: Data Warehousing SpecialistJob Summary:We are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage. You will work closely with our team to translate business...

  • Data Warehousing Specialist

    2 weeks ago

    London, Greater London, United Kingdom Qualserv Consulting Full time

    Job DescriptionJob Title: Data Warehousing SpecialistJob Summary:We are seeking a highly skilled Data Warehousing Specialist to join our team at Qualserv Consulting. As a Data Warehousing Specialist, you will be responsible for designing, developing, and deploying ETL solutions using IBM DataStage. You will work closely with our team to translate business...

  • Data Warehousing Specialist

    2 weeks ago

    London, Greater London, United Kingdom Oliver Bernard Full time

    Job OverviewWe are seeking a highly skilled Senior Software Engineer to join our team at Oliver Bernard, a cutting-edge consultancy specializing in delivering innovative solutions to large enterprises.This is an exciting opportunity to work on a brand new project with a Tier 1 Investment Bank, where you will be responsible for building new data warehousing...

  • Cloud Data Warehousing Expert

    4 days ago

    London, Greater London, United Kingdom Databricks Full time

    {"title": "Product Specialist - Azure Lakehouse", "description": "Unlock the Power of Azure LakehouseAt Databricks, we're passionate about empowering data teams to tackle the world's most complex challenges. Our customers rely on the Databricks Data Intelligence Platform to drive their mission-critical data and AI applications, making better decisions...

  • Cloud Data Warehousing Expert

    4 days ago

    London, Greater London, United Kingdom Databricks Full time

    {"title": "Product Specialist - Azure Lakehouse", "description": "Unlock the Power of Azure LakehouseAt Databricks, we're passionate about empowering data teams to tackle the world's most complex challenges. Our customers rely on the Databricks Data Intelligence Platform to drive their mission-critical data and AI applications, making better decisions...

  • EMEA Product Specialist

    2 weeks ago

    London, Greater London, United Kingdom Databricks Inc. Full time

    About the RoleWe are seeking a highly skilled EMEA Product Specialist to join our team at Databricks Inc. as a Cloud Data Warehousing Expert. As a key member of our technical field team, you will be responsible for delivering thought leadership in Azure Lakehouse best practices for the Databricks Data Intelligence Platform.Key ResponsibilitiesThought...

  • EMEA Product Specialist

    1 week ago

    London, Greater London, United Kingdom Databricks Inc. Full time

    About the RoleWe are seeking a highly skilled EMEA Product Specialist to join our team at Databricks Inc. as a Cloud Data Warehousing Expert. As a key member of our technical field team, you will be responsible for delivering thought leadership in Azure Lakehouse best practices for the Databricks Data Intelligence Platform.Key ResponsibilitiesThought...

  • EMEA Product Specialist

    1 week ago

    London, Greater London, United Kingdom Databricks Inc. Full time

    About the RoleWe are seeking an experienced EMEA Product Specialist to join our team at Databricks Inc. as a Cloud Data Warehousing Expert. In this role, you will be responsible for delivering thought leadership in Azure Lakehouse best practices for the Databricks Data Intelligence Platform to the EMEA technical community and beyond.Key...

  • EMEA Product Specialist

    2 weeks ago

    London, Greater London, United Kingdom Databricks Inc. Full time

    About the RoleWe are seeking an experienced EMEA Product Specialist to join our team at Databricks Inc. as a Cloud Data Warehousing Expert. In this role, you will be responsible for delivering thought leadership in Azure Lakehouse best practices for the Databricks Data Intelligence Platform to the EMEA technical community and beyond.Key...

  • Cloud Data Warehousing Expert

    18 hours ago

    London, Greater London, United Kingdom Databricks Full time

    About the RoleWe are seeking a highly skilled and experienced professional to join our team as a Product Specialist - Azure Lakehouse. As a key member of our Field Engineering team, you will play a critical role in driving adoption of Azure Lakehouse features and ensuring a consistent product vision for the EMEA technical field.Key ResponsibilitiesDeliver...

  • Cloud Data Warehousing Expert

    20 hours ago

    London, Greater London, United Kingdom Databricks Full time

    About the RoleWe are seeking a highly skilled and experienced professional to join our team as a Product Specialist - Azure Lakehouse. As a key member of our Field Engineering team, you will play a critical role in driving adoption of Azure Lakehouse features and ensuring a consistent product vision for the EMEA technical field.Key ResponsibilitiesDeliver...

  • Data Transformation Specialist

    3 days ago

    London, Greater London, United Kingdom Data Idols Full time £90,000 - £110,000

    Staff Data EngineerJoin Data Idols, one of the UK's most renowned retail brands, as a Staff Data Engineer and play a pivotal role in shaping the company's data transformation journey. We're seeking an experienced professional to collaborate with our data teams and drive high standards across the data function.Key Responsibilities:Design and maintain data...

  • Data Transformation Specialist

    3 days ago

    London, Greater London, United Kingdom Data Idols Full time £90,000 - £110,000

    Staff Data EngineerJoin Data Idols, one of the UK's most renowned retail brands, as a Staff Data Engineer and play a pivotal role in shaping the company's data transformation journey. We're seeking an experienced professional to collaborate with our data teams and drive high standards across the data function.Key Responsibilities:Design and maintain data...

  • Data Engineering Lead

    3 days ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Data Idols is seeking a Senior Data Engineer to support the delivery of data transformation during an exciting time within the company. As a Senior Data Engineer, you will collaborate with the wider data teams to build and maintain data pipelines. Your extensive experience with data pipelines, data warehousing, and driving high standards across the data...