27 Materialized Views Jobs

As a Technical Associate - Full Stack Developer at Genpact, you will collaborate with front-end developers and team members to enhance user experience by crafting functional and cohesive codes. Your responsibilities will include developing new programs and features by staying updated on industry trends, participating in ongoing education and training, learning new programming languages, and leading projects when necessary. Qualifications we seek in you: Minimum Qualifications: - B.A. or B.S. degree in a related subject area or equivalent experience - Experience in detailing technical requirements - Proficient in multitasking and proactive in work responsibilities Preferred Qualifications/ Sk...

Role Overview: As a Database Performance & Data Modeling Specialist, your primary focus will be on optimizing schema structures, tuning SQL queries, and ensuring that data models are well-prepared for high-volume, real-time systems. Your responsibilities will include designing data models that balance performance, flexibility, and scalability, conducting performance benchmarking, analyzing slow queries, monitoring query plans, memory usage, and collaborating with developers and analysts to optimize application-to-database workflows. Key Responsibilities: - Design data models that balance performance, flexibility, and scalability - Conduct performance benchmarking to identify bottlenecks and ...

Role Overview: As a Cloud Data Architect specializing in BigQuery and CloudSQL at the Chennai office, you will be responsible for leading the design and implementation of scalable, secure, and high-performing data architectures using Google Cloud technologies. Your expertise in BigQuery, CloudSQL, and the GCP data ecosystem will be crucial in shaping architectural direction and ensuring that data solutions meet enterprise-grade standards. Key Responsibilities: - Design data architectures aligning with performance, cost-efficiency, and scalability needs - Implement data models, security controls, and access policies across GCP platforms - Lead cloud database selection, schema design, and tuni...

Role Overview: As a Database Architect at a leading Indian financial technology company based in Chennai, you will be responsible for overseeing database architecture and operations. Specializing in delivering advanced software solutions for the banking, insurance, and financial services sectors globally, you will lead the design, optimization, and management of enterprise-grade database solutions. Your role will involve ensuring high availability, security, and performance, managing a team, overseeing production support, and driving database optimization strategies. Key Responsibilities: - Lead and mentor the database team for business-as-usual operations and production environments. - Defi...

Job Description: As a candidate for this role, you will be responsible for the development and support of projects on Oracle database-based Enterprise Applications. Your key responsibilities will include: - Demonstrating 3+ years of experience in development and support of projects on Oracle database-based Enterprise Applications. - Showing 2+ years of strong hands-on experience as an SQL developer. - Proficiently writing stored procedures, functions, triggers, and materialized views. - Having expertise in designing tables, views, indexes, and materialized views. - Expertise in writing complex SQL, PL/SQL procedures for application development and reports. - Demonstrating expertise in SQL op...

Role Overview: As a Snowflake Architect at NTT DATA, you will lead the design and implementation of enterprise-grade data platforms using Snowflake. Your role will involve defining architectural standards, guiding engineering teams, and collaborating with stakeholders to align data strategies with business goals. You will focus on leveraging Snowflake's advanced capabilities to build scalable, secure, and high-performance data solutions that support analytics, reporting, and data science initiatives. Key Responsibilities: - Define and own the end-to-end architecture of data platforms built on Snowflake, including ingestion, transformation, storage, and consumption layers. - Design and implem...

Role Overview: With over 6 years of programming experience as an Oracle PL/SQL Developer, you have been involved in the Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). You have a proven track record of Database Modeling, Development, Implementation, and Maintenance, consistently meeting aggressive deadlines. Key Responsibilities: - Develop Client-Server applications using Oracle 12C/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL DEVELOPER, and SQL DEVELOPER DATA MODELER. - Utilize Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, and Query Re-Write effectively. - Create Tables, Views,...

You should have at least 8 years of experience working with Oracle Applications and Oracle Fusion. You should be well-versed in Oracle ERP Database tables, Fusion Analytics Tables (FAW), and Oracle Fusion Tables (BIVO). Additionally, you should have experience with Oracle Business Intelligence Cloud Connector. Your role will involve writing Database Functions, Procedures, views, and materialized views. You should also be proficient in writing advanced-level calculations using Oracle SQL. Experience with Fusion web services will be an added advantage. The position is based in Bengaluru, Gurgaon, or Pune.,

As a skilled Database Administrator with 23 years of hands-on experience, you will be responsible for managing and optimizing relational database systems, focusing on MariaDB and ClickHouse. Your primary tasks will include ensuring high availability, performance, and security of mission-critical databases, as well as supporting automation, deployment, and troubleshooting efforts. Your responsibilities will include installing, configuring, and maintaining ClickHouse in both development and production environments. You will also support and manage at least one other RDBMS such as PostgreSQL, MySQL, or SQL Server. Designing and implementing High Availability (HA) and Disaster Recovery (DR) solu...

Position Purpose The engineer/developer is working closely with his team members and business teams to develop features according to a requirement. He must also ensure that developments are aligned with best practices and monitor what has been promoted on higher environments. Production or tests environments supports activities are also part of the position (job monitoring, issues solving, ) Responsibilities Direct Responsibilities - Participate to all the Agile ceremonies of the squad (Dailys, Sprint plannings, backlog refinements, reviews, etc) - Communicate ASAP on the blocking points - Estimate, design and build technical solution for business needs & requirements according to the Jira r...

Position Purpose The engineer/developer is working closely with his team members and business teams to develop features according to a requirement. He must also ensure that developments are aligned with best practices and monitor what has been promoted on higher environments. Production or tests environments supports activities are also part of the position (job monitoring, issues solving, ) Responsibilities Direct Responsibilities - Participate to all the Agile ceremonies of the squad (Dailys, Sprint plannings, backlog refinements, reviews, etc) - Communicate ASAP on the blocking points - Estimate, design and build technical solution for business needs & requirements according to the Jira r...

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 ...