41 Materialized Views Jobs - Page 2

USEReady helps businesses to be self-reliant on data. Growing over 3000% since inception, USEReady achieved #113 rank in Inc 500 2015 and honoured top 100 companies in North America 2015 by Red Herring. USEReady is built on strong entrepreneurial spirit with unprecedented opportunities for career growth. At USEReady, we believe in achieving career growth while improving our individual competencies. If you desire to be part of a team that believes in mutual success and inspiration, you are welcome to apply. USEReady is a data and analytics firm that provides the strategies, tools, capability, and capacity that businesses need to turn their data into a competitive advantage. USEReady partners ...

If you are seeking an opportunity in Technology Solutions and Development, Emerson has an exciting role for you! As a Senior ETL Developer - Oracle, you will be a part of a team responsible for developing ETL programs and enhancing the performance of applications code in Oracle Data Integrator tool. Your duties will involve working on existing code and developing new code to meet production standards. This role contributes to delivering technology solutions for strategic business needs, promoting service adoption, supporting processes, and enhancing customer experience. You will collaborate with a diligent team of professionals who share a passion for progress and excellence. Your responsibi...

Develop and maintain PLSQL procedures functions packages and triggers Knowledge of Batch Scheduling, Familiarity with ETL Tools Prior experience in using Oracle PL SQL and Unix for test automation purposes Design and optimize complex SQL queries for data extraction and reporting Perform data modelling schema design and database tuning Collaborate with application developers to integrate backend logic with frontend applications Conduct unit testing and support system integration and user acceptance testing Monitor and troubleshoot database performance issues Maintain documentation for database structures and processes Participate in code reviews and ensure adherence to best practices PL/SQL, ...

As an Oracle Data Integrator (ODI) Professional at YASH Technologies, you will play a key role in providing prompt and effective support, maintenance, and development on OBIA based Analytics Datawarehouse using ODI as the underlying ETL Tool. Your responsibilities will include implementation, development, and maintenance of the ODI environment, data warehouse design, dimensional modeling, ETL development & support, as well as ETL performance tuning. You will be responsible for solution design, implementation, migration, and support in the Oracle BI Tool stack, particularly ODI and SQL. Your tasks will involve ODI development in an OBIA Environment, enhancements, support, and performance tuni...

You will be responsible for performing joins such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins of two or more tables. Additionally, you will be expected to work with Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve working with Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER. You should have a good understanding of creating and maintaining Views and Materialized Views, as well as executing Hierarchical queries for data retrieval from tables with hierarchical data structures. Furthermore, you will be required to handle Complex Queries involving Nested queries, inline views, correlated subqueries, and h...

The client, a prominent Indian financial technology company based in Chennai, is seeking an experienced Database Architect proficient in PostgreSQL and Oracle RAC to oversee database architecture and operations. Specializing in delivering advanced software solutions for the banking, insurance, and financial services sectors globally, the company is looking for a dedicated professional to lead the design, optimization, and management of enterprise-grade database solutions. The ideal candidate will ensure high availability, security, and performance while also managing a team, overseeing production support, and driving database optimization strategies. Key Requirements: - Extensive expertise i...

You are a Database Performance & Data Modeling Specialist with a primary focus on optimizing schema structures, tuning SQL queries, and ensuring that data models are well-prepared for high-volume, real-time systems. Your responsibilities include designing data models that balance performance, flexibility, and scalability, conducting performance benchmarking to identify bottlenecks and propose improvements, analyzing slow queries to recommend indexing, denormalization, or schema revisions, monitoring query plans, memory usage, and caching strategies for cloud databases, and collaborating with developers and analysts to optimize application-to-database workflows. You must possess strong experi...

At EY, you have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of yourself. Your unique voice and perspective are essential to help EY become even better. Join us to build an exceptional experience for yourself and contribute to creating a better working world for all. As a Senior Aera Developer, you will be a part of the Supply Chain Tech group of EY GDS consulting Team. Your role involves translating business needs into technical specifications, performing data analysis and manipulation, and simplifying business concepts through data modeling. You will be responsible for developing reporting sy...

You are looking for a Data Modelling Consultant with 6 to 9 years of experience to work in Chennai office. As a Data Modelling Consultant, your role will involve providing end-to-end modeling support for OLTP and OLAP systems hosted on Google Cloud. Your responsibilities will include designing and validating conceptual, logical, and physical models for cloud databases, translating requirements into efficient schema designs, and supporting data model reviews, tuning, and implementation. You will also guide teams on best practices for schema evolution, indexing, and governance to enable usage of models in real-time applications and analytics platforms. To succeed in this role, you must have st...

As a Cloud Data Architect specializing in BigQuery and CloudSQL at our Chennai office, you will play a crucial role in leading the design and implementation of scalable, secure, and high-performing data architectures using Google Cloud technologies. Your expertise will be essential in shaping architectural direction and ensuring that data solutions meet enterprise-grade standards. Your responsibilities will include designing data architectures that align with performance, cost-efficiency, and scalability needs, implementing data models, security controls, and access policies across GCP platforms, leading cloud database selection, schema design, and tuning for analytical and transactional wor...

As a Senior Developer BI at our company, your main objective is to determine business requirements and create business intelligence content using Power BI and data analysis to improve decision-making and performance across all business functions. You will be responsible for reporting to various levels of business management. Your key responsibilities will include designing and developing Power BI dashboards, reports, and alerts for stakeholders, as well as identifying and utilizing external sources of information to enhance our own data. You will work on implementing key recommendations, designing data models, and developing data visualizations to help stakeholders understand trends and insi...

You will be responsible for performing JOIN operations such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins on two or more tables. Additionally, you will handle Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve utilizing Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER for data analysis. You should be adept at working with Views and Materialized Views, understanding the basics of creating and maintaining views. Proficiency in executing Hierarchical queries for data retrieval from tables with hierarchical data is essential. Your expertise in handling Complex Queries like Nested queries, inline views, and co...

As a Software Analysis Associate Advisor Sr. BI Analyst and Visualization Expert at Evernorth Health Services, a division of The Cigna Group, you will play a crucial role in creating pharmacy, care, and benefits solutions to improve health and increase vitality for millions of people. Your primary responsibility will be to design, develop, and maintain BI reports using Cognos and other BI tools. You will ensure that BI solutions are optimized for performance and scalability, and develop Materialized Views to support complex data aggregation and reporting requirements. Your role will involve conducting in-depth data analysis to generate business insights and support strategic decision-making....

Job Description Extensive experience in Oracle SQL, PL/SQL, Java script; writing OOP PL/SQL codes for applications demanding type objects, nested tables (Min 4-5 years) Proficient in scripting using Python (2-3 Years) Exposure to create use cases, functional specifications technical design specifications Proficient in creation of database objects like stored procedures, functions, packages, tables, indexes, triggers, snapshots etc. Good experience in performing data migrations, data loads using ETL tools Strong hands-on experience to be able to design, develop, deploy and support RESTful services Experience in job scheduling using CRON utilities, legacy AT scheduler, windows scheduler, Toad ...

Preferred skills and qualifications 7 or more years of experience in building and delivering analytical applications.BE/BTech or higher degree in Computer Science, Computer Engineering.Excellent knowledge on OBIEE/OAC RPD development.Experience in OBIEE/OAC Reports & Dashboard and/or Data Visualization Projects development.Exposure to Data Warehouse design, Star Schema modeling.? Build and manage the OAC RPD models to optimize data accessibility and performance. Create dynamic, user-friendly OAC dashboards and visualizations that turn data into insights. Set up alerts and automate data flows to keep business teams informed in real-time. Collaborate on data warehouse design, data pipelines, h...

Role/Requirement: Oracle Retail Merchandising System (RMS) Development Lead Grade C2 Experience 8 to 12 years Main Responsibilities 1. Responsible for the development, review and test code based on the technical designs. Apply business and functional knowledge to prepare test scenarios. 2. Plan, execute and capture test results. 3. Prepare technical designs based on the functional requirements. 4. Maintain and check-in developed code in code repository. 5. Monitor and troubleshoot bugs and issues related to nightly batches, applications etc. 6. Identify bottle neck queries and suggest tuning ideas for long running batches based on NFRs. 7. Actively participate in the configuration discussion...