Job Description
Remote Data Warehouse Developer needs 7 years of experience in data warehousing development, implementation, and support.
Remote Data Warehouse Developer requires:
• Strong SQL analysis skills and experience in database tuning and optimization.
• Experience in data modeling using Kimball methodology is preferred. A
• t least 3 years of experience in Oracle Data Integrator (ODI) 12c version. Excellent team player with strong communication skills.
• Ability to work in a fast-paced environment with minimal supervision.
•
• Reporting Tools
• Business Objects
• Tableau
• Oracle Data Integrator (1 year)
• Good to have experience with Python programming (1 year)
• Good Team Player
• Strong Communication skills
• Advanced experience with or knowledge of most of the following software, languages and tools, or similar products is preferred:
SQL Server DBMS, TSQL (ANSI), SSAS, SSIS, SSRS, SharePoint/PerformancePoint Services, SharePoint Designer, Visual Studio Business Intelligence Development Studio, Oracle DBMS, Oracle PL/SQL, MS Word, MS Excel, MS Access.
•
Remote Data Warehouse Developer duties:
• Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed: ...
• Participate in requirements gathering and analysis, technical design, testing, documentation and project planning:
• Design, develop, and maintain the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL. Work with stakeholders to gather and analyze requirements for data warehousing solutions.
• Develop ETL jobs using ODI to extract, transform, and load data from various sources into the data warehouse. Perform performance tuning of the data warehouse, ETL jobs, and SQL queries to ensure optimal performance and scalability.
• Develop and maintain data models using Kimball methodology for data warehousing design.
• Support data operations by monitoring, troubleshooting, and resolving data issues.
• Collaborate with the development team to integrate data warehouse solutions with other enterprise systems.