15 Materialized Views Jobs

Wissen Technology is currently seeking a skilled Senior Java Developer with expertise in Core Java, multithreading, collections, and React.js to join our technology team supporting the BFSI sector. As a part of our globally recognized organization, you will have the opportunity to work with major financial institutions and deliver high-quality IT solutions. In this role, you will be responsible for designing, developing, and maintaining high-performance Java applications used in banking and financial services. You will also be involved in developing responsive web applications using React.js and applying your knowledge of Java collections, concurrency, and multithreading to optimize JVM performance and memory usage in enterprise-scale systems. Key Responsibilities: - Design, develop, and maintain high-performance Java applications for the BFSI sector. - Develop responsive web applications using React.js. - Apply expertise in Java collections, concurrency, and multithreading. - Optimize JVM performance and memory usage. - Write clean, efficient code following best practices. - Work with relational databases and apply advanced concepts. - Collaborate with cross-functional teams to deliver robust solutions. - Participate in code reviews, unit testing, and mentor junior developers. - Troubleshoot and resolve complex application issues in production environments. Required Skills & Qualifications: - 5+ years of hands-on development experience with Core Java. - Strong understanding and practical experience with collections, concurrent programming, and multi-threading. - Experience in building modern web interfaces using React.js. - In-depth knowledge of the JVM with experience in performance tuning. - Solid understanding of Object-Oriented Design and Data Structures. - Expertise in relational database systems with advanced SQL knowledge. - Strong communication skills. - BFSI domain experience is a strong advantage. Join Wissen Technology, a specialized technology company within the Wissen Group, and be a part of our mission to deliver high-end consulting services for organizations in the Banking & Finance, Telecom, and Healthcare domains. Our services include Core Business Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, and more.,

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, Big Query,- Google Unix Shell Scripting. Design and optimize complex SQL queries for data extraction and reporting

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 tuning of SQL programs. Additionally, you will be involved in data warehouse design, development, and maintenance using Star Schema (Dimensional Modeling). Your role will also encompass production support of daily running ETL loads, monitoring, troubleshooting failures, bug fixing across environments, and working with various data sources including Oracle, CRM, Cloud, Flat Files, Sharepoint, and other non-Oracle systems. Experience in performance tuning of mappings in ODI and SQL query tuning will be essential. To succeed in this role, you should have 5-7+ years of relevant experience working in OBIA on ODI as the ETL tool in a BIAPPS environment. Strong written and oral communication skills, the ability to work in a demanding user environment, and knowledge of tools like Serena Business Manager and ServiceNow are crucial. A B.Tech / MCA qualification is required, and competencies such as being tech-savvy, effective communication, optimizing work processes, and cultivating innovation are essential. At YASH, you will have the opportunity to create a career path in an inclusive team environment that supports continuous learning and development. Our Hyperlearning workplace is grounded on principles such as flexible work arrangements, agile self-determination, trust, transparency, and stable employment with an ethical corporate culture. Join us at YASH Technologies and be part of a team that fosters positive changes in an ever-evolving virtual world.,

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 have basic knowledge of Table Partitioning including table and index partitioning. In addition, you must have proficiency in PL/SQL and be able to create and maintain objects like procedures, functions, packages, types, and triggers. Your expertise should also include recursion, loops (FOR, WHILE DO), nested blocks, conditional logic (IF, CASE statements), and managing exceptions effectively. Moreover, you should be familiar with working with Collection & Records in PL/SQL blocks and executing BULK operations efficiently. Requirements: - Minimum of 2 years of relevant experience in posgress SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred certifications: - PL/SQL Developer Certified Associate Preferred Location: - Mumbai: Thane, Mulund, Bhandup, Vikroli, Ghatkopar, Kurla, and Powai Notice Period: - Immediate Joiner required This is a full-time position with a flexible schedule. You will be expected to work day shifts from Monday to Friday with morning shifts and weekend availability. Performance bonuses will be provided based on your contributions. Ability to commute/relocate to Mumbai, Maharashtra is required. Ideally, you should have a total of 1 year of work experience.,

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 in Oracle RAC, standalone databases, and Primary vs Standby setups. - Profound experience in PostgreSQL (8+ years) and a total of 15+ years in database management. - Strong skills in performance tuning, data modeling, and query optimization. - Proficiency in tools such as SQLPlus, SQL Developer, SQLLoader, and technologies like Materialized Views, Explain Plan, SPM, and PL/SQL. - Good understanding of database metrics, MIS reporting, and resource/task management. - Proven track record in Oracle 19c+ installation, Disaster Recovery (DR) drills, and security & compliance protocols. - Leadership qualities to manage teams effectively and communicate with clients and auditors. Key Responsibilities: - Lead and mentor the database team for business-as-usual operations and production environments. - Define KRAs, conduct performance appraisals, and plan support rosters. - Design and implement PostgreSQL & Oracle RAC systems focusing on reliability and scalability. - Oversee production support, swiftly resolve issues, and minimize downtime. - Optimize database performance utilizing AWR, ADDM, and SAR reports. - Plan and execute upgrades, year-end activities, DR drills, and migrations. - Implement security protocols such as TDE, Redaction, and Compliance Mandates. - Collaborate with internal teams to deliver customized database solutions. - Engage in strategic discussions with clients, banks, and auditors. - Drive automation, process improvements, and service-level enhancements continuously. Why Join - Lead critical database architecture in a rapidly expanding product-based tech company. - Work with top-tier professionals and create a real impact. - Be part of strategic initiatives shaping the company's future. - Enjoy competitive compensation, growth prospects, and an innovation-centric culture.,

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 experience in database performance tuning, especially in GCP platforms like BigQuery, CloudSQL, and AlloyDB. Proficiency in schema refactoring, partitioning, clustering, and sharding techniques is essential. Familiarity with profiling tools, slow query logs, and GCP monitoring solutions is required, along with SQL optimization skills including query rewriting and execution plan analysis. Preferred skills include a background in mutual fund or high-frequency financial data modeling, hands-on experience with relational databases like PostgreSQL, MySQL, distributed caching, materialized views, and hybrid model structures. Soft skills that are crucial for this role include being precision-driven with an analytical mindset, a clear communicator with attention to detail, and possessing strong problem-solving and troubleshooting abilities. By joining this role, you will have the opportunity to shape high-performance data systems from the ground up, play a critical role in system scalability and responsiveness, and work with high-volume data in a cloud-native enterprise setting.,

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 systems, writing/customizing code in various Aera modules, and evaluating and improving Aera Skills. Additionally, you will generate quality reports, develop data visualizations, and work with clients throughout the implementation lifecycle. To succeed in this role, you must have experience as an Aera Skill Builder, expertise in BI reporting and data warehouse concepts, strong data modeling skills, and proficiency in Aera skill builder modules. You should be skilled in creating dynamic visualizations, configuring Aera skills, applying security concepts, and handling report performance and administration. Aera Skill Builder and Aera Architect certification is required. Ideal candidates will have a strong knowledge of Aera Skill Build concepts, expertise in data handling, experience in SQL tuning and optimization, and the ability to interact with customers to understand business requirements. Good communication skills, problem-solving abilities, and a proactive approach to learning new technologies are also important. In this role, you will drive Aera Skill Development tasks and have the opportunity to work with a market-leading, multi-disciplinary team. EY offers a supportive environment, coaching, and feedback from engaging colleagues, opportunities for skills development and career progression, and the freedom to handle your role in a way that suits you. EY is committed to building a better working world by creating long-term value for clients, people, and society, and by fostering trust in the capital markets. Through the expertise of diverse teams worldwide, EY provides trust, assurance, and support for clients to grow, transform, and operate effectively across various industries.,

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 strong experience in modeling across OLTP and OLAP systems, hands-on experience with GCP tools like BigQuery, CloudSQL, and AlloyDB, and the ability to understand business rules and translate them into scalable structures. Additionally, familiarity with partitioning, sharding, materialized views, and query optimization is essential. Preferred skills for this role include experience with BFSI or financial domain data schemas, familiarity with modeling methodologies and standards such as 3NF and star schema. Soft skills like excellent stakeholder communication, collaboration, strategic thinking, and attention to scalability are also important. Joining this role will allow you to deliver advisory value across critical data initiatives, influence the modeling direction for a data-driven organization, and be at the forefront of GCP-based enterprise data transformation.,

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 workloads, collaborating with DevOps and DataOps teams to deploy and manage data environments, ensuring best practices for data governance, cataloging, and versioning, and enabling real-time and batch integrations using GCP-native tools. To excel in this role, you must possess deep knowledge of BigQuery, CloudSQL, and the GCP data ecosystem, along with strong experience in schema design, partitioning, clustering, and materialized views. Hands-on experience in implementing data encryption, IAM policies, and VPC configurations is crucial, as well as an understanding of hybrid and multi-cloud data architecture strategies and data lifecycle management. Proficiency in GCP cost optimization is also required. Preferred skills for this role include experience with AlloyDB, Firebase, or Spanner, familiarity with LookML, dbt, or DAG-based orchestration tools, and exposure to the BFSI domain or financial services architecture. In addition to technical skills, soft skills such as visionary thinking with practical implementation skills, strong communication, and cross-functional leadership are highly valued. Previous experience guiding data strategy in enterprise settings will be advantageous. Joining our team will give you the opportunity to own data architecture initiatives in a cloud-native ecosystem, drive innovation through scalable and secure GCP designs, and collaborate with forward-thinking data and engineering teams. Skills required for this role include IAM policies, Spanner, cloud, schema design, data architecture, GCP data ecosystem, dbt, GCP cost optimization, data, AlloyDB, data encryption, data lifecycle management, BigQuery, LookML, VPC configurations, partitioning, clustering, materialized views, DAG-based orchestration tools, Firebase, and CloudSQL.,

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 insights. Additionally, you will be involved in testing and troubleshooting data models, providing production support, and continuously monitoring the BI solution to align with changing business requirements. To excel in this role, you must be fluent in English and have a strong background in BI design, data visualization best practices, and multiple BI tools such as Power BI and Tableau. Proficiency in SQL Server, including SQL objects development, performance tuning, and data analysis, is essential. You should also have experience with Semantic Layer and Data Marts, as well as exceptional SQL skills and the ability to translate complex quantitative analysis into meaningful business insights. As a team-oriented individual with strong communication, planning, and problem-solving skills, you will be expected to handle multiple projects within deadlines and work effectively under pressure. Your role will also involve interacting with internal and external stakeholders, so possessing cultural awareness, flexibility, and sound work ethics is crucial. The ideal candidate for this position will have a Bachelor's degree in Computer Science, at least 5 years of experience as a BI Developer and Data Analyst, and familiarity with reporting, visualization, and programming languages like SQL, T-SQL, and DAX. Additionally, any certifications related to Business Intelligence or Microsoft Power BI/Azure will be considered advantageous. This role may require site visits as necessary and the ability to work in Middle East summer weather conditions. You will report directly to the Business Intelligence Manager and will be managing multiple tasks with limited resources, making effective time management and resource utilization essential for success.,

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 correlated subqueries will be crucial. Knowledge of Table Partitioning, including table & index partitioning, is required. You will be expected to work with PL/SQL, creating and maintaining objects such as procedures, functions, packages, types, and triggers. Familiarity with recursion, loops (FOR, WHILE DO), nested blocks, and conditional logic (IF, CASE statements) is necessary. You must possess experience in managing Exception handling for run-time Oracle defined/user-defined errors. Understanding the usage of collections and records in PL/SQL blocks is vital. Proficiency in BULK operations for performing operations on bulk data is a must. Requirements: - Minimum 2 years of relevant experience in PostgreSQL SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: Preferred certifications: - PL/SQL Developer Certified Associate Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred Location: (Mumbai) Thane, Mulund, Bhandup, Vikhroli, Ghatkopar, Kurla, and Powai Notice Period: Immediate Joiner required. Job Types: Full-time Benefits: - Flexible schedule Schedule: - Day shift, Monday to Friday, Morning shift - Weekend availability Performance bonus offered. Ability to commute/relocate: - Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Experience: - Total work: 1 year (Preferred),

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. You will identify trends, patterns, and anomalies in data and provide actionable recommendations. Collaborating closely with business stakeholders, you will gather requirements and translate them into BI solutions. Additionally, you will provide training and support to end-users on BI tools and reporting capabilities. Ensuring data accuracy and integrity in all BI outputs will be a key focus area for you. You will participate in data quality and governance initiatives to maintain reliable data sources. Staying updated with the latest BI technologies and trends, you will continuously improve BI processes and methodologies. Working with distributed requirements and technical stakeholders, you will complete shared design and development tasks. To excel in this role, you must have extensive experience with BI tools, particularly Cognos, and proficiency in SQL and other data querying languages. Strong data visualization skills and experience with tools like Cognos, Tableau, or Power BI are preferred. You should also have experience creating and managing Materialized Views in data warehouse and data lake environments, a solid understanding of OOP, Design Patterns, and JSON Data Structures, as well as familiarity with AWS, Redshift, and CI/CD practices. With a minimum of 8 years of experience and a college degree in related technical/business areas, you will be recognized internally as the go-to person for the most complex software engineering assignments. Your proven experience with architecture, design, and development of large-scale enterprise application solutions, along with industry certifications in BI or data analysis, will be valuable assets in this role. Evernorth is an Equal Opportunity Employer that actively encourages and supports diversity, equity, and inclusion efforts across the organization. Join us in our mission to make the prediction, prevention, and treatment of illness and disease more accessible to diverse client populations.,

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 Self-motivated and committed team player with excellent communication and interpersonal skills Solid written and verbal communication skills and able to articulate the technically complex to be understood by both technical and non-technical personnel Able to develop scalable solutions that can be utilized by current and future channels e.g. mobile Understanding the importance of real business engagement in all stages of IT product lifecycle working in agile delivery methodologies

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, helping shape how we store and manage data. Good understand on Snowflake/Oracle Hyperion/EPM Have a good broader business understanding and mindset, while technically leading efforts in specific areas. Make effective judgments and choices on design and roadmap based on various considerations. Work with business and technical teams to understand needs and deliver effective OAC solutions. Troubleshoot and solve any issues that come up with data flows, dashboards, or OAC configurations. Stay current with OAC updates and best practices, continually improving our analytics capabilities. Excellent knowledge in development of repository at all the three layers including Physical Layer, Business Model and Mapping Layer and Presentation Layer. Knowledge in creating Logical columns, Hierarchies (Level Based, Parent Child), Measures, Aggregation Rules, Aggregations, Time Series in Business Model and Catalog Folders in Presentation layers. Good Knowledge in security set up for reports and dashboards, and OBIEE administrative activities. Experience on Oracle SQL, database performance tuning by implementing Views, Materialized views, creating indexes. Strong interpersonal and team leadership skills

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 discussions and defect triaging and align with teams for appropriate solution 8. Develop custom extensions and integration across RMS with other applications 9. Provides technical assistance and support for queries and issues raised by the business and other IT functions related to Oracle solutions Skills Needed 9. Very client focused with regards to service delivery 10. Exposure to ORMS functionalities v14, v16 (Foundation Data, Item Supplier, PO, Transfer/Allocation, Shipment/Receipt Stock Ledger etc. 11. Worked on at least 2 implementation projects on RMS v14/v16 12. At least 8-10 years of development experience in Oracle Retail application 13. Should have strong PL/SQL knowledge, expertise in writing stored procedures, triggers, functions, dynamic SQLs, materialized views, PL/SQL collections. 14. Should have unix shell scripting skills and decent ProC knowledge 15. Strong written and communication skills 16. Working knowledge of complete RMS Batch flow Nice to have 17. Good people/interpersonal skills 18. Capable of working under a fast pace and dynamic working environment 19. Should have overall understanding of all the Oracle Retail Modules 20. Hands on ADF knowledge will be added advantage 21. Exposure in RMS Deals Module