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

Elite Contract Support Officer
Ward Security Luton, East of England, England 11.5 GBP HOURLY Today

To provide a point of contact and information centre to staff and visitors. Deal with conflict in an appropriate manner if required. Pay rate:* 11.50 per hour.

Hotel Housekeeper - Staff Accommodation Available
Novotel London Stansted Airport Stansted, South East England, England 21840 GBP ANNUAL Today

Provide exceptional customer service, responding to guest requests and enquiries with a friendly and helpful manner. Employee social events throughout the year.

Tesco Colleague - Northampton R/I Express
Tesco Northampton, England 11.02 GBP HOURLY Today

Making decisions that are right for customers, delivering routines in store that meet the needs of customers at the right time. Days From time To time.

Part Time Domestic Assistant
Elton Hall Care Home Stockton-on-Tees, England 10.5 GBP HOURLY Today

Audit and report findings of quality if linen, towels etc at a minimum of every 3 months. Any clothing repairs to be undertaken or reported to Key worker or

Health Care Assistant (Nights)
Lilian Faithfull Care Stroud, England 10.42 - 10.8 GBP HOURLY Today

Free Life Insurance x 2 of annual salary. Wagestream* (ready access to hours earned, drawdown 50% of your earned pay before payday) *All breaks are paid, plus