Apply For This Job


Job Description

Responsibilities include:

•             Design, develop, and document data warehouse databases.

•             Integration using XML and JSON file by using ODI

•             Independently design, develop and document dashboards, reports and analytical tools.

•             Gather and analyse business requirements and user specifications for new or modified functionality.

•             Independently design, code, test, debug and document ETL modules and processes.

•             Provide technical assistance to users and monitor performance of BI systems.

•             Create/maintain documentation to describe module logic and development processes.

•             Assume additional responsibilities as requested.

Required Experience:

•             Bachelor’s degree in Computer Science, Math or similar major

•             3-5 years developing Oracle Business Intelligence Systems (OBIEE and ODI)

•             Knowledge of data visualization tools (Oracle Data Visualizer)

•             Experience in the financial services or insurance industry is preferred

•             Familiarity with data warehouse design, dimensional modelling and implementation

•             Fluency with concepts like cubes, star schema, fact, dimension

•             Proficiency with reports, dashboards and other analytical tool design/creation/maintenance

•             Experience with ETL design, development and processing

•             Strong analytical skills

•             Excellent verbal and written communication skills

•             Strong interpersonal skills

•             Proficient with SQL

•             Debugging and trouble-shooting expertise

•             Good time management abilities

•             Experience designing conceptual, logical, and physical data models.

Operating Systems:

  • Microsoft Windows

  • Solaris or equivalent UNIX operating system


  • HTML, Java Scripts

  • UNIX shell scripting

  • Oracle PL/SQL


  • MS SQL Server (2005/2012)

  • Oracle Business Intelligence (OBIEE)

  • Oracle Data Integrator (ODI)

  • Oracle BI Publisher

  • Oracle Smart View

  • Oracle SQL

  • Toad

  • Microsoft Office Suite

  • Weblogic Server

  • Oracle Data Visualization Desktop

Job Details

Functional Area:
Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
No Preference
Minimum Education:
Career Level:
Experienced Professional
Minimum Experience:
3 Years
Apply Before:
May 17, 2021
Posting Date:
Apr 17, 2021
Show fewer details Read full job description

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

TreeHouse ExaTex Private Limited

Information Technology · 51-100 employees - Karachi, Islamabad, Hyderabad, Lahore

TreeHouse Consultancy is an information technology solutions company that provides high-end IT solutions for individual needs of its customers, both in the public as well as the private sector. The individuals behind TreeHouse Consultancy consist of a team of professionals well-versed in the field o ...Read More

Similar Job Titles

Database ETL Developer

NASRR General Trading, Karachi, Pakistan
Posted May 10, 2021

Business Intelligence Analyst (ETL)

Quantsys Corp, Multiple Cities, Pakistan
Posted May 10, 2021

Senior BI / ETL Developer

Shispare Pvt. Limited, Karachi, Pakistan
Posted Apr 16, 2021

Data Analyst

Posted Apr 28, 2021
View All