ETL Developer
Questronix Corporation
- Makati, Philippines178 Yakal St. Brgy. San Antonio, Makati, Metro Manila, PhilippinesMakatiMetro ManilaPhilippinesPhilippines
- Full timeFULL_TIME
Job closed.
Job Description
An ETL Developer is responsible for:
- Being able to understand and develop ANSI SQL queries;
- Being aware of handling other semi-structured data formats – JSON, XMLs, HTMLs etc;
- Being comfortable in querying tools for distributed systems such as Hive, Impala and other SQL clients (RDBMS, Python, Scala etc.);
- Being comfortable in handling transforming data to suite business needs;
- Being able to handle tools for data transformation and/or ETL through tool-based and code-based development – ex. Informatica or Talend for tool based / Spark or MapReduce framework in Python or Scala/Java for code-based development;
- Having a background on data warehousing and reporting technologies
Minimum Qualifications
- Strong analytical and planning skills;
- Good communication and presentation skills;
- Excellent problem-solving skills;
- Experienced in end-to-end devOps techniques is a plus;
- Able to create Jenkins pipelines and create unit test cases for automated testing;
- Experience in Git version control is a plus;
- Experience in Docker containers and container technologies is a plus;
- Experienced in Flink Streaming framework;
- Experienced in using Cloud Technologies (AWS RedShift, S3 etc.);
- Must be comfortable in designing sustainable data architecture for Big data systems. That is balance partitioning with respect to target block sizes of the HDFS, compaction techniques, bucketing etc;
- Must understand concepts of Small Files in HDFS, Storage formats such as columnar format (Parquet and ORC) and Transmit formats (Avro);
- Must be able to understand resource allocation and proper resource sizing for distributed jobs. Ex. Spark executor and driver sizes;
- Strong SQL skills;
- Experienced in any of the following languages Python, Java, Scala;
- Experienced in Talend, Information, Ab Initio and other ETL GUI based tools;
- Comfortable in working with Hive partitioning and bucketing
Jobs Summary
- Job Level
- Entry Level / Junior, Apprentice
- Job Category
- IT and Software
- Educational Requirement
- Bachelor's degree graduate
- Recruiter response to application
- Sometimes
- Office Address
- 178 Yakal St. Brgy. San Antonio
About Questronix Corporation
Founded in 1987, Questronix Corporation has grown to be one of the largest IT solution provider and systems integrator in the Philippines. We offer best of breed solutions from IT infrastructure to business applications, built on world class technology companies and supported by our certified technical team with proven Filipino expertise and skills available in the country today.
In 1990, Questronix was appointed by IBM as its first business partner for IBM UNIX platform and the company evolved in providing end-to-end solutions that run on IBM technology. After a decade of investment, skills and commitment in working with IBM, Questronix was awarded the Premier Business Partner status, making our company the first Business Partner in the country to be elevated to this exclusive circle.
Our methodology on selecting our technology partners and implementation team for our services ecosystem allows us to deliver consulting-led systems integration focused on open standards, interoperability and proven best practices that result in higher project success rates.
Today, Questronix’s solutions suite include Data Center & IT infrastructure, IT Service Management, Security, Business Continuity, Hybrid Cloud Solutions, Mobility Solutions, Enterprise Resource Planning, Business Analytics, Enterprise Asset Management, Enterprise Content Management, Information and Data Management, Business Process Management and Industry Specific Solutions.
Approaching its 34th year in business, Questronix Corporation continuously strives to improve and evolve coupled by its enduring drive to deliver Filipino excellence and workmanship to its clients. As such, it has earned prestigious awards and recognitions – a proud testimony to its achievements that have firmly etched its name in the IT corporate landscape.