41 Materialized Views Jobs

You have an exciting opportunity to join a dynamic team as a SQL Developer with a focus on Oracle database-based Enterprise Applications. As part of the team, your role will involve the following key responsibilities: - Utilizing your 3+ years of experience in development and support of projects on Oracle database-based Enterprise Applications. - Demonstrating your 2+ years of strong hands-on experience as an SQL developer. - Showcasing your proficiency in writing stored procedures, functions, triggers, and materialized views. - Applying your expertise in designing tables, views, indexes, and materialized views. - Utilizing your expertise in writing complex SQL and PL/SQL procedures for appl...

Role Overview: 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 su...

Role Overview: You should have 8-12 years of relevant experience as a Database Developer with expertise in PLSQL. Your main responsibilities will include writing complex SQL queries, advanced P/SQL development, performance tuning, data modeling, and working on database objects like stored procedures, functions, packages, triggers, views, and materialized views. Key Responsibilities: - Must-have skills include proficiency in Oracle, PLSQL, complex SQL writing, and basic DBA skills - Advanced P/SQL development involving collections, materialized views, partitioning, etc. - Performance tuning skills for optimizing query performance - Understanding of relational database concepts and strong SQL ...

Warm Greetings from SP Staffing Services Pvt Ltd!!!! Experience: 4 to 12 yrs Location: Bangalore Experience in Plsql Developer Peformace Tuning Interested candidates, Kindly share your updated resume to ramya.r@spstaffing.in or contact number 8667784354 (Whatsapp:9597467601)to proceed further

We are Looking for - PostgreSQL Developer Location : Chennai (5Days Office) Exp Req: 2 to 4Yrs Notice Period : Imm Joiners to 20Days Skill req: Postgres, procedures, functions, triggers, materialized views, and query tuning are mandatory. Job Summary We are looking for a highly skilled PostgreSQL Developer with strong hands-on expertise in database development, performance tuning, and advanced SQL capabilities. The candidate must be proficient in building and optimizing database objects such as procedures, functions, triggers, and materialized views. Experience in Java backend development is a plus but not mandatory. Key Responsibilities Design, develop, and optimize PostgreSQL database obje...

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 will be crucial in shaping architectural direction and ensuring that data solutions meet enterprise-grade standards. **Key Responsibilities:** - Designing data architectures aligned 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 workloads - Colla...

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. You will be responsible for designing data models that balance performance, flexibility, and scalability. Additionally, you will conduct performance benchmarking to identify bottlenecks, analyze slow queries, and collaborate 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 propo...

Role Overview: As an Aera Developer Senior at EY, you will have the opportunity to be a part of the Supply Chain Tech group of EY GDS consulting Team. Your role will involve translating business needs into technical specifications, performing data analysis and manipulation, developing reporting systems, and creating extensive ER diagrams to simplify business concepts. You will be responsible for writing/customizing code in various Aera modules, evaluating and improving Aera Skills, and generating quality reports for customers. Additionally, you will work closely with clients throughout different parts of the implementation lifecycle, demonstrating a proactive and solution-oriented mindset. K...

Key Responsibilities: Design, develop, and maintain PL/SQL code for complex data-driven applications. Write efficient, optimized, and reusable PL/SQL code, stored procedures, functions, triggers, and packages. Collaborate with database administrators and other developers to ensure optimal performance, scalability, and security of the database. Create and maintain database objects such as tables, views, indexes, and sequences. Participate in code reviews to ensure code quality and adherence to best practices. Troubleshoot, debug, and optimize database queries and PL/SQL code to improve performance. Develop and maintain SQL queries and complex reporting queries as per business requirements. Pe...

As a skilled Database Administrator with 23 years of hands-on experience, your primary focus will be on managing and optimizing relational database systems, particularly MariaDB and ClickHouse. Your responsibilities will include: - Installing, configuring, and maintaining ClickHouse in both development and production environments. - Supporting and managing at least one other RDBMS such as PostgreSQL, MySQL, or SQL Server. - Designing and implementing High Availability (HA) and Disaster Recovery (DR) solutions for ClickHouse. - Optimizing query performance through indexing, partitioning, and materialized views. - Automating database administration tasks using Python, Bash, or SQL scripting. -...

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

As a PL/SQL Developer, your main role will be to design, develop, and maintain Oracle database solutions to meet business requirements efficiently. You will be responsible for creating and optimizing PL/SQL scripts, ensuring database performance, and collaborating with cross-functional teams for seamless integration. Your problem-solving skills and in-depth knowledge of relational database concepts will be crucial for success in this role. Key Responsibilities: - Develop, test, and maintain complex PL/SQL packages, procedures, functions, and triggers for data processing and ETL tasks. - Design and implement database schemas and objects including tables, indexes, and views. - Analyze business...

Role Overview: As a Consultant - Backend Developer at Genpact, your role involves collaborating with team members to troubleshoot and enhance current back-end applications and processes. You will work closely with front-end developers to improve user experience by crafting functional codes. Additionally, you will be responsible for developing new programs or features, staying updated on industry trends, and participating in ongoing education and training to enhance your skills. Your strong communication and collaboration skills will enable you to work independently and take the lead on projects when required. Key Responsibilities: - Collaborate with front-end developers and team members to e...

Dear Candidate, Please share your updated resume on supriya.srivastava@ltimindtree.com Job Title - PLSQL with Oracle Forms Experience 6 to 12 years. Notice Period- Immediate joiners to 1 month only Location- Mumbai, Pune, Bangalore, Chennai, Coimbatore, Delhi NCR, Kolkata and Hyderabad Job description PLSQL Developer with Oracle Forms Oracle forms + PLSQL Detailed JD 1 Provide ongoing support and maintenance of inhouse applications using Oracle SQL PLSQL and Oracle Forms 2 Conduct code design and development using Oracle SQL PLSQL and Oracle Forms 3 Develop PLSQL database objects SQL scripts interfaces reports and forms using standard tools including Oracle Forms Report Builder Oracle Applic...

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