Junior Datawarehouse Consultant

Indra Group; Philippines; On-site; PHP 300,000 - 600,000; Full time

Job summary

Indra Group in the Philippines is seeking a Junior Datawarehouse Consultant to develop, optimize and maintain SQL, PL/SQL, PostgreSQL and shell scripts within our data integration workloads.

You will design ETL processes, work with data cubes, and collaborate with business users to translate requirements into practical technical solutions while ensuring data integrity. Strong SQL skills and experience with Hive, Talend and related tools are valued.

Qualifications

• Proficiency in SQL, PL/SQL, PostgreSQL, and shell scripting.
• Experience developing and maintaining ETL scripts.
• Working knowledge of Hive, Hue, and Talend.
• Experience using tools such as Toad, SQL Developer, MobaXterm, WinSCP, and PuTTY.
• Experience querying and analyzing data from SQL databases and data cubes.
• Strong proficiency in Microsoft Office, particularly Excel, Word, and PowerPoint.
• Ability to analyze business requirements and implement effective technical solutions.
• Experience with Oracle 11g database administration and maintenance is an advantage but not required.

Responsibilities

• Develop, maintain, and optimize SQL, PL/SQL, PostgreSQL, and shell scripts.
• Design, enhance, and support ETL processes and data integration workflows.
• Extract, transform, and analyze data from SQL databases and data cubes.
• Collaborate with business users and stakeholders to gather and analyze requirements.
• Translate business requirements into efficient technical solutions following best practices.
• Support database maintenance and ensure data integrity and accuracy.
• Prepare documentation and provide technical support when needed.
• Work closely with cross-functional teams to deliver high-quality solutions within project timelines.

Skills

SQL

PL/SQL

PostgreSQL

Shell scripting

ETL scripting

Data cubes

Hive

Hue

Talend

Toad

SQL Developer

MobaXterm

WinSCP

PuTTY

Microsoft Office

Tools

Hive

Hue

Talend

Toad

SQL Developer

MobaXterm

WinSCP

PuTTY

Job description

Select how often (in days) to receive an alert:

Junior Datawarehouse Consultant

Location: 00, PH

Profile: SW Development - Emerging Languages

Required experience:

Working mode:

Key Responsibilities

• Develop, maintain, and optimize SQL, PL/SQL, PostgreSQL, and shell scripts.
• Design, enhance, and support ETL processes and data integration workflows.
• Extract, transform, and analyze data from SQL databases and data cubes.
• Collaborate with business users and stakeholders to gather and analyze requirements.
• Translate business requirements into efficient technical solutions following best practices.
• Support database maintenance and ensure data integrity and accuracy.
• Prepare documentation and provide technical support when needed.
• Work closely with cross-functional teams to deliver high-quality solutions within project timelines.

Qualifications

• Proficiency in SQL, PL/SQL, PostgreSQL, and shell scripting.
• Experience developing and maintaining ETL scripts.
• Working knowledge of Hive, Hue, and Talend.
• Experience using tools such as Toad, SQL Developer, MobaXterm, WinSCP, and PuTTY.
• Experience querying and analyzing data from SQL databases and data cubes.
• Strong proficiency in Microsoft Office, particularly Excel, Word, and PowerPoint.
• Ability to analyze business requirements and implement effective technical solutions.
• Experience with Oracle 11g database administration and maintenance is an advantage but not required.

Preferred Skills

• Strong analytical and problem-solving skills.
• Excellent communication and presentation abilities.
• Team-oriented with a proactive and collaborative mindset.
• Ability to manage multiple priorities and work effectively in a fast-paced environment.
• Eagerness to learn new tools, technologies, and best practices.

If you're passionate about data, database development, and building efficient solutions, we'd love to hear from you.