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] *