Professional Services Engineer

MySQL Database Developer

Strong development knowledge in DB Design & development with 6+ Years’ to 10 Years experience (MySQL DB) – Mandatory

Strong hands on writing complex PGSQL, procedure and Functions & prevent blocking and Deadlocks

Conduct SQL objects code review & Performance tuning(Mandatory)

having hands on Microsoft SQL and Postgres DB is anadvantage.

Strong knowledge in RDBMS and NoSQL Concept with strong logical thinking and solutions

Expert in transaction databases (OLTP) and ACID property with handling large scale application databases

Key Responsibilities:

 Taking ownership of customer issues reported and seeing problems through to resolution

 Understand, interpret, reproduce, and diagnose issues reported by the customers.

 Researching, troubleshooting and identifying solutions to resolve product issues

 Should be able to handle voice calls, emails and online web sessions with the customer as part of technical troubleshooting

 Should exhibit patience and empathy while working with customer with an aim to drive positive customer experience

 Following standard procedures for proper escalation of unresolved issues to the appropriate internal teams

 Following standard procedures for submitting tickets to the engineering team for further investigation of unresolved issues

 Contributing actively towards knowledge base articles

 Adherence to strict SLA’s

 Ready to work in early morning, general and afternoon shifts, including weekends, on rotation basis

 Should demonstrate an aptitude and appetite for learning newer technologies while expanding on the core knowledge

 The engineer should be available to work in the late evening shift (4pm - 1am) if required.

Primary skills:

 3-8 years of relevant experience.

 Strong technical knowledge on:

• Cloud Technologies – AWS, Azure etc.
• Databases – SQL, Oracle, MySQL etc.
• Operating Systems – Linux, Windows etc
• Networking – Basic networking concepts and troubleshooting
•  Programming knowledge – Java, Python (Desirable, not a must has) o Prior experience with REST and SOAP calls.

 Excellent communication skills – English written and verbal

 HTTP technology and principles, including REST and SOAP principles (Required)

 JSON & XML Data formats (required)  Javascript Regular Expression (Good to have)

 Good understanding of networking protocols and applications (TCP/IP, proxies, load balancing, firewalls, etc.) (Required)

 Working knowledge of database technologies and SQL (Required)

 In-depth familiarity of Linux (Required) (advanced user; sysadmin experience a bonus, but not required)

 Strong analytical and logical reasoning for technical troubleshooting

 Ability to collaborate with cross-functional teams – Dev, QA, Infrastructure teams etc.

 Should be a team player who keeps team’s success before individual achievements

 Knowledge on data integration (Informatica/ Mulesoft)

We are looking for an exceptionally talented Lead data engineer who has exposure in implementing AWS services to build data pipelines, api integration and designing data warehouse. Candidate with both hands-on and leadership capabilities will be ideal for this position.

Qualification: At least a bachelor’s degree in Science, Engineering, Applied Mathematics. Preferred Masters degree

Job Responsibilities:

• Total 6+ years of experience as a Data Engineer and 2+ years of experience in managing a team

• Have minimum 3 years of AWS Cloud experience.

• Well versed in languages such as Python, PySpark, SQL, NodeJS etc

• Has extensive experience in Spark ecosystem and has worked on both real time and batch processing

• Have experience in AWS Glue, EMR, DMS, Lambda, S3, DynamoDB, Step functions, Airflow, RDS, Aurora etc.

• Experience with modern Database systems such as Redshift, Presto, Hive etc.

• Worked on building data lakes in the past on S3 or Apache Hudi

• Solid understanding of Data Warehousing Concepts

• Good to have experience on tools such as Kafka or Kinesis

• Good to have AWS Developer Associate or Solutions Architect Associate Certification

• Have experience in managing a team

Job Description

Company Background

Workplace Fabric (WF) is focused on using Technology to create the most efficient and effective working environments. Using patented sensor technology, data analytics and innovative displays WF helps office users get the best out of their workspace while enabling a business to fully understand the utilisation of an office building.

Most customers are seeing how >20% savings can be achieved as well as creating a much improved working environment for staff and reduced service cost. The business has installations in 50 cities around the world with major blue-chip companies as customers. The business has a cash generative business model and is set for accelerated growth; a very exciting time to join a rapidly growing company.

Overview

The exciting opportunity has become available as a result of company growth and opportunities. The Technical Customer Service position will be working with a friendly professional team and the ideal candidate will provide technical support to clients located worldwide.

To provide training and support for clients who experience issues with equipment, compile clear guides for client and review data trends from the system, carry out root cause analysis when technical issues arise and provide necessary guidance to achieve resolution.

Supporting clients with their requests in relation to their Freespace products and solutions, carry out training sessions on products and analytics dashboard along with return to work solutions.

The Role

• Training clients on products, services, applications, maintenance & analytics dashboard
• Understand client requirements/issues & presents solutions as necessary
• To action ticket requests within Service Level Agreement & clearly articulate updates to clients
• Always looking at ways to improve internal systems and processes
• Prepare client quotes for additional services or products & issue invoices
• Review information and act upon findings
• To be involved in technical discussions in relation to Routers, Access Points, Wifi & Internet connectivity issues
• Interpret and manipulate data
• Prepare documentation to share with clients following site visit
• Facilitate client meetings, sharing information and training
• To understand the functionality of all the Freespace products to support client with their needs
• Carry out any reasonable ad-hoc requests

Working Hours

2: 30AM to 10:30AM IST – Monday to Friday

On call support (only for critical issues) – Alternate weekend

The Person

• Positive can-do attitude, good manner with initiative
• Technical understanding in relation PCs, Networking, Displays, Wireless
• Customer focused & excellent communication skills are essential
• Ability to make decisions, compile reports based on data analytics
• Able to work fast and solve problems under pressure at times of high workload and competing priorities
• Remain focused, composed, optimistic and flexible in difficult situations; resilient and bounces back from failures or disappointments
• Focuses on results and desired outcomes and how best to achieve them
• Comfortable working with ambiguity & to question to gain full understanding
• Displays an ongoing commitment to learning and self-improvement
• A willing and helpful person who thrives on providing support for the team to achieve their goals

Qualification/skills

• Basic knowledge of PCs, Networking, Displays, Wireless
• Validating analytics data
• Discretion with confidential client information
• 3+ years customer service experience within a technical industry
• To have an interest in the build environment or architecture
• A Financial background is desirable
• Proficient in Microsoft Excel & Word is essential
• Excellent communication skills – presentation, written and verbal
• Ability to prioritise workload and problem solve
• Good research skills and attention to detail

• Collaborate with different teams to implement standards.
• Lead performance improvement projects.
• Work closely and influence global teams for process improvements.
• Execute project milestones promptly & effectively communicate progress to stakeholders.

Technical skills:

• Strong SQL skills (RDBMS / SnowFlake).
• Able to program in multiple languages (SAS, JavaScript).
• Functional knowledge on Supply chain & Logistics.

Soft skills:

• Ability to translate business requirements into data solutions.
• Above average initiative.
• Adaptability to changing priorities.
• Strong customer focus and ability to work effectively with a wide variety of people.
• Has the ability to work independently as well as in a team.
• Eager to learn & improve, continuously hones their skills.
• Strong solution-oriented analytic skills and shows creativity in their problem-solving.
• Has great attention to detail without losing sight of the big picture.
• Has great communication skills – Is able to represent the architect team, address their needs & requirements in meetings with process partners (inside & outside of the greater team).
• Must be willing to work in different shifts to have enough overlap with global team.

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

• Developing a deep understanding of our vast data sources on the web and knowing exactly how, when, and which data to scrap, parse and store
• Working closely with Database Administrators to store data in SQL and NoSQL databases
• Developing frameworks for automating and maintaining constant flow of data from multiple sources
• Working independently with little supervision to research and test innovative solutions skills

Desired Candidate Profile

• Bachelor/ Master’s degree in Computer science/ Computer Engineering/ Information Technology
• 1 - 5 years of relevant experience
• Strong coding experience in Python (knowledge of Java, JavaScript is a plus)
• Experience with SQL and NoSQL databases
• Experience with multi-processing, multi-threading, and AWS/Azure
• Strong knowledge of scraping frameworks such as Python (Request, Beautiful Soup), Web Harvest and others
• In depth knowledge of algorithms and data structures & previous experience with web crawling is a must    

Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience

SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.

Good to have- Advantage if you have knowledge of Windows Batch Script.

• Collaborate with enterprise architects and IT program managers to enhance existing business applications and facilitate solutions to meet business requirements
• Assist in architecting technical solutions for enterprise systems using the MuleSoft product suite.
• Design patterns for building middleware systems ground up using Message Routing, Content Enrichment, Message Filtering, Message Transformation, Guaranteed delivery, Message sequencing, Batch message processing, error handling and reconciliation mechanisms.
• Knowledge of Web Services Interoperability, WS-* standards and ability to suggest, criticize and formulate solutions in a multi-vendor and architecture committee meetings.
• Identify, analyze and design integration flows using Mule ESB Anypoint Studio and technically own and manage the process of ensuring on time and on budget build and integration of the various elements of the solution
• Good understanding of integration design patterns & best practices
• In depth experience using Agile, Scrum and iterative development practices
• Assist on technical POC's to prove out technology and ultimately leading into selection.