3 Subquery Jobs

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