4 Subquery Jobs

Job Description Summary The role entails advanced software development for Power Systems Applications, with a focus on delivering specific functionalities to meet corporate project and product objectives. As a Staff Software Engineer as Database developer/expert, you will contribute and lead advanced development in MMS Application software design, development, testing, integration and tuning to meet project and/or product commitments. Projects’ main deliverable is an overall customized system that’s based on GE’s next generation Market System, a cloud-based solution that hosts multi-state wholesale energy markets. End user customers are Electric Utilities, Independent System Operators (ISOs) and Transmission System Operators (TSOs). These markets are key to decarbonizing our power system by ensuring reliability while allowing increasing penetration of Solar, Wind and Storage technologies. Job Description Roles and Responsibilities As a senior member of the Software Center of Excellence, exemplifying high-quality design, development, testing, and delivery practices. Develop and evolve software in a dynamic and agile environment using the latest technologies and infrastructure. Experience in Oracle 12c or higher (19c desired). Experience programming with PL/SQL (min 6 years) Experience with advanced PL/SQL features including advanced queues, triggers, types, functions, reference cursors, pipeline functions, subquery factoring clauses Experience with built-in Oracle packages such as DBMS_SCHEDULER. Experience with both ANSI and Oracle join syntax. Understanding of programing changes needed for RAC vs non-RAC implementations. Ability to diagnose and remediate SQL performance issues. Ability to translate requirements into functional designs. Ability to implement code solutions from functional designs. Ability to work independently as well as with a remote team. Experience with tools such as GIT, TFS, Toad for Oracle. Provide budget estimates for new project tasks to project leads and managers. Collaborate with customers throughout the project lifecycle to ensure software quality and functionality meet standards and requirements. Mentor junior team members. Interact with Product Development Teams, Customers, Solution Providers, and cross-functional teams as needed. Apply SDLC principles and methodologies like Lean/Agile/XP, CI, software and product security, scalability, and testing techniques. Writes code that meets standards and delivers desired functionality using the technology selected for the project. Build features such as web services and Queries on existing tables. Understand performance parameters and assess application performance Basic Qualification Master’s or Bachelor’s degree in Computer Science or Electrical Engg./Power Systems 8 to 11 years of experience in Oracle development in an on-prem or cloud-based enterprise environment Desired Characteristics Able to work well with global teams, including time-zone flexibility Highly organized and efficient; adept at prioritizing and executing tasks. Experience working on software projects in the Energy domain (especially Bulk Power Energy Management) Skilled in breaking down problems, documenting problem statements and estimating efforts Continuously measures the completion rate of personal deliverables and compares them to the scheduled commitments. Transparent in problem-solving approaches and options; determines fair outcomes with shared trade-offs. Effective communication style for engaging with customers and cross-functional teams; utilizes product knowledge to mitigate risks and drive outcomes. Strong verbal, written, and interpersonal communication skills; able to produce professional and technical reports and conduct presentations. Additional Information Relocation Assistance Provided: Yes

Customer Success at Innovaccer Our mission is to turn our customers into tech-savvy superheroes, ensuring they achieve success using our platform to meet their organization’s business goals. If you're passionate about helping customers realize the value they seek with technology, then our customer success team is the right place for you. A Day in the Life Implement, develop, automate, and unit-test business processes between various data repositories and systems. Work with the Delivery team to help them integrate the Python code into their workflows and automate the entire data journey. Implement Python libraries to automate the data ingestion lifecycle and improve code reusability Troubleshoot data issues and perform root cause analysis to resolve operational issues proactively Establish best practices around software development in the development team. Developing programs to consume externally hosted open APIs Analyze and improve the performance, scalability, stability, and security of the code. Improve engineering standards, tooling, and processes Participate in the full SDLC process using Agile methodology, including discovery, inception, story and task creation, breakdown and estimation, iterative planning, development and unit testing, and release/deployment. Support production environments with any bugs or execution failures Work with business leaders and customers to understand their pain points and build large-scale solutions for them Managing and coordinating with multiple teams across Innovaccer to deliver solutions What You Need Hands-on experience in Python (OOPs development), SQL(JOINs, Aggregation, Filtration, Subquery, Grouping, Windows Function, Common Table Expressions) and Linux. Working knowledge of Python libraries like Pandas, NumPy, Selenium, ElasticSearch, psycopg2, Snowflake, Boto3, requests, urllib3, sqlalchemy and pymongo. Experience in scaling Python codes for multiple integration touch points and consuming open APIs using Python. Experience in RDBMS & NoSQL databases Experience with Git Good experience in current transformation technologies such as XML, JSON, CSV and SQL Strong knowledge of agile methodologies Basic Analytics Tools (Power BI or Tableau) knowledge An ambitious person who can work in a flexible startup environment with only one thing in mind - getting things done. Excellent written and verbal communication skills. Here’s What We Offer Generous Leave Benefits : Enjoy generous leave benefits of up to 40 days. Parental Leave : Experience one of the industry's best parental leave policies to spend time with your new addition. Sabbatical Leave Policy : Want to focus on skill development, pursue an academic career, or just take a break? We've got you covered. Health Insurance : We offer health benefits and insurance to you and your family for medically related expenses related to illness, disease, or injury. Innovaccer is an equal-opportunity employer. We celebrate diversity, and we are committed to fostering an inclusive and diverse workplace where all employees, regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, marital status, or veteran status, feel valued and empowered. Disclaimer : Innovaccer does not charge fees or require payment from individuals or agencies for securing employment with us. We do not guarantee job spots or engage in any financial transactions related to employment. If you encounter any posts or requests asking for payment or personal information, we strongly advise you to report them immediately to our HR department at px@innovaccer.com. Additionally, please exercise caution and verify the authenticity of any requests before disclosing personal and confidential information, including bank account details.

Customer Success at Innovaccer Our mission is to turn our customers into tech-savvy superheroes, ensuring they achieve success using our platform to meet their organization's business goals. If you're passionate about helping customers realize the value they seek with technology, then our customer success team is the right place for you. A Day in the Life Implement, develop, automate, and unit-test business processes between various data repositories and systems. Work with the Delivery team to help them integrate the Python code into their workflows and automate the entire data journey. Implement Python libraries to automate the data ingestion lifecycle and improve code reusability Troubleshoot data issues and perform root cause analysis to resolve operational issues proactively Establish best practices around software development in the development team. Developing programs to consume externally hosted open APIs Analyze and improve the performance, scalability, stability, and security of the code. Improve engineering standards, tooling, and processes Participate in the full SDLC process using Agile methodology, including discovery, inception, story and task creation, breakdown and estimation, iterative planning, development and unit testing, and release/deployment. Support production environments with any bugs or execution failures Work with business leaders and customers to understand their pain points and build large-scale solutions for them Managing and coordinating with multiple teams across Innovaccer to deliver solutions What You Need Hands-on experience in Python (OOPs development), SQL(JOINs, Aggregation, Filtration, Subquery, Grouping, Windows Function, Common Table Expressions) and Linux. Working knowledge of Python libraries like Pandas, NumPy, Selenium, ElasticSearch, psycopg2, Snowflake, Boto3, requests, urllib3, sqlalchemy and pymongo Experience in scaling Python codes for multiple integration touch points and consuming open APIs using Python Experience in RDBMS & NoSQL databases Experience with Git Good experience in current transformation technologies such as XML, JSON, CSV and SQL Strong knowledge of agile methodologies Basic Analytics Tools (Power BI or Tableau) knowledge An ambitious person who can work in a flexible startup environment with only one thing in mind - getting things done Excellent written and verbal communication skills Here's What We Offer Generous Leave Benefits: Enjoy generous leave benefits of up to 40 days Parental Leave: Experience one of the industry's best parental leave policies to spend time with your new addition Sabbatical Leave Policy: Want to focus on skill development, pursue an academic career, or just take a break? We've got you covered Health Insurance: We offer health benefits and insurance to you and your family for medically related expenses related to illness, disease, or injury Innovaccer is an equal-opportunity employer. We celebrate diversity, and we are committed to fostering an inclusive and diverse workplace where all employees, regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, marital status, or veteran status, feel valued and empowered. Disclaimer : Innovaccer does not charge fees or require payment from individuals or agencies for securing employment with us. We do not guarantee job spots or engage in any financial transactions related to employment. If you encounter any posts or requests asking for payment or personal information, we strongly advise you to report them immediately to our HR department at px@innovaccer.com. Additionally, please exercise caution and verify the authenticity of any requests before disclosing personal and confidential information, including bank account details. Show more Show less

Current JD – Data Quality Engineer (Role). Ready to work as DQE. Location – Pune/Chennai Experience in Python /Java programming required to automate data analysis tasks - Must have Experience in writing Advance SQL queries (Topics listed below) - Must have Knowledge of BDD and Cucumber - Good to have Knowledge of Agile methodologies, CI/CD etc. - Good to have Hands on Functional Data / ETL Testing Experience - Good to have Advanced SQL topics delve into more complex database operations and query optimization techniques. Here are some key areas to explore: Window Functions  RANK, DENSE_RANK, ROW_NUMBER: Assign a rank to each row within a partition.  LEAD, LAG: Access rows preceding or following the current row within a partition.  PARTITION BY, ORDER BY: Define partitions and the order within each partition.  Window frames: Specify the range of rows included in a window function calculation. Common Table Expressions (CTEs)  Recursive CTEs: Create recursive queries to process hierarchical data.  Multiple CTEs: Use multiple CTEs to break down complex queries into smaller, more manageable parts. Subqueries  Correlated subqueries: Subqueries that reference columns from the outer query.  Scalar subqueries: Subqueries that return a single value.  EXISTS and NOT EXISTS: Test for the existence or non-existence of rows in a subquery. Analytical Functions  CUME_DIST: Calculate the cumulative distribution of a value within a group.  PERCENT_RANK: Calculate the percentile rank of a value within a group.  NTILE: Divide a result set into a specified number of groups. Full-Text Search  Full-text indexes: Create indexes that support full-text search capabilities.  Ranking functions: Rank search results based on relevance.  Stop words: Exclude common words from search queries. Hierarchical Queries  CONNECT BY PRIOR: Traverse hierarchical relationships in a table.  START WITH: Specify the starting point for a hierarchical query. Optimization Techniques  Indexes: Create appropriate indexes to improve query performance.  Query tuning: Analyze query execution plans and optimize queries.  Materialized views: Pre-calculate and store query results for faster access. Show more Show less