Total-TECH Co.
” The Job Description”
1. Design, develop, and maintain robust data pipelines using ETL tools such as Informatica or Oracle Data Integrator (ODI).
2. Perform data profiling, cleansing, and preparation to ensure high-quality data.
3. Design and implement data models to support reporting and analytics.
4. Develop and manage relational databases including schema design and optimization.
5. Write and optimize complex SQL queries for data extraction and analysis.
6. Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
7. Create interactive and insightful data visualizations and dashboards using OBIEE.
8. Ensure data integrity, quality, and security across systems and reports.
Requirements:
- Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
- Strong hands-on experience in RDBMS and writing complex SQL queries.
- Proficiency in data profiling, preparation, and cleansing techniques.
- Experience with data modeling (conceptual, logical, and physical models).
- Practical experience with ETL tools like Oracle Data Integrator (ODI) or Informatica.
- Strong understanding of database design and development.
- Experience using data visualization tools, specifically Oracle Business Intelligence Enterprise Edition (OBIEE).
- Excellent analytical and problem-solving skills.