Admssion counselor

Key Responsibilities:

● Analyze and translate legacy MSSQL stored procedures into Snowflake Scripting (SQL) or JavaScript-based stored procedures.

● Rebuild and optimize data pipelines and transformation logic in Snowflake.

● Implement performance-tuning techniques such as query pruning, clustering keys, appropriate warehouse sizing, and materialized views.

● Monitor query performance using the Snowflake Query Profile and resolve bottlenecks.

● Ensure procedures are idempotent, efficient, and scalable for high-volume workloads.

● Collaborate with architects and data teams to ensure accurate and performant data migration.

● Write test cases to validate functional correctness and performance.

● Document changes and follow version control best practices (e.g., Git, CI/CD).

Required Skills:

● 4+ years of SQL development experience, including strong T-SQL proficiency.

● 2+ years of hands-on experience with Snowflake, including stored procedure development.

● Deep knowledge of query optimization and performance tuning in Snowflake.

● Familiarity with Snowflake internals: automatic clustering, micro-partitioning, result caching, and warehouse scaling.

● Solid understanding of ETL/ELT processes, preferably with tools like DBT, Informatica, or Airflow.

● Experience with CI/CD pipelines and Git-based version control

Note : One face-to-face (F2F) round is mandatory, and as per the process, you will need to visit the office for this.

Upload CV On - https://magicworksitsolutions.com/digital-marketing-manager/

Job description :

A Digital Marketing Manager is responsible for developing, implementing, and managing marketing campaigns that promote a company’s products or services. 

Experience: 3 to 5 years (3 years of experience in digital marketing required)

Qualification: Any graduate or post graduate or MBA in (Marketing/Sales) or related field with an excellent understanding of Digital Marketing.

Key Responsibilities:

1. Strategy Development and Execution

• Develop Digital Marketing Strategies: Create comprehensive marketing plans to achieve business objectives.

• Campaign Management: Plan, execute, and oversee various marketing campaigns across multiple digital channels such as Google Ads, SEO, PPC, social media, email, and content marketing.

• Budget Management: Allocate and manage the marketing budget effectively to maximize ROI.

2. Content Creation and Optimization

• Content Strategy: Develop content strategies that align with marketing goals and target audience needs.

• Content Creation: Oversee the creation of engaging and relevant content for websites, blogs, social media, and email campaigns.

• SEO Optimization: Ensure all content is optimized for search engines to increase organic traffic.

3. Social Media Management

• Platform Management: Manage the companys presence on social media platforms, including content planning and posting.

• Community Engagement: Engage with followers, respond to comments and messages, and monitor online reviews and feedback.

• Social Media Advertising: Create and manage social media ad campaigns to increase brand awareness and drive conversions.

4. Analytics and Reporting

• Performance Tracking: Monitor and analyse the performance of marketing campaigns using tools like Google Analytics, social media insights, and other analytics software.

• Reporting: Prepare regular reports on campaign performance, website traffic, and other key metrics to share with stakeholders.

• Data-Driven Decisions: Use data insights to make informed decisions and optimize marketing strategies.

5. Collaboration and Coordination

• Team Collaboration: Work closely with the marketing team, including designers, writers, and other specialists, to execute campaigns.

• Cross-Departmental Coordination: Collaborate with sales, product, and other departments to align marketing efforts with overall business goals.

• External Partners: Manage relationships with external vendors, agencies, and partners as needed.

6. Customer Relationship Management (CRM)

• Database Management: Manage and utilize the company’s CRM system to track customer interactions and data.

• Lead Generation and Nurturing: Develop strategies for lead generation and nurturing to convert prospects into customers.

7. Innovation and Trend Monitoring

• Stay Updated: Keep abreast of the latest trends and best practices in digital marketing.

• Experimentation: Test new marketing techniques and strategies to improve campaign effectiveness.

8. Compliance and Ethics

• Regulatory Compliance: Ensure all marketing activities comply with relevant laws and regulations.

• Ethical Practices: Promote ethical marketing practices and maintain the company’s reputation.

Preferred candidate profile

• Must possess strong communication, presentation, and negotiation skills

• Must be familiar with analysing statistics and formulating sales data

• Must be a highly organized, detail-oriented self-starter who is willing to work independently as well as in a team environment

• Knowledge of advertising sales or sales promotions

• Knowledge of online marketing

• Minimum 3 years of experience in digital marketing environment.

• Strong understanding of Google Ads, Google Analytics, SEO, PPC, email marketing, and social media

• Excellent written and verbal communication skills

• Strong analytical and problem-solving skills

• Bachelor’s degree or Master’s degree in marketing, communications, or a related field

3 to 7 years of Overall testing experience.

 Test Automation Experience with the tool Selenium or Katalon.

 Should have experience in Test Automation Framework like TestNG and Cucumber

Framework.

 Able to manage test activities in medium to large projects.

 Demonstrates appropriate interpersonal skills required to establish effective working

relationships with clients and/or business partners.

 Should be familiar with the Software Testing tools, techniques and market trends.

 Should review user and functional requirements and provide feedback; they will

Informally test early versions of functionality and develop increasingly complete test

scripts and traceability.

 Participate in test execution and monitor the progress of execution.

 Proactively engage with all team members including developers, business users and

business analysts.

 Writes, reviews and executes formal test scripts including setup and data

requirements, procedures and expected results

 Able to provide direct input to project estimates and documentation (Project Plan

document, URS, FRS, Design docs)

 Reviews project requirements, plans and prototypes and providing input.

 Agile/ Scrum experience.

 Katalon Tool knowledge is preferable.

 Clinical domain knowledge is preferable.

Role and Responsibilities:

• Develop, implement and manage our social media strategy. Work with brand to create and implement social media strategies monthly/weekly. Oversee the creating and implementation of the monthly editorial calendar which includes monthly sales objectives and initiatives
• Define most important social media KPIs
• Manage and oversee social media content.
• Measure the success of every social media campaign. Oversee day-to-day management of campaigns and ensure brand consistency. Ensure brand consistency in copy through tone, voice and terminology
• Stay up to date with latest social media best practices and technologies – strategy and execution of ORM across company’s social media platforms.
• Use social media marketing tools
• Work with copywriters and designers to ensure content is informative and appealing
• Collaborate with Marketing, Sales and Product Development teams
• Communicate with industry professionals and influencers via social media to create a strong network
• Facilitate scaling brand and company awareness through various social media channels
• Supervise all aspects of social media interaction between customers and the company, and ensure a positive customer service experience
• Create actionable plans to both grow and maintain followers through popular social media platforms such as Twitter, Facebook, Pinterest, YouTube and LinkedIn
• Ensure progress on all platforms by using analytical tools such as Google Analytics and others

Requirement and Qualification:

• Minimum 5 years of experience as a Social Media Specialist or similar role
• Bachelor's degree in business, marketing, journalism, public relations or related field
• Social Media Strategist using social media for brand awareness and impressions
• Excellent knowledge of Facebook, Twitter, LinkedIn, Pinterest, Instagram, Google+ and other social media best practices
• Understanding of SEO and web traffic metrics
• Experience with doing audience and buyer persona research
• Good understanding of social media KPIs
• Familiarity with web design and publishing
• Excellent multitasking skills
• Great leadership skills
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal, presentation and communication skills

As a Kafka Administrator at Cargill you will work across the full set of data platform technologies spanning on-prem and SAS solutions empowering highly performant modern data centric solutions. Your work will play a critical role in enabling analytical insights and process efficiencies for Cargill’s diverse and complex business environments. You will work in a small team who shares your passion for building, configuring, and supporting platforms while sharing, learning and growing together.  

• Develop and recommend improvements to standard and moderately complex application support processes and procedures. 
• Review, analyze and prioritize incoming incident tickets and user requests. 
• Perform programming, configuration, testing and deployment of fixes or updates for application version releases. 
• Implement security processes to protect data integrity and ensure regulatory compliance. 
• Keep an open channel of communication with users and respond to standard and moderately complex application support requests and needs. 

MINIMUM QUALIFICATIONS

• 2-4 year of minimum experience
• Knowledge of Kafka cluster management, alerting/monitoring, and performance tuning
• Full ecosystem Kafka administration (kafka, zookeeper, kafka-rest, connect)
• Experience implementing Kerberos security
• Preferred:
• Experience in Linux system administration
• Authentication plugin experience such as basic, SSL, and Kerberos
• Production incident support including root cause analysis
• AWS EC2
• Terraform

• Responsible for client engagement & Manage the requirements
• Communicate with clients to identify their requirements and choice of property
• Coordinate the builder to arrange for the site visit and share the necessary information to clients
• Visit the connected properties and identify the USPs to pitch better to clients
• Manage the feedback from the client
• Understand the real estate market & comparison of the product
• Maintain good business relationship with client and builder
• Participate in seminars, conferences, and events to enhance the market & expand the business network
• Work with the team to share the responsibilities and work towards achieving team’s targets