database developer

database developer Leicester, England

TESTQ Technologies
Full Time Leicester, England 40000 - 29000 GBP ANNUAL Today
Job description

  • Job Type: Permanent
  • Vacancy: 1
  • Location: Leicester, United Kingdom

Job Discription:

Reference: TQ2223_2136_271

Vacancy: 3

Job title: ETL Developer

Location: Leicester


Job Purpose:

TESTQ Technologies is an IT services and solutions company whose offerings spans over variety of industry sectors with strong technical, domain and process expertise helping clients grow their businesses and decrease operational costs on continuous basis in an ever-changing business environment.

This opportunity is in the solution design and development arena for ETL Developer who will play a major role in the technical design and development of the company’s technical offerings. The role is based at our Leicester office with occasional assignments at client locations.


Job Description (Main Duties and Responsibilities):


  • Ascertain the organization’s data storage requirements and understand your data sources
  • Come up with the best strategy for best data extraction, suited to your organization
  • Handle data modeling, data warehouse architecture, data pipeline management, and ETL testing
  • Implement database structure, data marts, data stores, and data lakes
  • Ensure high-end security and good quality of data
  • Come up with robust data flow models for the applications
  • Transforms data requirements into functional mapping designs
  • Safeguard proper functioning of data once the transfer is done
  • Seamless collaboration with data management teams on giving required data
  • Testing the warehouse infrastructure/storage system prior to data extraction
  • Offer regular maintenance support
  • Administering ETL tools, app integration, performance tuning
  • Working on technical/functional documentation
  • Monitor pre-decided ETL jobs and ensure resolution of discrepancies.


Key Skills, Qualifications and Experience Needed [The candidate must demonstrate these in all stages of assessment]


  • Proficiency in at least one ETL tool like Informatica, SSIS, Talend, Pentaho, etc.
  • Experience in PL/SQL and Oracle development
  • Coverage of dimensional modeling techniques
  • Expertise in scripting languages (Python, Bash, Perl, etc.)
  • Proficiency in programming languages (JavaScript, Java, C++, etc.)
  • Specialization in database engineering skills – SQL, NoSQL, Hadoop, etc.
  • Exposure to warehousing architecture processes – MOLAP, ROLAP, EDW, etc.
  • Known to Hadoop components – Hive, Sqoop, Spark, Hbase, HDFS
  • Sufficient knowledge about OLAP, SSAS, SSIS, and MDX
  • Good understanding of modeling tools – Toad Data Modeler, Erwin, etc.
  • Parameterization of ETL jobs for better time management


Other Key skills:


  • Good analytical and Problem-solving skills
  • Good communication skills
  • A thorough approach and Self starter
  • Focus on quality and delivery
  • Working together in teams.
  • Leadership and effective decision making.
  • Flexible Attitude
  • Excellent customer service


Qualifications:
Bachelor's degree or above in the UK or Equivalent.

Salary: GBP 29000 to 40000 per annum

Published Date: 17 Jul 2023

Closing Date: 16 Aug 2023

Evaluation: CV Review, Technical Test, Personal and Technical Interview and References

Job Type: Full-time, Permanent [Part time and Fixed Term option is available] *

database developer
TESTQ Technologies

www.testqtech.com
Leicester, United Kingdom
Unknown / Non-Applicable
1 to 50 Employees
Private Practice / Firm
Related Jobs

All Related Listed jobs

Deputy Soft Service Manager
ABM London, England 14.31 GBP HOURLY Today

Carry out and manage daily centre audits to ensure high standards of cleanliness and a safe environment is always evident throughout the centre.

Evening Cleaner
Sodexo Newcastle upon Tyne, England 10.42 GBP HOURLY Today

A death in Service benefit for colleagues who pass away whilst employed by Sodexo. Access to a free health and wellbeing app that provides rewards for

Part Time Picker
Euro Car Parts Avonmouth, England 10.57 - 10.93 GBP HOURLY Today

Part Time Picker - Avonmouth, BS11 8DT 20 hours per week - Monday to Friday 1pm to 5pm Do you want to work for a business that is a market leader? Do you

Sandwich Maker
Subway Derby, England 5.28 - 10.42 GBP HOURLY Today

An ideal candidate will have a background in food service, be capable of preparing and assembling sandwiches quickly and accurately in a clean, sanitary

cad engineer
Tech Matrix Software Solutions Newark, CA 90 - 80 USD HOURLY Today

RequirementsQualifications • 2 plus years of experience designing interior trim and components • Creativity within complex 3D virtual...