Cypress Automation Tester

About Us: YMGrad is a leading study abroad consultancy firm dedicated to helping students achieve their dreams of higher education abroad. We provide comprehensive services, including application assistance, university shortlisting, and expert guidance throughout the admissions process.

Job Overview: We are seeking a skilled and motivated Content Writer to join our dynamic team. This role involves crafting compelling and personalized application materials, including Statements of Purpose (SOPs), Letters of Recommendation (LORs), resumes, and other college applications. Additionally, the writer will produce SEO-friendly blogs on study-abroad topics and provide consultancy to clients about the admissions process. The ideal candidate will be adaptable, collaborative, and enthusiastic about contributing to various aspects of our consultancy services.

Key Responsibilities:

1. Application Materials: Write and edit Statements of Purpose (SOPs), Letters of Recommendation (LORs), resumes, and other application documents tailored to individual client profiles.

2. Blog Writing: Develop and publish SEO-friendly blog content on study abroad topics, including tips, trends, and country-specific information.

3. Client Consultation: Provide personalized advice to clients regarding the admissions process, application strategies, and document requirements.

4. University Shortlisting: Assist clients in shortlisting suitable universities based on their academic profile, career goals, and preferences.

5. Collaborative Support: Work closely with other team members, including advisors and counselors, to ensure a seamless and integrated service for clients.

6. Quality Assurance: Ensure all written content is error-free, adheres to client requirements, and maintains high standards of professionalism.

7. Continuous Improvement: Stay updated on changes in the study abroad landscape and admissions requirements to provide current and accurate advice.

Description of Role: 

We are looking for a career-minded professional with global perspective to join the Mumbai based Data & Analytics Group (DAG).

Key responsibilities:

As part of the Data & Analytics Group (DAG) and reporting to the Head of the India DAG locally, the individual is responsible for the following –

1.Review, analyze, and resolve data quality issues for enterprise core data in the IM Data Warehouse.

2.Coordinate with data owners and other teams to identify root-cause of data quality issues and implement solutions.

3.Coordinate the onboarding of data from various internal / external sources into the central repository.

4.Work closely with Data Owners/Owner delegates on data analysis and development data quality (DQ) rules. Work with IT on enhancing DQ controls.

5.End-to-end analysis of business processes, data flows, and data usage to improve business productivity through re-engineering and data governance.

6.Interact with business stakeholders to identify, prioritize, and address data-related needs and issues.

7.Document business requirements and use cases for data-related projects.

8.Manage change control process and participate in user acceptance testing (UAT) activities.

9.Support other DAG initiatives.

Key Skills:

1.Ability to interact with business and technology teams to understand processes and data usage.

2.Ability to do data analysis - to trace data from source to consumption.

3.Capable of working across organization and as part of a cross-functional virtual team. Ability to work and think independently, but within a team-based approach.

4.Problem solver, self-starter, ability to work through an entire issue lifecycle. Ability to effectively prioritize and multi-task.

5.Strong communication skills

Key qualifications:

1.Bachelor’s Degree required and any other relevant academic course a plus.

2.Strong domain knowledge of investment data

3.5+ years of data management, data analytics, or data governance experience in financial services

4.Experience in data analysis, exploratory analysis using SQL and formulating data quality rules.

5.Experience working with BI reporting tools like Tableau, Power BI is preferred.

6.Knowledge in coding, Python is a plus.

7.Prior experience working with Data Platforms like Aladdin, FactSet, Bloomberg, MDM platforms preferred.

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

Responsibilities:

.Approaching potential leads and closing them within a stipulated time frame.

.Create exclusive distributors, exclusive super stockists and business associates for the company towards business growth.

.Guide, coordinate and make strategic marketing plans for the sales team working under his jurisdiction.

.Finding and developing new markets and improving sales.

.Keep abreast with stock reports, inventory, product orders, re-order etc.

.Training personnel and helping team members in developing their skills.

Requirements:

.Bachelor's degree in business, marketing or a related field.

.Experience in sales, marketing or related field.

.Strong communication skills.

.Excellent organizational skills.

.Proficient in Word, Excel, Outlook, and PowerPoint.

Technical Skills Required – Mandatory:

- Cloud Technologies – AWS OR Bigdata (Basic Level)

- Python (Highly Experience Level)

- Databases – SQL (Highly Experience Level)

- Operating Systems – Unix (Highly Experience Level)

Strong knowledge in writing complex SQL queries and Knowledge of Performance Tuning

Excellent working knowledge of production support role and Strong debug/troubleshooting skills

Provide 24×7 operational support to all production practices on holidays and weekends.

Hands-on experience in production support for data engineering processes, root cause analysis, and identifying opportunities to improve existing processes.

Roles and Responsibilities:

Set up and optimize the existing integration, monitoring and alerting processes.

Working knowledge of ETL/ELT in Hadoop, Spark and MPP databases is required.

Effectively collaborate with the partners (SMEs, DBA, and Business users) to ensure the reliability of the Data systems.