Senior AI/Big data/ DW Engineer

5 - 9 years

0 Lacs

Posted:5 days ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

As a Senior Data Warehouse Developer at our company, you will play a crucial role in designing, developing, and optimizing enterprise data warehouse solutions. Your expertise in data modeling, ETL, semantic layer development, and SQL performance tuning will be essential in building scalable, secure, and high-performing data platforms. Collaboration with both business and technology teams is key to your success in this role. Key Responsibilities: - Lead the design and development of logical and physical data models for the enterprise data warehouse and analytics platforms. - Define and enforce standards for dimensional modeling, normalization, star schemas, and snowflake schemas. - Ensure that data models support business intelligence, reporting, and advanced analytics use cases. - Establish and promote best practices, standards, and methodologies related to data modeling and warehouse. - Support data governance initiatives to ensure consistency, accuracy, and compliance across the enterprise. - Architect scalable data warehouse solutions, whether cloud-based, hybrid, or otherwise. - Collaborate with ETL/ELT developers to ensure alignment between models and pipelines. Core Qualifications: - Strong experience in data architecture, data modeling, and data warehouse design. - Proficiency in logical and physical data modeling using tools such as ERwin, PowerDesigner, or equivalent. - Deep knowledge of relational databases and SQL performance optimization. - Familiarity with data integration, ETL/ELT data pipeline, and dimensional modeling methodologies. - Expertise with BI/reporting platforms like OAC, Tableau, Power BI. Preferred Experience: - Knowledge of data lake-house architectures and big data ecosystems like Databricks, Spark, and Hadoop. - Hands-on experience with cloud data warehouses such as Snowflake, Redshift, BigQuery, Azure Synapse, etc. - Experience with metadata management and data catalog tools. - Exposure to master data management (MDM) and data governance practices. About Us: Oracle is a global leader in cloud solutions, utilizing cutting-edge technology to address current challenges. With over 40 years of experience, we continue to excel by upholding integrity and partnering with industry leaders across various sectors. We value innovation through an inclusive workforce and offer competitive benefits, flexible medical, life insurance, retirement options, and volunteer programs to support our employees. We are dedicated to creating opportunities for all individuals, including those with disabilities, throughout the employment process. If you require accessibility assistance or accommodation for a disability at any point, please reach out to us at accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Oracle logo
Oracle

Information Technology

Redwood City

RecommendedJobs for You