11+ SQL Query Analyzer Jobs in Chennai | SQL Query Analyzer Job openings in Chennai

• 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.

key skills : mern

Requirements:

• Academics (10th, 12th and Bachelors) > 80%
• Highly proficient in JS (EReactJS, NodexpressJS)
• Basic knowledge of PostgreSQL/MongoDB is a plus
• Should have expertise in developing data driven, responsive, modern web applications
• Aptitude to continuously learn new languages/concepts. Breadth of knowledge is required
• Strong fundamentals in programming concepts
• Knowledge of web development concepts and databases
• A really strong passion to towards technology
• Entrepreneurial attitude

Roles and Responsibilities:

• Develop, deploy and maintain IIoT platform used by the whole of Company
• Roll out similar IoT systems across the globe
• Understanding the functional domain deeply.

• School sales : Primary responsibility is to sell to schools and bring them onboard o Tie up with schools and onboard them so that we can offer the the comapny plan to the parents in the school
  • Negotiate and get into commercial agreements with schools o Upsell our other payment products in the schools

• Stakeholder Management in Schools:
  • Enable the company to liaison with the schools tied up with, for close to everything from meeting the parents, doing events etc.
  • Forge a strong relationship with the school management and principal and be their first port of call on anything to do with finances
• Team Building- Build a high quality sales team and lead it in that city

🔎 What are we looking for?

• Self-starter with a high sense of ownership → Comfortable to work with minimal supervision and do sales independently
• Ability to drive sales and closures → Have the capability to do standalone meetings with school management and drive closures
• Hungry to learn and grow → Passion to learn & be a better version of oneself; motivated to succeed
• Bias for action → Have the temperament to experiment and execute in uncertainty
• Hustler → Ability to generate resources to solve a problem
• Intellectual honesty → Always seeking and presenting truth irrespective of personal POV or beliefs
• Mission-oriented → Deeply care about delivering value and making an impact on customer’s lives

• 3+ years of doing b2b sales
• Entrepreneurial mindset - the ability to be able to crack school deals independently and work to get tangible results without too much handholding
• Willingness to be on the ground most of the time and doing field sales
• Relevant experience of selling to schools is desirable but not a requirement

• Becoming a part of the early core team
• Competitive salary plus ESOPs
• Work with colleagues from strong backgrounds & hungry to succeed
• Opportunity to interact with and learn from high-pedigree investors & mentors - o VCs: Elevation Capital (erstwhile SAIF Partners), Matrix Partners
• o Select angel investors: Kunal Shah, Nithin Kamat, Amit Ranjan 

Responsibilities:

• Designing Hive/HCatalog data model includes creating table definitions, file formats, compression techniques for Structured & Semi-structured data processing

• Implementing Spark processing based ETL frameworks

• Implementing Big data pipeline for Data Ingestion, Storage, Processing & Consumption

• Modifying the Informatica-Teradata & Unix based data pipeline

• Enhancing the Talend-Hive/Spark & Unix based data pipelines

• Develop and Deploy Scala/Python based Spark Jobs for ETL processing

• Strong SQL & DWH concepts.

Preferred Background:

• Function as integrator between business needs and technology solutions, helping to create technology solutions to meet clients’ business needs

• Lead project efforts in defining scope, planning, executing, and reporting to stakeholders on strategic initiatives

• Understanding of EDW system of business and creating High level design document and low level implementation document

• Understanding of Big Data Lake system of business and creating High level design document and low level implementation document

• Designing Big data pipeline for Data Ingestion, Storage, Processing & Consumption

• HTML/CSS/ES6 Javascript, Java 8 and any Java based web framework
• Adobe experience Manager (AEM) Apache Sling, JCR, OSGI
• Good knowledge in Apache Sling framework
• Good knowledge in Java content repository API
• Good knowledge in Apache Jack rabbbit framework
• Knowledge of OSGI and Declarative Services
• Strong understanding of REST Principles and Hands on experience REST based API  development
•  Knowledge of Patterns and good practices to design and develop quality and clean code
• Experience in Pair programming and code reviews
• Experience with testing at all levels unit, integration, functional and performance
• Experience in Agile Project (Scrum or SAFe) execution is a must
• Familiarity with git, basic git branching strategies, working in a peer-reviewed  environment,able to code to existing patterns/styles
• Familiarity with task management, bug tracking and wiki-based documentation tools like Jiraand confluence

• AEM BE developers must have modern ES6 javascript experience as well as java developer experience
• Must be comfortable working with AEM workflows, scheduled jobs, creating/modifying jcr
• nodes via java code, and accessing REST endpoints via java code
• Ability to create custom AEM CQ components and a good exposure to both core and
•  foundation components that can be inherited in AEM
• Good understanding of AEM web development framework using Apache Sling
• Create multiple OSGI Bundles in the AEM stack based on the requirements of the Project

• Solid background and proven experience in the Java Tech Stacks
• Expertise in Java and in JavaScript based framework
• Expertise in multiple front-end languages and libraries (e.g., HTML/ CSS, JavaScript, XML, jQuery)
• Familiarity with databases (e.g., MySQL, MongoDB), web servers (e.g., Apache) and UI/UX design
• Experience developing desktop and mobile applications
• Familiarity with common stacks
• Excellent communication and teamwork skills
• Great attention to detail and problem-solving skills

• 2- 4 years’ experience in solution integration/delivering, and interfacing with customers.
  
• Hands-on experience in SQL and PL/SQL.
• Experience of working in agile teams in implementing large scale digital solutions.
• Good in programming & analytical skills
• Experience in dynamic programming language Python with Django
• Good understanding on enterprise integration, API development, and scalability
• Experience in Software Tools like: Git, Visual Studio code, Jenkins
• Solid experience in System Integration cycles, e.g., code review, source control, code
• quality
• automation scanning, bug scrub, feature testing and product release.
• Able to handle oncall support for bugs caused from delivery
• We are looking for people to co-work with us at our base location (Chennai)
• Ability to co-work with internal teams to optimise and fine tune the integration process
• and move towards a low-code integration framework

Job Description:

MySQL - DBA L3 Support

# 7 -10  years of experience in MySQL, handled multiple versions & flavors of MySQL servers both for standalone & enterprise version, Data center and VM/Cloud setup.

# Strong database Configuration and troubleshooting / problem solving skills.

# Strong knowledge of database backup and recovery concepts and practices.

# Enabling disabling scheduled Jobs on MySQL Server

# Work with Dev and DevOps engineers to ensure that all needed data is gathered and provided to them for any performance issues

# Experience in managing both on-prem DB as well as VM / cloud based DBs

# Maintenance of backups (perform backups, monitor backup, report obsolete backups)

# Maintenance of user access (creating user accounts, dropping user accounts, granting privileges)

# Maintenance of log and trace files (remove, initialize, archive them)

# Knowledge on SQL scripts

# Managing Database administration includes Daily health checks, Database tuning, Query optimization & Backup & Replication

# Experience in alert configurations using existing alerting tools or scripts