11+ Star schema Jobs in Chennai | Star schema Job openings in Chennai

Role Overview:

The SEO Analyst is responsible for optimizing the organization’s online presence by improving search engine rankings, driving organic traffic, and enhancing user engagement. This role requires expertise in SEO strategies, analytics, and a strong understanding of mental health-related content to ensure alignment with the organization’s mission.

Key Responsibilities:

1. SEO Strategy Development and Execution:

• Develop and implement effective SEO strategies to improve website rankings and increase organic traffic.
• Conduct keyword research to identify high-value terms relevant to mental health services and integrate them into the content strategy.

1. Content Optimization:

• Collaborate with content teams to optimize on-page elements, including meta tags, headers, and keywords.
• Ensure that content adheres to SEO best practices while maintaining accuracy and sensitivity in mental health-related topics.

1. Performance Monitoring and Reporting:

• Monitor website performance using tools such as Google Analytics, Google Search Console, and other SEO software.
• Analyze data to evaluate the effectiveness of SEO efforts and provide regular reports to the marketing team.

1. Technical SEO Management:

• Conduct technical audits to identify and resolve issues affecting website performance, such as page speed, mobile usability, and broken links.
• Ensure the website is optimized for search engine crawlers and adheres to the latest algorithm updates.

1. Competitor and Market Analysis:

• Conduct competitive analysis to identify trends, opportunities, and gaps in the market.
• Research emerging SEO techniques and tools to maintain a competitive edge in the mental health sector.

1. Local SEO:

• Develop and manage local SEO strategies to enhance visibility in specific geographic areas.
• Optimize Google My Business profiles and manage location-based search strategies.

1. Collaboration and Training:

• Work closely with content creators, developers, and social media teams to align SEO initiatives with broader marketing goals.
• Provide training and guidance to team members on SEO best practices.

Qualifications and Requirements:

Education:

• Bachelor’s degree in Marketing, Computer Science, or a related field.

Experience:

• 2–5 years of experience as an SEO Analyst or in a similar role.
• Proven experience in optimizing content for the mental health or healthcare sector is mandatory.

Skills and Knowledge:

• Proficiency in SEO tools such as Google Analytics, Google Search Console, SEMrush, and Ahrefs.
• Strong understanding of technical SEO, keyword research, and link-building strategies.
• Familiarity with content management systems (e.g., WordPress).
• Knowledge of HTML, CSS, and basic coding practices is a plus.
• Excellent analytical and problem-solving skills.

Personal Attributes:

• Strong attention to detail with the ability to manage multiple projects simultaneously.
• Excellent communication and collaboration skills.
• Sensitivity and awareness when working with mental health-related content.

Key Competencies:

• Expertise in SEO strategies and best practices.
• Data-driven decision-making and performance analysis.
• Ability to adapt strategies to the unique needs of mental health-related audiences.
• Strong alignment with the organization’s mission to promote mental health awareness.

Role: Senior Content Editor

Job Type: Full-time

Exp: 4-6 yrs

Location: Ambattur, Chennai

Requirements:

Roles and responsibilities:

• Review and edit articles for grammar, spelling, punctuation, and style.
• Ensure clarity, coherence, and consistency in writing.
• Conduct meticulous final checks to catch any errors, inaccuracies, or formatting issues.
• Collaborate with writers to address feedback and make necessary revisions.
• Uphold and enforce high editorial standards to maintain the publication's credibility.
• Verify the accuracy of information, perform fact-checking, and address any discrepancies.
• Execute the final approval process for articles before publication.
• Utilize content management systems (CMS) to publish and schedule articles and multimedia content.
• Manage tight deadlines and prioritize tasks effectively to meet publishing schedules.
• Stay on top of industry trends, developments, and best practices in the crypto and blockchain space.
• Contribute insights to discussions on improving editorial processes and content quality.

Qualifications:

• Bachelor's degree in Journalism, English, Communications, or a related field.
• Proven experience as an editor in a digital media environment.
• Exceptional command of the English language, with strong writing and editing skills.
• Familiarity with the crypto and blockchain industry is a plus.
• Proficiency in using content management systems (CMS).

We are also accepting application for this profile from Content Editor and Senior Content Editor.

Let’s get started on building your path to success!

Job Title: Python Backend / GenAI Engineer (4+ Years)

Job Summary:

Looking for a Python Backend Engineer with experience in Generative AI, LangGraph workflows, data engineering, and AI evaluation using Arize AI.

Responsibilities

* Develop backend APIs using Python (FastAPI / Flask / Django)

* Build Generative AI and RAG-based applications

* Design LangGraph / agent workflows

* Create data engineering pipelines (ETL, data processing)

* Implement LLM monitoring and evaluation using Arize AI

* Integrate vector databases and AI services

* Maintain scalable and production-ready backend systems

Required Skills

* 4+ years of Python backend development

* Experience in Generative AI / LLM applications

* Knowledge of LangGraph / LangChain

* Experience in data engineering pipelines

* Familiarity with Arize AI or model evaluation tools

* Understanding of REST APIs, databases, Docker

Good to Have

* Cloud platforms (Azure / AWS )

* Vector databases (FAISS, Pinecone, Azure AI Search)

Job Title: Java Developer

Location: Chennai

Experience: 3+ Years

Employment Type: Full-time

Job Description:

We are looking for a skilled and passionate Java Developer with a strong foundation in Core Java and Object-Oriented Programming concepts. The ideal candidate should possess excellent communication skills and have hands-on experience with multi-threading, collections, databases, and backend development frameworks like Spring and Spring Boot. Exposure to cloud platforms and frontend technologies is a plus.

Key Responsibilities:

• Design, develop, and maintain scalable Java applications using Core Java and Spring Boot.
• Apply strong knowledge of Java Collections Framework and concurrent programming techniques including ExecutorService, ForkJoinPool, and other threading mechanisms.
• Optimize JVM performance and memory usage.
• Participate in all phases of the software development lifecycle: requirement gathering, design, development, testing, and deployment.
• Write clean, maintainable code following best practices, coding standards, and design patterns.
• Conduct code reviews, unit testing, and participate in peer programming.
• Collaborate effectively with team members and stakeholders to deliver high-quality solutions.
• Interact with databases like Oracle, Sybase, or SQL Server, with a strong understanding of views, triggers, indexing, and stored procedures.

Must-Have Skills:

• 3+ years of hands-on experience in Core Java
• Strong understanding of Collections, Multithreading, and Concurrency
• Proficient in Spring Framework, especially Spring Boot
• Deep understanding of Object-Oriented Design and Data Structures
• Strong experience in RDBMS (Sybase/Oracle/SQL Server) including indexing, replication, CLOB/BLOB types, views, and procedures
• Excellent written and verbal communication skills

Good to Have:

• Exposure to Microservices architecture
• Familiarity with NoSQL databases
• Knowledge or willingness to work on frontend technologies
• Experience working with public cloud platforms (AWS, Azure, GCP)

Soft Skills:

• Strong analytical and problem-solving skills
• Team player with a proactive attitude
• Ability to work independently and in a fast-paced environment

If you are passionate about Java development and want to work on cutting-edge technologies in a collaborative environment, we would love to hear from you.

Let me know if you want this converted into a company-branded format or with CTC/NP details added.

Job description

 Location: Chennai, India

 Experience: 5+ Years

 Certification: Kafka Certified (Mandatory); Additional Certifications are a Plus

Job Overview:

We are seeking an experienced DevOps Engineer specializing in GCP Cloud Infrastructure Management and Kafka Administration. The ideal candidate should have 5+ years of experience in cloud technologies, Kubernetes, and Kafka, with a mandatory Kafka certification.

Key Responsibilities:

Cloud Infrastructure Management:

· Manage and update Kubernetes (K8s) on GKE.

· Monitor and optimize K8s resources, including pods, storage, memory, and costs.

· Oversee the general monitoring and maintenance of environments using:

o OpenSearch / Kibana

o KafkaUI

o BGP

o Grafana / Prometheus

Kafka Administration:

· Manage Kafka brokers and ACLs.

· Hands-on experience in Kafka administration (preferably Confluent Kafka).

· Independently debug, optimize, and implement Kafka solutions based on developer and business needs.

Other Responsibilities:

· Perform random investigations to troubleshoot and enhance infrastructure.

· Manage PostgreSQL databases efficiently.

· Administer Jenkins pipelines, supporting CI/CD implementation and maintenance.

Required Skills & Qualifications:

· Kafka Certified Engineer (Mandatory).

· 5+ years of experience in GCP DevOps, Cloud Infrastructure, and Kafka Administration.

· Strong expertise in Kubernetes (K8s), Google Kubernetes Engine (GKE), and cloud environments.

· Hands-on experience with monitoring tools like Grafana, Prometheus, OpenSearch, and Kibana.

· Experience managing PostgreSQL databases.

· Proficiency in Jenkins pipeline administration.

· Ability to work independently and collaborate with developers and business stakeholders.

If you are passionate about DevOps, Cloud Infrastructure, and Kafka, and meet the above qualifications, we encourage you to apply!

Role Summary

As a Data Engineer, you will be an integral part of our Data Engineering team supporting an event-driven server less data engineering pipeline on AWS cloud, responsible for assisting in the end-to-end analysis, development & maintenance of data pipelines and systems (DataOps). You will work closely with fellow data engineers & production support to ensure the availability and reliability of data for analytics and business intelligence purposes.

Requirements:

·      Around 4 years of working experience in data warehousing / BI system.

·      Strong hands-on experience with Snowflake AND strong programming skills in Python

·      Strong hands-on SQL skills

·      Knowledge with any of the cloud databases such as Snowflake,Redshift,Google BigQuery,RDS,etc.

·      Knowledge on debt for cloud databases

·      AWS Services such as SNS, SQS, ECS, Docker, Kinesis & Lambda functions

·      Solid understanding of ETL processes, and data warehousing concepts

·      Familiarity with version control systems (e.g., Git/bit bucket, etc.) and collaborative development practices in an agile framework

·      Experience with scrum methodologies

·      Infrastructure build tools such as CFT / Terraform is a plus.

·      Knowledge on Denodo, data cataloguing tools & data quality mechanisms is a plus.

·      Strong team player with good communication skills.

Overview Optisol Business Solutions

OptiSol was named on this year's Best Companies to Work for list by Great place to work. We are a team of about 500+ Agile employees with a development center in India and global offices in the US, UK (United Kingdom), Australia, Ireland, Sweden, and Dubai. 16+ years of joyful journey and we have built about 500+ digital solutions. We have 200+ happy and satisfied clients across 24 countries.

Benefits, working with Optisol

·      Great Learning & Development program

·      Flextime, Work-at-Home & Hybrid Options

·      A knowledgeable, high-achieving, experienced & fun team.

·      Spot Awards & Recognition.

·      The chance to be a part of next success story.

·      A competitive base salary.

More Than Just a Job, We Offer an Opportunity To Grow. Are you the one, who looks out to Build your Future & Build your Dream? We have the Job for you, to make your dream comes true.

• Partnering with internal business owners (product, marketing, edit, etc.) to understand needs and develop custom analysis to optimize for user engagement and retention
• Good understanding of the underlying business and workings of cross functional teams for successful execution
• Design and develop analyses based on business requirement needs and challenges.
• Leveraging statistical analysis on consumer research and data mining projects, including segmentation, clustering, factor analysis, multivariate regression, predictive modeling, etc.
• Providing statistical analysis on custom research projects and consult on A/B testing and other statistical analysis as needed. Other reports and custom analysis as required.
• Identify and use appropriate investigative and analytical technologies to interpret and verify results.
• Apply and learn a wide variety of tools and languages to achieve results
• Use best practices to develop statistical and/ or machine learning techniques to build models that address business needs.

• 2 - 4 years  of relevant experience in Data science.
• Preferred education: Bachelor's degree in a technical field or equivalent experience.
• Experience in advanced analytics, model building, statistical modeling, optimization, and machine learning algorithms.
• Machine Learning Algorithms: Crystal clear understanding, coding, implementation, error analysis, model tuning knowledge on Linear Regression, Logistic Regression, SVM, shallow Neural Networks, clustering, Decision Trees, Random forest, XGBoost, Recommender Systems, ARIMA and Anomaly Detection. Feature selection, hyper parameters tuning, model selection and error analysis, boosting and ensemble methods.
• Strong with programming languages like Python and data processing using SQL or equivalent and ability to experiment with newer open source tools.
• Experience in normalizing data to ensure it is homogeneous and consistently formatted to enable sorting, query and analysis.
• Experience designing, developing, implementing and maintaining a database and programs to manage data analysis efforts.
• Experience with big data and cloud computing viz. Spark, Hadoop (MapReduce, PIG, HIVE).
• Experience in risk and credit score domains preferred.

• Minimum 2 years of experience in Core PHP , and hands on experience in any MVC Framework. 
• Should have hands on experience or knowledge in PHP Frameworks like Codeigniter/ Laravel/ CakePHP/ Yii . 
• Should have knowledge about OOPS Concept. 
• Good knowledge in HTML, AJAX, JQuery & MYSQL.
• Minimum 2 years of experience in Core PHP , and hands on experience in any MVC Framework. 
• Should have hands on experience or knowledge in PHP Frameworks like Codeigniter/ Laravel/ CakePHP/ Yii . 
• Should have knowledge about OOPS Concept. 
• Good knowledge in HTML, AJAX, JQuery & MYSQL.