Business Analyst

Bangalore / Chennai

• Hands-on data modelling for OLTP and OLAP systems
• In-depth knowledge of Conceptual, Logical and Physical data modelling
• Strong understanding of Indexing, partitioning, data sharding, with practical experience of having done the same
• Strong understanding of variables impacting database performance for near-real-time reporting and application interaction.
• Should have working experience on at least one data modelling tool, preferably DBSchema, Erwin
• Good understanding of GCP databases like AlloyDB, CloudSQL, and BigQuery.
• People with functional knowledge of the mutual fund industry will be a plus

Role & Responsibilities:

● Work with business users and other stakeholders to understand business processes.

● Ability to design and implement Dimensional and Fact tables

● Identify and implement data transformation/cleansing requirements

● Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse

● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions

● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique

● Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

● Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

● Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into reporting & analytics.

● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.

● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

● Train business end-users, IT analysts, and developers.

Required Skills:

● Bachelor’s degree in Computer Science or similar field or equivalent work experience.

● 5+ years of experience on Data Warehousing, Data Engineering or Data Integration projects.

● Expert with data warehousing concepts, strategies, and tools.

● Strong SQL background.

● Strong knowledge of relational databases like SQL Server, PostgreSQL, MySQL.

● Strong experience in GCP & Google BigQuery, Cloud SQL, Composer (Airflow), Dataflow, Dataproc, Cloud Function and GCS

● Good to have knowledge on SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).

● Knowledge of AWS and Azure Cloud is a plus.

● Experience in Informatica Power exchange for Mainframe, Salesforce, and other new-age data sources.

● Experience in integration using APIs, XML, JSONs etc.

Responsibilities : 

• Provide Voice and Remote terminal support for Level 1/2 backup and restore Issues and submit stars tickets
•  Configuration, Troubleshooting and assisting setup of backup Environment.
• Follow the Alert Management Strategy for category Level 1/2 on various system/server alerts received every day
• First and second level troubleshooting of the backup and restore issues
• Update & Maintain Pertinent technical and Operational Documentation
• Open support cases and work with vendors such as Oracle / IBM and Symantec/Iron Mountain to provide necessary logs/information on issues raised by
• Coordinate fix of H/W issues with vendors on backup servers following Hardware management processes and procedures
• Working with tape library teams on tape management
• Installation and configuration of backup software on servers and clients.
• Checking the failed backups for the day and rerunning them to meet SLA
• Setting up or Assisting in LAB/Dev machine needs for test purpose etc
• Requesting tapes from offsite location to facilitate restore
• Housekeeping of User or System Environment (Ex: work on heavy hitters and try to validate the exclude list etc)
• Work on RPO ( Recovery Point Objective ) and failure reports
• Backup policies and storage media management
• Daily operational checklists
• Notifications to a Group of Users or IT Admins mailing list
• Work on Change management windows
• Generate multiple reports and metrics as required for operations and planning
• Strive for improvement in operational and business value.

Job Opportunity:

Male or Female Security Guard at Siruseri for G4S Secure Solution Pvt Ltd

Qualification - 10th, 12th or any degree

Experience - Open to both freshers or experienced candidates

Note - Accommodation available

Hardworking Individuals with high dedication and extreme determination.· Experience in EdTech sales is a must.

Rockstar sales performers with proven track records.

Great listeners and trustworthy individuals who can bond with our potential learners. Individuals with the ability to approach any situation with patience and powerful empathy.

Individuals who take a disciplined approach towards building funnels, tracking feedback, prioritising tasks and overachieving targets and deadlines.

Should be responsible for a proper post sales system.

Sales bent of mind, to understand and effectively communicate what HeyCoach is offering to its prospective learners and achieve revenue targets.

Passion for delivering the highest levels of customer service at all times.

Grounds up build REST API automation framework using best in class open source, cloud technologies. Help build automaton first Quality culture in a fast growing product team. The ideal candidate is a self-starter and operates with a high sense of ownership.

What you will do:

• Author extensible, manageable REST API automation suite.
• Works closely with the Development team to release high quality, predictable releases. 
• Develop detailed understanding of overall product architecture, engage at design time to access Automation and Test environment impact. 
• Build Test plans, create prioritized regression suites.

Experience Range: 

You have 2 - 4 years of proven automation and quality assurance experience with any product. 

Technical Expertise:

• Strong hands on programming experience in either Java or Python.
• Deep understanding of REST APIs, have built Test Suites validating product functionalities using API automation frameworks like tavern, postman etc.
• Good to have an understanding of the AWS/Mobile App Automation. environment. ALBs, VPCs, IAM roles.
• Understanding of Docker is nice to have. 
• Good understanding of Object oriented concepts.

Java Elastic Search

• Java Microservices ELK stack(Elasticsearch, Logstash, Kibana, Beats, X-Pack, APM),
• Build Custom Reports

Java + NodeJS

• Java with Node.js- Microservices Development,
• Using graphql with node.js,
• Backend development with Node.JS

Java Microservices

• Working experience in Java and spring boot (microservices)
• Strong understanding of OOPs concepts
• Proficient in API design and development using RESTful services
• Knowledge and understanding of design principles behind building a scalable application
• Source code management using git