716 Query Optimization Jobs - Page 26

Job Title: NoSQL Migration Specialist Role Summary: We are looking for a skilled NoSQL Migration Specialist to lead and execute database migration projects, focusing on MongoDB to Oracle Autonomous JSON Database (AJD) and other NoSQL-to-relational transitions. The ideal candidate will have hands-on experience in NoSQL databases (MongoDB, Cassandra, etc.), data export/import, schema mapping, and cloud platforms like Oracle Cloud, AWS, or Azure. Key Responsibilities: Plan and perform data migrations from MongoDB and similar NoSQL databases to Oracle AJD. Design and execute data export/import workflows (mongoexport/mongoimport, replication). Work with solution architects to define migration strategies and timelines. Troubleshoot performance, compatibility, and connectivity issues. Collaborate with developers and DevOps teams to ensure seamless application integration. Skills & Experience: Proficient in MongoDB administration and data modeling. Experience with Oracle Autonomous Database / JSON Database. Familiarity with MongoDB API on Oracle, cloud networking, and security. Knowledge of SQL, NoSQL query optimization, and aggregation frameworks. Scripting skills (Python, Shell) preferred.

Role & responsibilities Data Analyst working SQL Project. Have developed & analyzed Databases using SQL Should have created Tables & Ad-hoc queries on SQL, Ad-hoc reporting. Strong SQL experience - Advanced level of SQL Excellent data interpretation skills Good knowledge of ETL and a business intelligence, good understanding of range of data manipulation and analysis techniques Working knowledge of large information technology development projects using methodologies and standards Excellent verbal, written and interpersonal communication skills, demonstrating the ability to communicate information technology concepts to non-technology personnel, should be able to interact with business team and share the ideas. Strong analytical, problem solving and decision-making skills, attitude to plan and organize work to deliver as agreed. Hands on experience working with large datasets. Able to manage different stakeholders.

JOB DESCRIPTION Role: Software Development Engineer II Amagi Background Amagi is a dynamic cloud-native SaaS platform that enables content owners to deliver their media seamlessly to consumers across various devices. With a strong emphasis on transforming media consumption, Amagi connects content owners, distribution platforms, consumers, and advertisers to curate exceptional viewing experiences. As a leader in the FAST (Free Ad-supported Streaming TV) space, Amagi supports over 500 media brands across 1500+ endpoints and continues to witness tremendous growth. Amagi Analytics Amagi Analytics is dedicated to providing comprehensive insights via its end-to-end analytics product. This highly scalable platform handles the ingestion of multiple TBs of data daily, offering valuable analytics and predictions to users across channel performance, content efficiency, advertising insights, and billing data. Role reporting into : Senior Engineering Manager, Amagi Analytics Location: Bangalore, India Key Responsibilities Develop, maintain, and enhance scalable backend services and frameworks within the data platform team. Work closely with product managers, designers, and fellow engineers to ensure deliverables and milestones are met. Contribute to the design, development, and implementation of efficient and maintainable code. Involve in code reviews and design discussions to promote best practices. Diagnose performance bottlenecks and scalability challenges, proposing innovative solutions. You will excel at this role, if you have A bachelor s/master s degree in Computer Science or related field with 3+ years of experience in software development. Proficient in either Python or Go, with ha

Performance Tuning , table & data partitioning ORACLE performance tests.Must have worked as application DBA & having proficiency in setting up health & performance check process for day to day monitoring. Having hands on exp. in query optimization. Required Candidate profile Must have exposure/experience in HDFS/HADOOP, HIVE and ICEBERG, Capital Market Exp. preffer

Senior Software Engineer I (MS SQL Server Database Engineer) Job Description Opportunity Summary: We are looking for an enthusiastic and dynamic individual with an overall experience of 6+ years to join Upland India as a Senior Software Engineer in Microsoft SQL Server for our Upland PSA products. What would you do? Develop, test, and maintain the database code Create or modify database objects and/or write SQL code in support of application needs Monitor and improve database performance and capacity Ensure that database systems are safeguarded and implement necessary security measures to ensure data integrity Assist with upgrading database for new version release when needed Syncing data across data sources Conduct research on emerging database and application development software products, languages, and standards in support of development efforts What are we looking for? Technical Skills The following skills are needed for this role. Experience: Must have Expert level (6 + years ) hands-on database development experience and skills and database maintenance experience) in MS SQL Server Primary Skills: The candidate must possess the following primary skills: Excellent (6+ years) hands-on database experience and skills in developing MS SQL Server Stored Procedures, functions, triggers, queries, scripts, etc. Excellent (6+ years) hands-on MS SQL Server database experience in troubleshooting, performance tuning, debugging, and query optimization in MS SQL Server Excellent (6+ years) in indexing, finding and resolving potential for database deadlocks Experience in MS SQL Server database migrations and upgrades. Has experience with analytics and reporting Secondary Skills: It would be advantageous if the candidate also has the following secondary skills: Have a MS SQL Server / Azure SQL certification OR are willing to obtain in a short time frame. Nice to have experience with: ETL, Azure SQL Soft Skills: Strong writing skills are essential, as is the ability to work effectively in a fully remote team without the need for a physical office. The ideal candidate thrives in a collaborative team environment with a diverse range of people and is passionate about delivering an amazing customer experience. They should be adaptable, capable of changing their mind and influencing others Growth Skills: The candidate should have a strong work ethic, be a self-starter with a desire to grow, and consistently seek better ways to accomplish tasks. Qualification Bachelors degree or technical institute degree/certificate in Computer Science, Information Systems, or other related field or equivalent combination of knowledge and experience. This role requires overlap with multiple time zones for planning meetings, status updates etc. on a regular basis. The duration of these overlaps can change depending on the type of meeting. Upland India has the flexibility to manage your working hours accordingly to help in your work-life balance. You can find out more about this during your interview conversation. Upland Software is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other legally protected status. About [Upland PSA] Upland PSA focuses on planning, execution and financial management of projects. This includes project related business functions such as Timesheet & Leave Request Management, Expense Entry & Approvals, Project Planning & Scheduling, Resource Allocation, and Invoicing.

Job Description Key Responsibilities: Manage and optimize Oracle Exadata and SQL database environments for high availability, scalability, and peak performance. Configure, fine-tune, and secure databases to ensure reliability and efficiency. Monitor, diagnose, and resolve complex database issues in a high-traffic 24x7 production environment. Design and implement backup and disaster recovery solutions to safeguard data integrity. Optimize database queries, indexes, and performance to enhance operational efficiency. Collaborate with application developers to align database structures with business requirements. Plan and execute database upgrades, capacity planning, and storage management. Enforce security best practices, access controls, and compliance standards. Maintain detailed documentation of configurations, policies, and best practices. Stay ahead of industry trends and advancements in database technologies. Required Qualifications: Hands-on experience with database monitoring tools and automation. Expert-level expertise in Oracle Exadata administration, including performance tuning, storage optimization, and security. Strong proficiency in SQL Server, with experience in high availability solutions (Always On, clustering, replication, etc.). Deep understanding of SQL, Database, indexing strategies, query optimization, and transaction management. Strong troubleshooting skills with a focus on reliability, resilience, and scalability. Experience designing and implementing backup/recovery strategies and disaster recovery planning. Ability to work in a fast-paced, high-stakes environment with a proactive and solution-driven mindset. Excellent communication and collaboration skills, with the ability to work across teams. This is an exciting opportunity to work on cutting-edge database technologies and solve complex challenges in a dynamic, mission-critical environment. If you have the technical expertise and problem-solving mindset to drive database excellence, wed love to hear from you! Career Level - IC3 Responsibilities As a Senior Systems Engineer, you will interface with the customer's IT staff on a regular basis. Either at the client's site or from a remote location, you will be responsible for resolution of moderately complex technical problems related to the installation, recommended maintenance and use and repair/workarounds for Oracle products. You should be highly experienced in some Oracle products and several platforms that are being supported. You will be expected to work with only general guidance from management while advising management on progress/status.

Job Description The Tools and Innovation team is a high-performing software development group within Oracle's product development organization. Tasked by executive leadership with creating cutting-edge tools, the team drives Oracle's business forward with solutions that are highly complex, visible, and impactful across the company. These mission-critical innovations empower executives to make key decisions shaping the future of Oracle's SaaS business. We are seeking an experienced full stack developer to join our team in designing and developing innovative tools that empower Oracle's SaaS business. As a full stack developer, you will bring new components to life, working on systems that are highly visible and critical to Oracle's operations. We value team members who strive to understand the business, ensuring that what we deliver aligns closely with organizational goals. With a strong focus on quality, you will ensure that your work provides an accurate and effective interpretation of data, while driving improvements in how we deliver our solutions. You will collaborate across multiple teams, including product, UX, Architects, QA, Data Engineers and DevSecOps, to achieve seamless integration and deliver end-to-end solutions. Our team is dedicated to continuous improvement, always exploring new ways to enhance our processes, systems, and outcomes. Career Level - IC5 Responsibilities The full stack developers responsibilities include : Architect, design, and develop responsive, scalable web applications with advanced, dynamic front-end components and complex back-end systems using modern frameworks and technologies. Develop RESTful APIs and microservices, ensuring seamless integration with databases, third-party services, and internal systems. Architect and oversee the development of complex microservices ecosystems, ensuring high availability, security, and scalability. Ensure comprehensive documentation of APIs and microservices, including endpoint specifications, data models, authentication methods, and integration points, to facilitate ongoing development and collaboration across teams. Design and optimize database schemas, write efficient SQL queries, and implement indexing strategies to ensure high-performance data retrieval. Architect complex data solutions such as replication, partitioning, and tuning for large-scale applications. Collaborate with DevSecOps engineers to drive best practices and ensure automation across the entire software lifecycle. Partner with QA engineers to define and execute comprehensive testing strategies. Take ownership of unit testing, integration testing, and end-to-end testing by integrating appropriate testing frameworks. Ensure identification and resolution of code smells through continuous refactoring efforts, utilizing tools like static code analysis to improve code maintainability and performance. Integrate advanced security measures into the testing pipeline, maintain high coding standards through proactive collaboration with QA and Governance teams. Lead identification, root cause analysis and resolution of performance bottlenecks and defects. Drive advanced optimization efforts, including profiling, query tuning, and high-load testing. Define strategies for scaling solutions effectively. Lead and drive technical discussions and decisions across the team. Mentor and guide junior developers, conduct in-depth code reviews, and establish best practices. Ensure effective collaboration with cross-functional teams for high-quality outcomes. Stay at the forefront of emerging technologies, drive their adoption across the team, and contribute to the continuous improvement of development processes and methodologies. Lead the collaboration with the UX designer, guiding the translation of wireframes and mockups into high-quality, responsive interfaces. Ensure alignment with user experience goals and drive consistency and usability across the application. Job Requirements: Expert proficiency in modern front-end technologies, such as JavaScript, and frameworks/libraries like REACT, Svelte, Angular, or Vue.js Expert proficiency in back-end technologies and frameworks, such as java (Spring Boot), Helidon, Python, Node.js, and ORM tools like JPA and Hibernate. Strong expertise in microservices architecture, including the design and development of RESTful APIs using technologies like Spring Boot (Java), Express (Node.js), or Flask (Python). Experience with API Management, documentation (e.g. Swagger/OpenAPI) and secure API practices (e.g, OAuth, JWT) Advanced expertise in relational databases (PostgreSQL, MySQL, SQL Server) and NoSQL databases (MongoDB, Cassandra). Experience with data modeling, indexing, and query optimization. Extensive experience working with Oracle Cloud Infrastructure (OCI) or similar, particularly in designing and deploying scalable, cloud-native solutions. Expertise in designing and optimizing CI/CD pipelines with tools like Jenkins, GitLab CI, or Graddle. Knowledge of containerization and orchestration technologies such as Docker and Kubernetes. Background in automated testing (unit, integration, and end-to-end) using frameworks like JUnit, Mocha, Jasmine, or Cypress. Expertise in Git, including branching strategies, code reviews, and collaboration tools such as GitHub or GitLab. Qualifications: 10+ years of experience in full-stack development, with a proven track record of architecting and delivering complex applications at scale. Experience leading technical initiatives, mentoring junior engineers, and driving architectural decisions. Strong analytical and problem-solving skills with the ability to resolve complex technical challenges. Bachelors or masters degree in computer science, Engineering, or a related field, or equivalent practical experience.

An experienced consulting professional who has an understanding of solutions, industry best practices, multiple business processes or technology designs within a product/technology family. Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Over 3 to 5+ years of relevant IT experience with 5 + years in Oracle VBCS, OIC, PL/SQL, PCS based implementations as a Technical lead and senior developer Role is an Individual Contributor role. Being Hands-On is a critical requirement. Must Have: Experience Solution design for Customer engagements in the UI and Integration (OIC) space At least 5 project experience in developing SaaS Extensions using VBCS, OIC ORDS. Understanding of Inherent tools and technologies of SaaS Applications (FBDI, BIP, ADFDI, Applications Composer, Page Integration, etc.) Expertise in Oracle Visual Builder Studio, Good experience with Build and Release, Systems Integration, Agile, Estimations/Planning. Experience in configuring SSO PaaS extensions with Fusion SaaS Drive detailed design using customer requirements Good understanding and usage of OCI architecture, serverless functions, APU Gateway, object storage Conduct Design review to provide guidance and Quality assurance around standard methodologies and frameworks Experience in PCS is an added advantage. Good to have SOA/OSB/ODI/BPM skills. Have experience of building at least one project from scratch Experience with rolling out three big project (multiple phased release or country rollouts) to production. #LI-DNI Career Level - IC2 Responsibilities Standard assignments are accomplished without assistance by exercising independent judgment, within defined policies and processes, to deliver functional and technical solutions on moderately complex customer engagements. #LI-DNI

As a member of the Support organization, your focus is to deliver SaaS support and solutions to the Oracle customer in Customer Success Services while serving as an advocate for customer needs. This involves resolving SaaS Ap-plications technical/non-technical customer incidents via Incident Management System and electronic means, as well as, technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues. You would be expected to be a hands-on lead with Oracle Fusion Supply Chain Management Functional/Technical skills. Career Level - IC4 Responsibilities As a Supply Chain Management Lead, you will offer strategic functional/technical support to assure the highest level of customer satisfaction. A primary focus is to create/utilize automated technology and instrumentation to diagnose, document, and resolve/avoid customer issues. You are expected to be an expert member of the technical problem solving/problem avoidance team, routinely sought after to address extremely complex, critical customer issues. Services may be frequently provided by on-site customer visits.

Job Description Oracle Financial Services Global Business Unit (FSGBU) is a world leader in providing IT solutions to the Financial Services industry. Oracles customers include ten of the top ten Global Banks, ten of the top ten Insurance companies, ten of the top ten Securities firms, five of the top five Mutual Fund companies and four of the top five World Stock Exchanges. Banking Consulting NACA which is a part of Americas Region under FSGBU - Consulting delivers Oracle Technology and Applications solutions for clientele in the North America and Caribbean region. The service offerings include Application Implementation, Managed Services and Customization development services for Oracle Financial Services Software Banking products. Career Level - IC2 Responsibilities Mandatory Skills: 4 6 years of Oracle PL/SQL, PL/SQL and Oracle Database experience. Knowledge and skills in software programming in Oracle PL/SQL Experience in procedures, triggers and functions Should have design and coding experience of enterprise applications Should have experience in Code review tools like Sonar. Should have experience in writing unit testing using utPLSQL etc. Should be able to understand complex SQL queries and query optimization. Exposure to any cloud environment is preferable. Moderate experience on Unix, shell scripting Basic understanding of webservices and RESTful API Job Responsibilities Activities in Development or Implementation or Managed Service activity streams as a Technical Consultant. Your responsibilities include: Perform analysis and development of application components in Oracle PL/SQL Ensure quality code delivery Perform unit testing for the developed code. Participate in design discussion and perform module design. Support SIT, UAT during testing Develop programs as per specifications/requirements given by Oracle / Client within planned schedule. Use defined standards/tools/processes to achieve deliverables that meet quality expectations of Oracle / Client. Document all work in accordance with agreed standards/processes applicable for Oracle / Client. Adhere to defined Change Control Process of Oracle / Client. Comply with Oracle / Client audit / Compliance requirements. Good to have Exposure to Banking Domain Experience in Core Java, J2EE, Webservices (Rest services) You are aware of latest technologies in Banking Customer facing experience w.r.to technical discussions Experience Experience of 4 to 6 years Experience in development and / or implementation and / or support of core banking applications. Job Location: - Bangalore

Role & responsibilities Strong hands-on Experience in SQL Development Writing & Optimizing Database Queries Database Design & Maintenance Performance Tuning Troubleshooting & Debugging Documentation & Continuous Learning Experience applying an automation-first approach using configuration management tools and scripting (e.g., PowerShell & Python). Experience with configuration management and orchestration tools (e.g., Ansible, Jenkins). Proficiency in database management, including Oracle or Microsoft SQL Server administration. Experience supporting large-scale enterprise applications and systems on public cloud infrastructure (AWS preferred). Familiarity with continuous integration tools (e.g., GitHub, Azure DevOps). Hands-on experience with AWS services such as Lambda, Secrets Manager, Parameter Store, DynamoDB, and CLI. Experience implementing infrastructure-as-code, self-healing systems, and security automation. Work Timing: 5:30 PM 2:30 AM IST

Database Design Collaborate with application developers to design and optimize SQL databases that meet application requirements, scalability, and performance needs Database Implementation Install, configure, and set up SQL Server instances, creating and configuring databases, tables, and stored procedures Performance Tuning Monitor and optimize database performance, identifying and resolving performance bottlenecks, query optimization, and index maintenance Backup and Recovery Develop and implement database backup and recovery strategies to ensure data availability and integrity Security Manage database security by configuring user roles, permissions, encryption, and auditing to protect sensitive data Maintenance Perform routine maintenance tasks, such as patching, upgrading, and applying service packs to keep SQL Server instances up to date High Availability Implement high availability and disaster recovery solutions, such as clustering, replication, and Always On availability groups Monitoring and Alerting Set up monitoring tools to track database health and performance, configuring alerts for proactive issue resolution Documentation Maintain detailed documentation of database configurations, procedures, and incidents Query and Performance Analysis Analyze and optimize SQL queries for efficient data retrieval and manipulation

Job Title : Snowflake Developer (4+ years' experience) Location : F, 384, Sector 91 Rd, Phase 8B, Industrial Area, Sector 91, Sahibzada Ajit Singh Nagar, Punjab 160055. Job Type : Fulltime (In-house) Job Overview : We are looking for an experienced Snowflake Developer with 4+ years of hands-on experience in Snowflake Data Warehouse and related tools. You will be responsible for building, managing, and optimizing Snowflake data pipelines, assisting in data integration, and contributing to overall data architecture. The ideal candidate should have a strong understanding of data modeling, ETL processes, and experience working with cloud-based data platforms. Responsibilities : Design, develop, and maintain Snowflake Data Warehouses. Create and manage Snowflake schema, tables, views, and materialized views. Implement ETL processes to integrate data from various sources into Snowflake. Optimize query performance and data storage in Snowflake. Work with stakeholders to define data requirements and provide technical solutions. Collaborate with Data Engineers, Data Scientists, and Analysts to build efficient data pipelines. Monitor and troubleshoot performance issues in Snowflake environments. Automate repetitive data processes and report generation tasks. Ensure data integrity, security, and compliance with data governance policies. Assist in data migration and platform upgrades. Required Skills : 4+ years of experience working with Snowflake Data Warehouse . Proficient in SQL , SnowSQL , and ETL processes . Strong experience in data modeling and schema design in Snowflake. Experience with cloud platforms (AWS, Azure, or GCP). Familiarity with data pipelines , data lakes, and data integration tools. Experience in query optimization and performance tuning in Snowflake. Understanding of data governance and best practices. Strong knowledge of data security and privacy policies in a cloud environment. Experience in using tools like dbt , Airflow , or similar orchestration tools is a plus. #Salary: No bar for deserving candidates. Location: - Mohali Punjab (Work from office) Shift:- Night Shift Other Benefits: 5 Days working US based work culture and environment Indoor and Outdoor events Paid Leaves Health Insurance Employee engagement activities like month end & festival celebration, team outing, birthday celebrations. Gaming and sports area Please comment/DM to know more. You may also e-mail your resume to me at priyankaaggarwal@sourcemash.com

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Google BigQuery Good to have skills : NA Minimum 12 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. Your typical day will involve collaborating with teams to develop innovative solutions and contribute to key decisions. Roles & Responsibilities: Expected to be an SME. Collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Expected to provide solutions to problems that apply across multiple teams. Lead the development and implementation of new features. Conduct code reviews and ensure coding standards are met. Troubleshoot and resolve complex technical issues. Professional & Technical Skills: Must To Have Skills: Proficiency in Google BigQuery. Strong understanding of data modeling and database design. Experience with cloud platforms like Google Cloud Platform. Knowledge of SQL and query optimization techniques. Hands-on experience in developing scalable applications. Good To Have Skills: Experience with data warehousing solutions. Additional Information: The candidate should have a minimum of 12 years of experience in Google BigQuery. This position is based at our Bengaluru office. A 15 years full-time education is required. Qualification 15 years full time education

database queries using SQL Server variants such as MySQL MSSQL or PostgreSQL Troubleshoot and resolve database related issues using JavaScript & other programming languages Maintain backup and ensure the security of databases on a regular basis

Job Title : Snowflake Developer with Oracle Golden Gate/ Data Engineer About Oracle FSGIU - Finergy: The Finergy division within Oracle FSGIU is dedicated to the Banking, Financial Services, and Insurance (BFSI) sector. We offer deep industry knowledge and expertise to address the complex financial needs of our clients. With proven methodologies that accelerate deployment and personalization tools that create loyal customers, Finergy has established itself as a leading provider of end-to-end banking solutions. Our single platform for a wide range of banking services enhances operational efficiency, and our expert consulting services ensure technology aligns with our clients' business goals Responsibilities: Snowflake Data Modeling & Architecture: Design and implement scalable Snowflake data models using best practices such as Snowflake Data Vault methodology. Real-Time Data Replication & Ingestion: Utilize Oracle GoldenGate for Big Data to manage real-time data streaming and optimize Snowpipe for automated data ingestion. Cloud Integration & Management: Work with AWS services (S3, EC2, Lambda) to integrate and manage Snowflake-based solutions. Data Sharing & Security: Implement SnowShare for data sharing and enforce security measures such as role-based access control (RBAC), data masking, and encryption. CI/CD Implementation: Develop and manage CI/CD pipelines for Snowflake deployment and data transformation processes. Collaboration & Troubleshooting: Partner with cross-functional teams to address data-related challenges and optimize performance. Documentation & Best Practices: Maintain detailed documentation for data architecture, ETL processes, and Snowflake configurations. Performance Optimization: Continuously monitor and enhance the efficiency of Snowflake queries and data pipelines. Mandatory Skills: Should have 4 years of experience as Data Engineer Strong expertise in Snowflake architecture, data modeling, and query optimization . Proficiency in SQL for writing and optimizing complex queries. Hands-on experience with Oracle GoldenGate for Big Data for real-time data replication. Knowledge of Snowpipe for automated data ingestion. Familiarity with AWS cloud services (S3, EC2, Lambda, IAM) and their integration with Snowflake. Experience with CI/CD tools (e.g., Jenkins, GitLab) for automating workflows. Working knowledge of Snowflake Data Vault methodology . Good to Have Skills: Exposure to Databricks for data processing and analytics. Knowledge of Python or Scala for data engineering tasks. Familiarity with Terraform or CloudFormation for infrastructure as code (IaC). Experience in data governance and compliance best practices . Understanding of ML and AI integration with data pipelines . Self-Test Questions: Do I have hands-on experience in designing and optimizing Snowflake data models? Can I confidently set up and manage real-time data replication using Oracle GoldenGate? Have I worked with Snowpipe to automate data ingestion processes? Am I proficient in SQL and capable of writing optimized queries in Snowflake? Do I have experience integrating Snowflake with AWS cloud services? Have I implemented CI/CD pipelines for Snowflake development? Can I troubleshoot performance issues in Snowflake and optimize queries effectively? Have I documented data engineering processes and best practices for team collaboration?

Job Title : Snowflake Developer with Oracle Golden Gate/ Data Engineer About Oracle FSGIU - Finergy: The Finergy division within Oracle FSGIU is dedicated to the Banking, Financial Services, and Insurance (BFSI) sector. We offer deep industry knowledge and expertise to address the complex financial needs of our clients. With proven methodologies that accelerate deployment and personalization tools that create loyal customers, Finergy has established itself as a leading provider of end-to-end banking solutions. Our single platform for a wide range of banking services enhances operational efficiency, and our expert consulting services ensure technology aligns with our clients' business goals Responsibilities: Snowflake Data Modeling & Architecture: Design and implement scalable Snowflake data models using best practices such as Snowflake Data Vault methodology. Real-Time Data Replication & Ingestion: Utilize Oracle GoldenGate for Big Data to manage real-time data streaming and optimize Snowpipe for automated data ingestion. Cloud Integration & Management: Work with AWS services (S3, EC2, Lambda) to integrate and manage Snowflake-based solutions. Data Sharing & Security: Implement SnowShare for data sharing and enforce security measures such as role-based access control (RBAC), data masking, and encryption. CI/CD Implementation: Develop and manage CI/CD pipelines for Snowflake deployment and data transformation processes. Collaboration & Troubleshooting: Partner with cross-functional teams to address data-related challenges and optimize performance. Documentation & Best Practices: Maintain detailed documentation for data architecture, ETL processes, and Snowflake configurations. Performance Optimization: Continuously monitor and enhance the efficiency of Snowflake queries and data pipelines. Mandatory Skills: Should have 4 years of experience as Data Engineer Strong expertise in Snowflake architecture, data modeling, and query optimization . Proficiency in SQL for writing and optimizing complex queries. Hands-on experience with Oracle GoldenGate for Big Data for real-time data replication. Knowledge of Snowpipe for automated data ingestion. Familiarity with AWS cloud services (S3, EC2, Lambda, IAM) and their integration with Snowflake. Experience with CI/CD tools (e.g., Jenkins, GitLab) for automating workflows. Working knowledge of Snowflake Data Vault methodology . Good to Have Skills: Exposure to Databricks for data processing and analytics. Knowledge of Python or Scala for data engineering tasks. Familiarity with Terraform or CloudFormation for infrastructure as code (IaC). Experience in data governance and compliance best practices . Understanding of ML and AI integration with data pipelines . Self-Test Questions: Do I have hands-on experience in designing and optimizing Snowflake data models? Can I confidently set up and manage real-time data replication using Oracle GoldenGate? Have I worked with Snowpipe to automate data ingestion processes? Am I proficient in SQL and capable of writing optimized queries in Snowflake? Do I have experience integrating Snowflake with AWS cloud services? Have I implemented CI/CD pipelines for Snowflake development? Can I troubleshoot performance issues in Snowflake and optimize queries effectively? Have I documented data engineering processes and best practices for team collaboration? Responsibilities Responsibilities: Snowflake Data Modeling & Architecture: Design and implement scalable Snowflake data models using best practices such as Snowflake Data Vault methodology. Real-Time Data Replication & Ingestion: Utilize Oracle GoldenGate for Big Data to manage real-time data streaming and optimize Snowpipe for automated data ingestion. Cloud Integration & Management: Work with AWS services (S3, EC2, Lambda) to integrate and manage Snowflake-based solutions. Data Sharing & Security: Implement SnowShare for data sharing and enforce security measures such as role-based access control (RBAC), data masking, and encryption. CI/CD Implementation: Develop and manage CI/CD pipelines for Snowflake deployment and data transformation processes. Collaboration & Troubleshooting: Partner with cross-functional teams to address data-related challenges and optimize performance. Documentation & Best Practices: Maintain detailed documentation for data architecture, ETL processes, and Snowflake configurations. Performance Optimization: Continuously monitor and enhance the efficiency of Snowflake queries and data pipelines. Qualifications Career Level - IC2

Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications. Career Level - IC2 Responsibilities Mandatory Skills: 4- 6 years of Oracle PL/SQL, PL/SQL and Oracle Database experience. Knowledge and skills in software programming in Oracle PL/SQL Experience in procedures, triggers and functions Should have design and coding experience of enterprise applications Should have experience in Code review tools like Sonar. Should have experience in writing unit testing using utPLSQL etc. Should be able to understand complex SQL queries and query optimization. Exposure to any cloud environment is preferable. Moderate experience on Unix, shell scripting Basic understanding of webservices and RESTful API Job Responsibilities Activities in Development or Implementation or Managed Service activity streams as a Technical Consultant. Your responsibilities include: 1. Perform analysis and development of application components in Oracle PL/SQL 2. Ensure quality code delivery 3. Perform unit testing for the developed code. 4. Participate in design discussion and perform module design. 5. Support SIT, UAT during testing 6. Develop programs as per specifications/requirements given by Oracle / Client within planned schedule. 7. Use defined standards/tools/processes to achieve deliverables that meet quality expectations of Oracle / Client. 8. Document all work in accordance with agreed standards/processes applicable for Oracle / Client. 9. Adhere to defined Change Control Process of Oracle / Client. Comply with Oracle / Client audit / Compliance requirements. Good to have Exposure to Banking Domain Experience in Core Java, J2EE, Webservices (Rest services) You are aware of latest technologies in Banking Customer facing experience w.r.to technical discussions Experience Experience of 4to 6 years Experience in development and / or implementation and / or support of core banking applications.

1. Performance Tuning & Troubleshooting: Must have expertise in Database performance tuning, SQL query tuning and performance optimization using AWR, ASH, and ADDM reports . Troubleshoot GoldenGate replication lag, database connectivity, and execution plan issues . Use Oracle Enterprise Manager (OEM) and OCI Monitoring tools for proactive monitoring. 2. Oracle GoldenGate (OGG) Implementation & Management: Design and implement real-time data replication using Oracle GoldenGate for heterogeneous environments . Configure Extract, Pump, and Replicate processes for both unidirectional and bidirectional replication . Monitor, troubleshoot, and optimize GoldenGate replication performance . Implement conflict detection and resolution in multi-master replication environments. 3. Oracle 23ai ATP & ADW Expertise: Deploy, configure, and optimize Oracle Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) on OCI . Implement automated performance tuning, auto-scaling, and security policies for ATP & ADW. Utilize Oracle Machine Learning (OML) features in 23ai ADW for data analytics and AI-driven insights. Ensure seamless data integration, migration, and replication between ATP, ADW, and on-prem databases . 4. Oracle Cloud Infrastructure (OCI) Database Management: Deploy and manage OCI-based database services , including DBaaS, Exadata, and Oracle Autonomous Database . Configure OCI networking, IAM roles, security groups, and database encryption . Automate database provisioning and management using Terraform, Ansible, or OCI CLI . Implement database migration strategies using OCI Data Transfer, Data Pump, or GoldenGate Cloud Service . 5. Oracle Database Engineering & Administration: Install, configure, and manage Oracle databases (19c, 21c, and 23ai ATP/ADW) in OCI environments . Perform database performance tuning, indexing, and optimization for high efficiency. Implement backup and recovery strategies using RMAN and OCI Backup Service. Ensure high availability (HA) and disaster recovery (DR) with Data Guard, Flashback, and OCI-based solutions . 6. Security & Compliance: Implement data encryption, masking, and role-based access control (RBAC) in ATP, ADW, and OCI databases. Ensure compliance with industry security standards (GDPR, HIPAA, PCI-DSS, and CIS benchmarks) . Conduct database patching, security updates, and vulnerability assessments . Required Skills & Experience: 10+ years of experience in Oracle Database Administration and Engineering . Expertise in Oracle GoldenGate (OGG) for real-time data replication . Hands-on experience with Oracle 23ai ATP (Autonomous Transaction Processing) and ADW (Autonomous Data Warehouse) . Strong knowledge of SQL, PL/SQL, query optimization, and database tuning . Experience with RMAN, Data Guard, and Oracle Enterprise Manager (OEM) . Hands-on experience with OCI-based database solutions and Terraform/Ansible for automation . Familiarity with cloud networking, security policies, and IAM roles in OCI . Preferred Qualifications: Experience with Kafka, Oracle Stream Analytics, or other real-time data streaming technologies . Knowledge of PostgreSQL, MySQL, or NoSQL databases like MongoDB, Cassandra . Hands-on experience with DevOps tools (Jenkins, Docker, Kubernetes) for database automation . Oracle Certifications (OCP, OCI Architect, or OGG Specialist) are highly desirable. Educational Qualification: Bachelors / Masters degree in Computer Science, IT, or a related field .

Role & responsibilities - Minimum of [4 years of experience in PL/SQL development with hands-on experience in writing and optimizing queries, stored procedures, functions, and triggers. Strong experience with Oracle databases (Oracle 10g/11g/12c/19c or later). Experience with data migration, ETL processes, and database integration techniques is a plus. Write efficient, optimized PL/SQL code for business logic, stored procedures, functions, triggers, and packages. Total Exp - 4- 8 years Job Location - Mumbai , Navi Mumbai , Airoli Work Mode - work from office. Notice Period - Immediate - 30 days OR Serving Notice period Please share your resume on Krupa.dhuri@cloverinfotech.com / swapna.gupta@cloverinfotech.com

We are seeking a detail-oriented and analytical Database Query Specialist to manage, maintain, and optimize database queries across our organization. The role involves writing, testing, and troubleshooting SQL queries, ensuring data integrity, and supporting cross-functional teams with accurate data extraction and reporting. The ideal candidate should have strong technical expertise in SQL and relational databases, with excellent problem-solving skills and attention to detail. Key Responsibilities: Write, optimize, and maintain complex SQL queries, stored procedures, and functions. Extract, clean, and transform data from multiple databases for reporting and analysis. Collaborate with business analysts, developers, and stakeholders to understand data requirements. Troubleshoot performance issues and optimize slow-running queries. Ensure database security, integrity, and compliance with organizational standards. Assist in database migration, upgrades, and integration projects. Create and maintain documentation for queries, reports, and database procedures. Provide ad-hoc query and reporting support for business teams. Monitor database performance and recommend improvements. Stay updated with emerging database technologies and best practices. Required Skills & Qualifications: Bachelors degree in Computer Science, Information Technology, or related field. Proven experience in SQL (MySQL, PostgreSQL, Oracle, or MS SQL Server). Strong knowledge of relational database design and normalization. Hands-on experience with query optimization and indexing techniques. Familiarity with ETL (Extract, Transform, Load) processes and reporting tools. Basic understanding of data warehousing concepts. Excellent problem-solving and analytical skills. Strong communication skills to interact with both technical and non-technical stakeholders. Perks and Benefits: Competitive Salary Package Learning & Development Career Growth Opportunities Inclusive Culture

Role & responsibilities As an Oracle PL/SQL Developer, you will be responsible for the design, development, and maintenance of Oracle database systems and objects. Your core tasks will include: Writing efficient code using SQL and PL/SQL (Procedures, Packages, Triggers, Analytical Functions). Analyzing system requirements and prioritizing development tasks. Writing clean, testable code adhering to coding standards. Developing technical specifications and architectural documentation. Testing and debugging applications and scripts. Reviewing and refactoring code for optimization and maintainability. Deploying fully functional and performance-optimized applications. Upgrading and enhancing existing Oracle programs and systems. Preferred candidate profile Required Skills and Experience: 3 to 8 years of proven experience as an Oracle PL/SQL Developer. Strong expertise in Oracle SQL and PL/SQL , including: Procedures, Functions, Packages, Triggers, Analytical Functions. Proficient in Database Design : Creating and managing schema objects: Tables, Indexes, Sequences, Synonyms, Views, etc. Good understanding of data dictionaries and metadata management. SQL Expertise: Skilled in DDL, DML, DCL, TCL commands. Writing complex queries involving joins, subqueries, set operators, grouping, and filtering. Familiar with numeric, character, date/time, and conversion functions. PL/SQL Expertise: Familiar with PL/SQL datatypes, control structures, cursors, exception handling. Use of Oracle-supplied packages and best practices. Experience working with tools like Toad or PL/SQL Developer , including environment setup and configuration.

Location: Bangalore/Hyderabad/Pune Experience level: 8+ Years About the Role We are looking for a technical and hands-on Lead Data Engineer to help drive the modernization of our data transformation workflows. We currently rely on legacy SQL scripts orchestrated via Airflow, and we are transitioning to a modular, scalable, CI/CD-driven DBT-based data platform. The ideal candidate has deep experience with DBT , modern data stack design , and has previously led similar migrations improving code quality, lineage visibility, performance, and engineering best practices. Key Responsibilities Lead the migration of legacy SQL-based ETL logic to DBT-based transformations Design and implement a scalable, modular DBT architecture (models, macros, packages) Audit and refactor legacy SQL for clarity, efficiency, and modularity Improve CI/CD pipelines for DBT: automated testing, deployment, and code quality enforcement Collaborate with data analysts, platform engineers, and business stakeholders to understand current gaps and define future data pipelines Own Airflow orchestration redesign where needed (e.g., DBT Cloud/API hooks or airflow-dbt integration) Define and enforce coding standards, review processes, and documentation practices Coach junior data engineers on DBT and SQL best practices Provide lineage and impact analysis improvements using DBTs built-in tools and metadata Must-Have Qualifications 8+ years of experience in data engineering Proven success in migrating legacy SQL to DBT , with visible results Deep understanding of DBT best practices , including model layering, Jinja templating, testing, and packages Proficient in SQL performance tuning , modular SQL design, and query optimization Experience with Airflow (Composer, MWAA), including DAG refactoring and task orchestration Hands-on experience with modern data stacks (e.g., Snowflake, BigQuery etc.) Familiarity with data testing and CI/CD for analytics workflows Strong communication and leadership skills; comfortable working cross-functionally Nice-to-Have Experience with DBT Cloud or DBT Core integrations with Airflow Familiarity with data governance and lineage tools (e.g., dbt docs, Alation) Exposure to Python (for custom Airflow operators/macros or utilities) Previous experience mentoring teams through modern data stack transitions

Chennai, India Cobol (Mainframe) BCM Industry 15/05/2025 Project description Luxoft DXC Technology Company is an established company focusing on consulting and implementation of complex projects in the financial industry. At the interface between technology and business, we convince with our know-how, well-founded methodology and pleasure in success. As a reliable partner to our renowned customers, we support them in planning, designing and implementing the desired innovations. Together with the customer, we deliver top performance! For one of our Client in the Insurance Segment, we are searching for a Senior Mainframe Developer. Responsibilities Essential Job Functions: Design and Development Mainframe batch support Resource should be comfortable with On-Call Support and Week-End Release support. Incident & Outage management Develop code for Reporting, Defect & Enhancement Hands on experience with JCL, COBOL, CICS, DB2, VSAM and mainframe utilities are mandatory. Drive the Kanban, Daily Standup, co-ordination meetings with respective stakeholders. Analytical, problem solving, creative thinking and design skills Skills Must have Strong Mainframe skills with minimum 7+ years of experience Experience in developing design, develop, test, debug, and maintain mainframe applications using COBOL programming language 3.Utilize VSAM (Virtual Storage Access Method) for efficient data access and management. 4.Interact with databases using DB2, including SQL query optimization and performance tuning. 5.Utilize tools such as File-AID for data manipulation, browsing, and editing. 6.Write and execute SQL queries using SPUFI for data retrieval and manipulation. 7.Collaborate with cross-functional teams to analyze requirements, design solutions, and implement changes. Nice to have Insurance domain experience. Other Languages EnglishC1 Advanced Seniority Senior

Project description You will be working in a cutting edge, banking environment which is now ongoing thorough upgrade program. You will be responsible for translating business data and overall data into reusable and adjustable dashboards used by senior business managers. Responsibilities Design and develop complex T-SQL queries and stored procedures for data extraction, transformation, and reporting. Build and manage ETL workflows using SSIS to support data integration across multiple sources. Create interactive dashboards and reports using Tableau and SSRS for business performance monitoring. Develop and maintain OLAP cubes using SSAS for multidimensional data analysis. Collaborate with business and data teams to understand reporting requirements and deliver scalable BI solutions. Apply strong data warehouse architecture and modeling concepts to build efficient data storage and retrieval systems. Perform performance tuning and query optimization for large datasets and improve system responsiveness. Ensure data quality, consistency, and integrity through robust validation and testing processes. Maintain documentation for data pipelines, ETL jobs, and reporting structures. Stay updated with emerging Microsoft BI technologies and best practices to continuously improve solutions. Skills Must have At least 6 years of experience with T-SQL and SQL Server (SSIS and SSRS exposure is a must. Proficient with Tableau, preferably with at least 4 years of experience creating dashboards. Experience working with businesses and delivering dashboards to senior management. Working within Data Warehouse architecture experience is a must. Exposure to Microsoft BI. Nice to have N/A Other Languages EnglishC1 Advanced Seniority Senior