ETL Developer

Hunter's Hub Inc.

  • Makati, Philippines
    Unit 1902, Cityland 10 Tower 2, 154 H.V Dela Costa St. Corner Valero, Bel-air, Makati City, Makati, Metro Manila, Philippines
    Makati
    Metro Manila
    Philippines
  • Full time
Posted 5 days ago and deadline of application is on 30 May
Recruiter was hiring 4 hours ago

ETL Developer

Hunter's Hub Inc.

Job Description

The ETL (Extract, Transform, Load) Developer designs, develops and supports ETL processes and tools. The ETL Developer is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into the data warehouse or data lake. The ETL Developer is responsible for determining the data storage needs of the Department and ensure that the specific business needs are represented. The ETL Developer will have a deep and knowledge of data gathering, analysis, mapping, extraction, transformation and manipulation, cleansing, execution, and loading including experience in data validation by collaboration with clients and in-house Departments.

Key Job Functions and Duties:

  • Establish and enforce data warehousing standards to meet requirements and business needs.
  • Evaluate existing subject areas stored in the data warehouse and determines where data should be stored.
  • Review ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts.
  • Perform quality assurance testing of data integration and report development and monitor data load operations to ensure accuracy.
  • Analyze data and processes to create automated solution using ETL.
  • Develop ETL packages that will read data from different sources which will then be processed

Minimum Qualifications

General skills:

  • SQL Oracle development experience
  • Hands-on experience with NoSQL databases
  • Experience pulling data from a variety of data source types
  • Dimensional modeling experience
  • Experience interfacing with business users and understanding their requirements
  • Strong Project Management skills

Desired Experience & Qualities:

  • Five years’ ETL development, preferably for large, complex data sets.
  • Experience with MS SQL Server Integrations Services (SSIS), MS SQL Server Reporting Services, MS Visual Studio (BIDS) and MS SQL Server Management Studio (SSMS).
  • Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems.
  • Knowledge of logical and physical data modeling concepts (relational and dimensional).
  • Highly skilled in SQL development and capable of writing complex and efficient query and stored procedures. Qualifications and Accreditations:
  • Experience with Hadoop Components – HDFS, Spark, Hbase, Hive, Sqoop is highly desired.
  • Experience with OLAP, SSAS and MDX.

Reporting structure: The ETL developer reports to the Infrastructure Head.

Jobs Summary

Job level
Mid-Senior Level / Manager
Job category
IT and Software
Educational requirement
Bachelor's degree graduate
Office Address
Cityland 10 Tower 2, 154 H.V Dela Costa St. Corner Valero, Bel-air, Makati City
Industry
Staffing / Recruiting
Vacancy
10 openings
Website
http://huntershubinc.com/about_us.html

Feel secure when applying: look for the verified icon and always do your research on a company. Avoid and report situations when employers require payment or work without compensation as part of their application process.

About Hunter's Hub Inc.

Hunter’s Hub Incorporated is a Sourcing and Headhunting company that was founded earlier on in the year 2018. The company prides itself in its ability to source and recruit only the best and brightest of each industry. Hunter’s Hub caters to numerous clients in a multitude of industries, and has a wide-range of candidate selections to suit any of our clients’ needs. Likewise, the company specialises in sourcing out highly skilled and multi-talented IT professionals because the company mostly caters to clients being widely known to be in the IT industry. Hunter’s Hub sets itself apart from the rest of the company in the industry due to the various prominent selections of services that are custom-fit for our clients and the numerous kinds of professionals we are able to provide. Our services are highly based off of our clients’ needs and requirements, and we are able to dispense any kind of personnel that they need whether professional or non-professional. We look for only the best, and provide only the best.