SonicJobs Logo
Left arrow iconBack to search
  1. Home
  2. London
  3. Data warehouse designer
  4. DataStage Data Warehousing Specialist

DataStage Data Warehousing Specialist

Qualserv Consulting
Posted 8 days ago, valid for 10 days
Location

London, Greater London EC2V 7WS, England

Salary

£40,000 - £48,000 per annum

info
Contract type

Full Time

In order to submit this application, a Reed account will be created for you. As such, in addition to applying for this job, you will be signed up to all Reed’s services as part of the process. By submitting this application, you agree to Reed’s Terms and Conditions and acknowledge that your personal data will be transferred to Reed and processed by them in accordance with their Privacy Policy.

Sonic Summary

info
  • The job is for a Data Warehousing Specialist at a leading investment banking organization, located in London with a hybrid work model.
  • The role involves translating requirements into technical ETL designs, developing ETL code, and performing testing and debugging.
  • Candidates should have several years of hands-on experience with IBM DataStage and strong knowledge of relational databases and SQL.
  • The position offers a salary of £280 per day via umbrella, categorized as inside IR35, and is expected to last until March 31, 2025, with a possibility for extension.
  • Applicants must demonstrate experience in full project life cycles and possess problem-solving skills related to ETL processes.
DataStage Data Warehousing Specialist

Duration: Up until 31 March 2025 (Possibility for extension)

Location: London/Hybrid (2 - 3 days per week on site)

£280 PD VIA UMBRELLA, Inside IR35

Role Profile

Our client, a leading investment banking organisation, is seeking a Data Warehousing Specialist to join their team. As a Data Warehousing Specialist, you will be responsible for translating requirements and data mapping documents into technical ETL designs, creating and reviewing high-level solution designs, and developing, enhancing, and maintaining ETL code following best practises and standards.

Purpose of Job:

  • Translate requirements and data mapping documents to a technical ETL design.

  • Create and review high-level design of solution.

  • Perform technical walkthroughs of amended DataStageETL solutions for peer reviews.

  • Develop, enhance, and maintain ETL code following best practises and standards.

  • Create and execute unit testing plans. Support Regression and System test efforts.

  • Debug and problem solve issues found during testing and/or production.

  • Promote DataStageETL 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 practise 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.

Skills and Experience:

  • 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.

Due to high demand we are only able to respond to applications that meet the required criteria

Apply now in a few quick clicks

In order to submit this application, a Reed account will be created for you. As such, in addition to applying for this job, you will be signed up to all Reed’s services as part of the process. By submitting this application, you agree to Reed’s Terms and Conditions and acknowledge that your personal data will be transferred to Reed and processed by them in accordance with their Privacy Policy.

Logo
SonicJobs
Your next career move. Sorted.
Search jobsbackground image

Contact us

© 2017 - 2024 SonicJobs App Ltd. All rights reserved

Terms & Conditions | Privacy Policy | AI Agent | Browse Jobs