13+ SQL Query Analyzer Jobs in India
Apply to 13+ SQL Query Analyzer Jobs on CutShort.io. Find your next job, effortlessly. Browse SQL Query Analyzer Jobs and apply today!
Job Title: SQL Query Writer - Analytics Automation
Location: Thane (West), Mumbai
Experience: 4-5 years
Responsibilities:
- Develop and optimize SQL queries for efficient data retrieval and analysis.
- Automate analytics processes using platforms like SQL, Python, ACL, Alteryx, Analyzer, Excel Macros, and Access Query.
- Collaborate with cross-functional teams to understand analytical requirements and provide effective solutions.
- Ensure data accuracy, integrity, and security in automated processes.
- Troubleshoot and resolve issues related to analytics automation.
Qualifications:
- Minimum 3 years of experience in SQL query writing and analytics automation.
- Proficiency in SQL, Python, ACL, Alteryx, Analyzer, Excel Macros, and Access Query.
- Strong analytical skills and attention to detail.
Bachelor’s Degree in Information Technology or related field desirable.
• 5 years of Database administrator experience in Microsoft technologies
• Experience with Azure SQL in a multi-region configuration
• Azure certifications (Good to have)
• 2+ Years’ Experience in performing data migrations upgrades/modernizations, performance tuning on IaaS and PaaS Managed Instance and SQL Azure
• Experience with routine maintenance, recovery, and handling failover of a databases
Knowledge about the RDBMS e.g., Microsoft SQL Server or Azure cloud platform.
• Expertise Microsoft SQL Server on VM, Azure SQL Managed Instance, Azure SQL
• Experience in setting up and working with Azure data warehouse.
JD/Skills:-
L1 Tech Support, application support.
Good on SQL Queries.
Decent comm skills.
This will be Mumbai Location.
5 days working.
CTC is good as per market norms.
- Proficient with SQL Server/T-SQL programming in creation and optimization of complex Stored Procedures, UDF, CTE and Triggers
- Overall Experience should be between 4 to 7 years
- Experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts. Experience in SQL server, DW principles and SSIS.
- Should have strong experience in building data transformations with SSIS including importing data from files, and moving data from source to destination.
- Creating new SSIS packages or modifying existing SSIS packages using SQL server
- Debug and fine-tune SSIS processes to ensure accurate and efficient movement of data. Experience with ETL testing & data validation.
- 1+ years of experience with Azure services like Azure Data Factory, Data flow, Azure blob Storage, etc.
- 1+ years of experience with developing Azure Data Factory Objects - ADF pipeline, configuration, parameters, variables, Integration services runtime.
- Must be able to build Business Intelligence solutions in a collaborative, agile development environment.
- Reporting experience with Power BI or SSRS is a plus.
- Experience working on an Agile/Scrum team preferred.
- Proven strong problem-solving skills, troubleshooting, and root cause analysis.
- Excellent written and verbal communication skills.
JavaConcepts of RDBMS, Normalization techniques
Entity Relationship diagram/ ER-Model
Transaction, commit, rollback, ACID properties
Transaction log
Difference in behavior of the column if it is nullable
SQL Statements
Join Operations
DDL, DML, Data Modelling
Optimal Query writing - with Aggregate fn, Group By, having clause, Order by etc. Should be
hands on for scenario-based query Writing
Query optimizing technique, Indexing in depth
Understanding query plan
Batching
Locking schemes
Isolation levels
Concept of stored procedure, Cursor, trigger, View
Beginner level - PL/SQL - Procedure Function writing skill.
Spring JPA and Spring Data basics
Hibernate mappings
UNIX
Basic Concepts on Unix
Commonly used Unix Commands with their options
Combining Unix commands using Pipe Filter etc.
Vi Editor & its different modes
Basic level Scripting and basic knowledge on how to execute jar files from host
Files and directory permissions
Application based scenarios.
JavaWho We are?
At e6data (https://e6x.io/" target="_blank">https://e6data.io) we’re building core algorithms that make querying 25 - 200X more performant (i.e. faster and/or cheaper) than every other analytics platform in the world. This results in billions of dollars of value unlocked across faster analytics, savings on computing/infra, and new use cases become possible.
Our core team has 100+ years of combined experience and 10+ patents across diverse but complementary disciplines like real-time databases, time-series databases, SQL OLAP engines, distributed computing platforms, stream processing, and log analytics. Two of the founding team are second-time founders with past exits.
We are passionate about solving the deepest and most important problems in computer science and believe in making our technology available to customers regardless of their location, size, or budget. Our vision is for e6data to power every analytical workload in the world - regardless of deployment scenario (cloud, on-premise, edge), across every use case (end-user queries, ETL / data pipelines), and every latency requirement (batch, streaming / real-time).
What you will do?
- Write awesome code
- Your primary focus will be on building our product around our core algorithms. You will collaborate with our Performance Engineering and DevOps teams.
- Identify tactical and long-term product improvements (could be code, script, etc.) so that e6data development is based on frictionless onboarding of customers
- Build our internal Data Platform using e6data
- Adding scalable functionality to the core e6data engine for new features like UDFs, SQL functions, etc
What we are looking for?
- Worked with Java for a minimum of 4 years
- Knowledge of SQL Query planning will also be good to have
- A passion for continuous learning and growth (both at a personal and team level)
- Strong team player
- Experience (or enjoys) working in a startup will be an added advantag
.NET
C#We have urgent Requirement for .Net Developer with one of leading IT firm.
Experience : 5yr - 8yrs
Qualification : Computer Science, Engineering or a related field
Location : Mumbai (Thane)
Job Description :
- Required 5 to 8 years of experience
- Good knowledge of Web api development
- Required Hands on experience in Angular and .net core
- Knowledge of Authentication and authorization Hands on entity framework using C#
- Hands on SQL query and LINQ queries
- Angular 2 + working Hands-on knowledge
- Good knowledge of C# and OOP concept
FlutterSkills and Experience:
- 2 years experience on the aforementioned tech stack
- 3+ years overall mobile app development experience
- Excellent English communication skills
- Ability to work as an individual contributor as well as a team player
- Must have experience on native iOS or Android development without Flutter
- Should thoroughly know app store/play store build deployment process
- Strong knowledge of SQL queries, stored procedures, and functions
Responsibilities:
- Coding, and debugging in Flutter
- Interaction with the client to understand their requirements
- Participating in task estimation
- Collaboration with team members to ensure smooth and quality deliveries.
Role Title : VB.Net Developer
Work Experience :
- Minimum of 1 Year experience
2 . Frontend and back-end development expertise
Skills & Knowledge
- Good background with SQL Databases (writing queries, optimisation, query builders usage, ORMs)
- Troubleshooting (ability to react in the most effective manner to eliminate technical issues)
- Solution-Making (ability to propose the most effective technical solutions)
- Ability to work on existing live projects and do the modifications as required.
- Ability to work independently and in a team as well
Educational Qualification
Graduates or Undergraduate
Desired Competencies:
Ø Expertise in Azure Data Factory V2
Ø Expertise in other Azure components like Data lake Store, SQL Database, Databricks
Ø Must have working knowledge of spark programming
Ø Good exposure to Data Projects dealing with Data Design and Source to Target documentation including defining transformation rules
Ø Strong knowledge of CICD Process
Ø Experience in building power BI reports
Ø Understanding of different components like Pipelines, activities, datasets & linked services
Ø Exposure to dynamic configuration of pipelines using data sets and linked Services
Ø Experience in designing, developing and deploying pipelines to higher environments
Ø Good knowledge on File formats for flexible usage, File location Objects (SFTP, FTP, local, HDFS, ADLS, BLOB, Amazon S3 etc.)
Ø Strong knowledge in SQL queries
Ø Must have worked in full life-cycle development from functional design to deployment
Ø Should have working knowledge of GIT, SVN
Ø Good experience in establishing connection with heterogeneous sources like Hadoop, Hive, Amazon, Azure, Salesforce, SAP, HANA, API’s, various Databases etc.
Ø Should have working knowledge of different resources available in Azure like Storage Account, Synapse, Azure SQL Server, Azure Data Bricks, Azure Purview
Ø Any experience related to metadata management, data modelling, and related tools (Erwin or ER Studio or others) would be preferred
Preferred Qualifications:
Ø Bachelor's degree in Computer Science or Technology
Ø Proven success in contributing to a team-oriented environment
Ø Proven ability to work creatively and analytically in a problem-solving environment
Ø Excellent communication (written and oral) and interpersonal skills
Qualifications
BE/BTECH
KEY RESPONSIBILITIES :
|
You will join a team designing and building a data warehouse covering both relational and dimensional models, developing reports, data marts and other extracts and delivering these via SSIS, SSRS, SSAS, and PowerBI. It is seen as playing a vital role in delivering a single version of the truth on Client’s data and delivering MI & BI that will feature in enabling both operational and strategic decision making. You will be able to take responsibility for projects over the entire software lifecycle and work with minimum supervision. This would include technical analysis, design, development, and test support as well as managing the delivery to production. The initial project being resourced is around the development and implementation of a Data Warehouse and associated MI/BI functions. |
|
Principal Activities: 1. Interpret written business requirements documents 2. Specify (High Level Design and Tech Spec), code and write automated unit tests for new aspects of MI/BI Service. 3. Write clear and concise supporting documentation for deliverable items. 4. Become a member of the skilled development team willing to contribute and share experiences and learn as appropriate. 5. Review and contribute to requirements documentation. 6. Provide third line support for internally developed software. 7. Create and maintain continuous deployment pipelines. 8. Help maintain Development Team standards and principles. 9. Contribute and share learning and experiences with the greater Development team. 10. Work within the company’s approved processes, including design and service transition. 11. Collaborate with other teams and departments across the firm. 12. Be willing to travel to other offices when required. |
Location – Bangalore
PHP
Laravel• No. of Openings:- 03 Openings
• Exp:- 2+ years
• Qualification:- B.E./ MCA/ M.Sc. (I.T.)/ BCA
Job Description:-
We are looking for a PHP Developer with Laravel Experience who must be able to independently work on projects and in a team.
Desired Candidate Profile:-
• Minimum 2 years of experience
• Good Knowledge of OOPs.
• Experienced with complex SQL queries and database schema design.
• Knowledge of consuming and creating Web Services.
• MySQL and Linux understanding is a must.
• Should be strong with Web-services REST API, and JSON.
• Should have worked on a variety of projects, with experience in payment gateways, maps, graphs, etc.
• Good coding standards is a must.
• Should have experience with collaboration tools
Regards,
Vimal Patel
JavaHeadquartered in Palo Alto, CA, TIBCO Software enables businesses to reach
new heights on their path to digital distinction and innovation. From systems
to devices and people, we interconnect everything, capture data in real time
wherever it is, and augment the intelligence of organizations through analytical insights. Thousands of customers around the globe rely on us to build compelling experiences, energize operations, and propel innovation. Our teams flourish on new ideas and welcome individuals who thrive in transforming challenges into opportunities. From designing and building amazing products to providing excellent service; we encourage and are shaped by bold thinkers, problem-solvers, and self-starters. We are always adapting and providing exciting opportunities for our employees to grow, learn and excel. We value the customers and employees that define who we are; dynamic individuals willing to take the risks necessary to make big ideas come to life and who are comfortable collaborating in our creative, optimistic environment. TIBCO – we are just scratching the surface.
Who You’ll Work With:
TIBCO Data Virtualization (TDV) is an enterprise data virtualization solution that orchestrates access to multiple and varied data sources, delivering data sets and IT curated data services to any analytics solution. TDV is a Java based enterprise-grade database engine supporting all phases of data virtualization development, run-time, and management. It is the trusted solution of choice for the top enterprises in verticals like finance, energy, pharmaceutical, retail, telecom etc.
Are you interested in working on leading edge technologies? Are you fascinated with Big Data, Cloud, Federation and Data Pipelines? If you have built software frameworks and have a background in Data Technologies, Application Servers, Business Intelligence etc this opportunity is for you.
Overview
TIBCO Data Virtualization team is looking for a senior engineer to enhance
and maintain to our SQL Query Engine. You've got experience designing and
implementing complex software systems. You understand database query
engines and have a strong ability to select appropriate algorithms vis-à-vis
computational complexity and time/space trade-offs. You are intimately
familiar with design patterns and anti-patterns. You have facility with large
pre-existing code bases.
The server is implemented by a multi-million line source base in Java, so
the ability to understand and integrate with existing code is an absolute
must. The core runtime is a complex multi-threaded system and the
successful candidate will demonstrate complete expertise in handling
features geared towards concurrent transactions in a low latency, high
throughput and scalable server environment. The candidate will have the
opportunity to work in a collaborative environment with leading database
experts in building the most robust, scalable and high performing database
server.
Job Responsibilities
In this crucial role as a Query Engine Engineer, you will:
• Design and implement enhancements and optimizations to our SQL query engine capabilities and infrastructure
• Enhance the product’s robustness, flexibility, and performance
• Create and implement functional & technical specifications
• Work with minimal supervision both individually as well as within ad-hoc groups
Required Skills
• Bachelor's degree in Computer Science or equivalent experience with 3+ years experience, or 5+ years of equivalent work experience
• 4+ years of software development experience
• 3+ years of Java-based server-side experience, with significant core Java experience
• 2+ years of multi-threading experience
• 2+ years of SQL experience and/or relational algebra
• Proficiency in both spoken and written communication in English is a must
Desired Skills
• Strong object-oriented design background
• Strong SQL & database background
• Competence with design patterns and anti-patterns
• Experience with all lifecycle aspects of enterprise software
• Experience working with large, pre-existing code bases
• Experience developing cloud-based software
Python
Follow Cutshort