Tech Support Engineer - Fresher sql queries

Qualifications & Requirements:

• 4+ years of experience in C++ application development.
• Hands-on experience with C++11 or above.
• Strong knowledge of object-oriented programming and software design.
• Deep understanding of STL, multi-threading, socket programming, and data structures.
• Solid grasp of Linux development and debugging techniques.
• Proficient in using GCC, GDB, and Makefile.
• Familiarity with Valgrind and similar analysis tools.
• Experience with version control tools like Git.
• Experience writing and maintaining automated tests.
• Experience in capital markets/trading domain is a plus.

Skills:

• Strong problem-solving and analytical thinking.
• Clear and effective communication.
• Self-driven with the ability to work independently.
• Passionate about high-quality software and strong engineering practices.
• Comfortable working in a fast-paced, collaborative environment.

ROLE:  

Address technical issues relating to software implementation, function, and upgrades. Resolve customer complaints or problems and create product problem reports and troubleshoot documents for each issue. Work closely with application support and development teams to identify and resolve any technical problems that might arise during the development of software. Work with Implementation teams and Account managers to recommend solutions to new customer implementations and workflows.  

ESSENTIAL DUTIES and RESPONSIBILITIES: 

• Understanding the PeopleScout architecture and framework  
• Provide L2 support for tickets passed on by L1 support team using advanced knowledge of Java, SQL, Stored Procedures, Functions, and database development.  
• Analyze and understand Java code to debug, trace, and communicate technical issues effectively with the Development team.  
• Review application logs, perform exception analysis, monitor system performance, and identify root causes to ensure timely issue resolution and optimal application performance.
• Provide technical support to application support team
• Develop solutions to complex customer and software problems
• Assist with software design and development  
• Work within an agile environment  
• Deliver sprint commitments on time
• Be responsible for your own code, and work with others to improve the quality and deliver of theirs  
• Document troubleshooting guides and outcomes of problems, analysis and solutions for future re-use  

MUST HAVE SKILLS: 

• 5 to 8 years of experience in L2 Application Support, preferably supporting SaaS products.
• Strong troubleshooting skills with Java applications, SQL, and REST APIs.  
• Strong hands-on experience with Core Java (Java 8 or above).  
• Good understanding of Spring Boot and Java-based enterprise applications.
• Experience troubleshooting production issues, performing root cause analysis (RCA), and resolving incidents within SLA  
• Strong SQL skills with databases such as Oracle, MySQL, PostgreSQL, or SQL Server.  
• Experience working with REST APIs, JSON, and API testing tools like Postman.
• Ability to analyze application logs using tools such as Splunk, Kibana, ELK, or Grafana.
• Excellent customer communication skills with experience managing client interactions and providing timely updates.
• Familiarity with ServiceNow/Jira, Linux basics, and log analysis for application support

• A​ ​hands-on full-stack engineer​​ to join the ​​core team​​ with experience in building products from scratch into large-scale platforms and ​solving business problems leveraging new and innovative technology
• Leverage the DevOps team to ensure the product can be built, deployed, and tested across all of the release cycles from dev to production 
• Strong grasp of modern security principles and how to apply them to applications
• Work with stakeholders (product owners, project managers, and scrum masters) to define and clarify requirements.
• Hands-on development with both front-end, middle-tier, and back-end programming
• Adhere to agile development methodologies
• Experience in Node.js, Javascript and Javascript libraries, NOSQL databases, Python etc

Required Skills

• Extensive senior level full-stack software development experience with Node.js (2 or more years) with detailed understanding of user interface frameworks, back-end software architecture interactions and node module capabilities.
• Two or more years' experience with one or more JavaScript frameworks/technologies such as Express.js, Angular.js, React.js, MobX or Flux.js.
• Strong development experience with developing RESTful Web Services using Node.js.
• Comprehensive knowledge of Scrum and Kanban Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives and demos.
• Complex programming, program debugging, data analysis, problem analysis and resolution of issues within open source applications.
• Strong communication and collaborative skills in providing technical direction and hands-on software development to include design, development and testing.

Desired Skills

• Client development experience with HTML, DHTML, CSS, JavaScript
• Experience with other JavaScritpt frameworks such as Express, Restify, Hapi, Sails, JOI, and Kinex.
• Javascript experience with ECMAScript2015 (ES6), ECMAScript2016 (ES7) or Bable compiler.
• Operating System and Infrastructure experience with Linux, Windows 7, Unix, Solaris, JMS, OOD, CVS.
• Experience with VersionOne Application Lifecycle Management Tools
• Experience with Jenkins and Continuous Integration.
• Standards & Protocols knowledge including XML, XSLT, WSDL, JSON.
• Experience with Testing Tools including Mocha, Chai, Sinon, Supertest, Enzyme, Instanbul, Selenium, Load Runner, JSLint and Cucumber.
• Experience with source code versioning and Pull Requests with Git and Stash.
• Experience with IDEs such as Sublime and Atom.
• Knowledge of SonarCube, Phabricator, Gerritt, Karma, Jasmine
• Knowledge of projects using SAFe methodology.
• Experience with DevOps processes and implementation.
• Experience with environments utilizing Cloud Technologies such as Amazon Web Services.
• Experience with NGiNX web server.

• On the Job Training and support.
• Get Excellent Incentives on a regular basis.
• Saturday and Sunday fixed Weekend off.
• Growth in Career (Become a Team Lead).
• Exposure to multiple industries and the latest IT trends.

• Education: Any Graduate/ Post Graduate/ 10th/12th Pass (Preferably in IT, Computer Science)
• Good Communication - Verbal and written (English Mandatory).
• Good Attitude & Team Player.
• Speaking with professionals across the USA.
• Knowledge of MS Office (will be a plus).
• People with experience can also apply.

1. Create and maintain optimal data pipeline architecture
2. Assemble large, complex data sets that meet business requirements
3. Identifying, designing, and implementing internal process improvements including redesigning infrastructure for greater scalability, optimizing data delivery, and automating manual processes
4. Work with Data, Analytics & Tech team to extract, arrange and analyze data
5. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies
6. Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition
7. Works closely with all business units and engineering teams to develop a strategy for long-term data platform architecture.
8. Working with stakeholders including data, design, product, and executive teams, and assisting them with data-related technical issues
9. Working with stakeholders including the Executive, Product, Data, and Design teams to support their data infrastructure needs while assisting with data-related technical issues.

1. SQL
2. Ruby or Python(Ruby preferred)
3. Apache-Hadoop based analytics
4. Data warehousing
5. Data architecture
6. Schema design
7. ML

1.  Prior experience of 2 to 5 years as a Data Engineer.
2. Ability in managing and communicating data warehouse plans to internal teams.
3. Experience designing, building, and maintaining data processing systems.
4. Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions.
5. Excellent analytic skills associated with working on unstructured datasets.
6. Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata.

We are hiring!!

JOB TITLE: Lead Quality Analyst

EXPERIENCE: 7+ years

LOCATION: Bangalore

TIMINGS: Indian Shift Timings

TYPE OF WORKING: Work From the Office

NOTICE PERIOD: IMMEDIATE TO 1 MONTH

Responsibilities:

✓ Technically led and Mentor QA team of manual and automation engineers

✓ Manage QA cycle, product/feature release cycle, and commitment to deadlines

✓ Write, review, and execute manual & automation test plan

✓ Cross-functional collaboration and communication effectively

✓ Ability to work in a fast-paced start-up

Desired Skills & Experience

✓ BE/BTech in Computer Science or related technical discipline

✓ Should have experience in leading a QA team, managing QA cycle and product/feature

release cycle with a commitment to a deadline

✓ Good hands-on experience in Web based application testing and knowledge of JSON

based Restful Web Services

✓ Good hands-on experience in preparing & executing manual feature test plan

✓ Should have hand on experience in building Java/JavaScript-based UI/API automation

from scratch (Selenium, TestNG, Rest-assured, Postman)

✓ Knowledge of GIT, Bitbucket, JIRA, Linux Shell Script, and CI/CD process is a Must

✓ Knowledge of Performance/Load testing, App Sec testing will be a plus

4+ years of experience building Front end web applications

• Deep understanding of the ReactJS, Redux state container, Webpack module bundler
• Delivery of technical solutions with clean, well-tested code
• Be an active part of the engineering community team and collaborating with other developers
• You have solid experience working in an agile development environment
• Good JavaScript experience including asynchronous programming, pec closures, types, and ES6
• Demonstrable experience with RESTful APIs and JSON
• HTML 5 and CSS 3 as part of theming real-world projects
• Understanding of pre-processed CSS platforms such as Sass or Less.
• Proficiency in UI Prototyping Tools like Invision, Sketch, Adobe Experience Design etc.
• Good knowledge of responsive web design and experience with Git or other source control systems
• Knowledgeable and experienced with micro-service architecture
• Strong ability to debug code

Work as a member of a team responsible for developing a large-scale, highly available and fault-tolerant SaaS based Leasing & Asset management solution in the commercial real estate space in accordance with established processes. You will apply your knowledge of building scalable, distributed applications and have the opportunity to work with technologies & frameworks such as Ruby on Rails, NodeJS, ReactJS, Heroku, AWS, Postgres DB​

Essential Functions include but are not limited to the following. 

You will be expected to:​

• Contribute to all phases in the software lifecycle – requirements analysis, solution design, development, and deployment
• Maintain high quality standards for the work undertaken and be responsible for the quality of deliverables.
• Ensure assigned projects are developed in accordance with established engineering processes, adhering to scope, schedule constraints and agile project plans
• Guide/mentor the less experienced team members
• Participate in code reviews
• Work effectively as part of a distributed team
• Document the features worked by him/her

Key technical expertise areas expected for this role:

• Strong programming skills in Ruby with clear understanding of Object-Oriented and Functional programming. 
• Experience working with Ruby on Rails framework
• Experience on REST API Programming preferably based on a Microservices Architecture
• Good Understanding of Databases (Postgres) and proficiency in database schema designing & writing efficient SQL Queries. 
• Strong troubleshooting skills
• Demonstrable ability to learn new programming languages and frameworks quickly
• Experience with distributed systems with specific focus on security and scalability
• Experience with modern cloud technologies such as AWS

 Additional areas that would add value:

• Experience working with Cloud Service providers & platforms like AWS, Heroku 
• Strong understanding of Design Patterns & their application in system design
• Test Driven & Behavior Driven Development
• Automated Unit/Integration testing
• Using DevOps & Infrastructure tooling such as GoCD/Jenkins, Git
• Frontend web development with JavaScript frameworks like React
• Experience working on  projects, preferably in the real estate domain
• Experience working with Virtualization and Containerization technologies including Docker, Kubernetes.
• Experience working in Agile Scrum/Kanban methodologies
• Experience working with Linux and Shell scripting

Education: 

• Bachelors or Master’s in Computer Science or related fields