QA Engineer

Review Criteria:

• Strong Dremio / Lakehouse Data Architect profile
• 5+ years of experience in Data Architecture / Data Engineering, with minimum 3+ years hands-on in Dremio
• Strong expertise in SQL optimization, data modeling, query performance tuning, and designing analytical schemas for large-scale systems
• Deep experience with cloud object storage (S3 / ADLS / GCS) and file formats such as Parquet, Delta, Iceberg along with distributed query planning concepts
• Hands-on experience integrating data via APIs, JDBC, Delta/Parquet, object storage, and coordinating with data engineering pipelines (Airflow, DBT, Kafka, Spark, etc.)
• Proven experience designing and implementing lakehouse architecture including ingestion, curation, semantic modeling, reflections/caching optimization, and enabling governed analytics
• Strong understanding of data governance, lineage, RBAC-based access control, and enterprise security best practices
• Excellent communication skills with ability to work closely with BI, data science, and engineering teams; strong documentation discipline
• Candidates must come from enterprise data modernization, cloud-native, or analytics-driven companies

Preferred:

• Experience integrating Dremio with BI tools (Tableau, Power BI, Looker) or data catalogs (Collibra, Alation, Purview); familiarity with Snowflake, Databricks, or BigQuery environments

Role & Responsibilities:

You will be responsible for architecting, implementing, and optimizing Dremio-based data lakehouse environments integrated with cloud storage, BI, and data engineering ecosystems. The role requires a strong balance of architecture design, data modeling, query optimization, and governance enablement in large-scale analytical environments.

• Design and implement Dremio lakehouse architecture on cloud (AWS/Azure/Snowflake/Databricks ecosystem).
• Define data ingestion, curation, and semantic modeling strategies to support analytics and AI workloads.
• Optimize Dremio reflections, caching, and query performance for diverse data consumption patterns.
• Collaborate with data engineering teams to integrate data sources via APIs, JDBC, Delta/Parquet, and object storage layers (S3/ADLS).
• Establish best practices for data security, lineage, and access control aligned with enterprise governance policies.
• Support self-service analytics by enabling governed data products and semantic layers.
• Develop reusable design patterns, documentation, and standards for Dremio deployment, monitoring, and scaling.
• Work closely with BI and data science teams to ensure fast, reliable, and well-modeled access to enterprise data.

Ideal Candidate:

• Bachelor’s or Master’s in Computer Science, Information Systems, or related field.
• 5+ years in data architecture and engineering, with 3+ years in Dremio or modern lakehouse platforms.
• Strong expertise in SQL optimization, data modeling, and performance tuning within Dremio or similar query engines (Presto, Trino, Athena).
• Hands-on experience with cloud storage (S3, ADLS, GCS), Parquet/Delta/Iceberg formats, and distributed query planning.
• Knowledge of data integration tools and pipelines (Airflow, DBT, Kafka, Spark, etc.).
• Familiarity with enterprise data governance, metadata management, and role-based access control (RBAC).
• Excellent problem-solving, documentation, and stakeholder communication skills.

Preferred:

• Experience integrating Dremio with BI tools (Tableau, Power BI, Looker) and data catalogs (Collibra, Alation, Purview).
• Exposure to Snowflake, Databricks, or BigQuery environments.
• Experience in high-tech, manufacturing, or enterprise data modernization programs.

1       Customer Styling:

Assist customers in selecting outfits that align with their personal style, body type, and needs  

Offer suggestions on trends, colors, patterns, and accessories to create a cohesive look

Product Knowledge:

Maintain in-depth knowledge of the store's inventory, including new arrivals and current promotions  

  Be well-versed in fabrics, garment care, and styling options for different pieces  

.    Visual Merchandising:

   Ensure the store's presentation aligns with current trends and seasonal themes  o      Work with the team to create visually appealing displays that attract and inspire customers  

  Customer Relationship Management:

   Build lasting relationships with customers, understanding their style preferences for future recommendations  

   Follow up with regulars on upcoming launches or promotions that may interest them  

    Sales Goals:

  Drive sales by creating a seamless shopping experience and encouraging addons or complete looks  

     Meet personal and store sales targets by promoting items effectively  

Job Role- Fashion Consultant-(0-2 years)

Job Timings-Rotational

Working Days-6 Days (Weekends are working and between Mon-Fri (one day leave)

· Provide Style Advice:

Guide clients in choosing clothing and accessories that suit their body type, personal style, and occasion, while staying current with fashion trends.

· Curate and Coordinate Outfits:

Select and assemble outfits that reflect the client's preferences, brand image or seasonal trends.

· Support Sales In retail or brand settings, help drive sales by offering personalized styling services and ensuring that store visuals align with fashion trends and customer expectations.

Job Title: ELK Stack Engineer

Position Overview:

We are seeking a skilled and experienced Senior Elasticsearch Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining data pipelines using the ELK Stack (Elasticsearch 7.1 or higher, Logstash, Kibana). The Senior Elasticsearch Developer will play a key role in managing large datasets, optimizing complex queries, and maintaining self-hosted Elastic Search clusters.

Responsibilities:

• Design, develop, and maintain data pipelines using the ELK Stack.
• Handle large datasets (3 billion+ records, 100+ fields per index) with efficiency and accuracy.
• Develop and optimize complex Elasticsearch queries for efficient data retrieval and analysis.
• Manage and maintain self-hosted Elastic Search clusters.
• Implement DevOps practices, including containerization with Docker.
• Perform backups, disaster recovery, and index migrations to ensure data security and integrity.
• Execute data processing and cleaning techniques, including writing custom scripts to extract and transform data into usable formats.
• Collaborate with the engineering team to integrate Elastic Search with other systems.

Requirements:

• Bachelor's degree in Computer Science, Engineering, or related field.
• Minimum 5+ years of experience in designing, developing, and maintaining data pipelines using the ELK Stack.
• Hands-on experience handling large datasets (3 million+ records, 50+ fields per index).
• Strong proficiency in developing and optimizing complex Elasticsearch queries.
• Experience managing and maintaining self-hosted ElasticSearch clusters.
• Proficiency in DevOps practices, including containerization with Docker.
• Knowledge of security best practices, including backups, disaster recovery, and index migrations.
• Experience with database administration and data processing techniques.
• Excellent communication and teamwork skills.

Benefits:

• Competitive salary and benefits package between 20 to 35 LPA.
• Opportunities for professional development and growth.
• Collaborative and inclusive work environment.
• Flexible work hours and remote work options.

Key Responsibilities:

Brand Development

 To ensure integrated and consistent brand communications across marketing, media relations, digital

media and publications on all aspects of the company’s work.

 Significantly contributing to the development of the overall business strategy through the identification

of content trends. Completely own content strategy and execution.

 To represent Affordplan professionally across all content platforms.

Asset Development

 Contribute to Affordplan’s thought-leadership in the industry through the development of robust and

effective multi-format content aligned with wider marketing strategy and campaigns.

 Creating clear Product Messaging, including Positioning, Features & Benefits and USP’s for the

Affordplan Proposition for the website, social media, and other brand assets.

 Create newsletters and email direct mailers for intended mailing list and customer base.

 Research and curate content for digital dissemination including blog pieces, opinion pieces, medical

awareness articles, scripts for videos, e-books, guides, media releases etc.

 Creation of sales tools and training modules; including white papers, presentations, collateral, website

content and social content

 Working with the Marketing team on PR and Product Review Programs

 Working with customers to generate success stories, testimonials and other user generated content.

Skills Required

 English Proficiency (Spoken) and English Proficiency (Written)

 Good familiarity with digital channels and social media

 The Candidate should have excellent communication skills.

 Ability to take initiatives.

 Extremely comfortable in fast-paced, high-growth startup environment.

 Creative and analytical thinker; fast learner.

Eligibility Criteria

Bachelors in Journalism, Mass Communication, English from a college of repute.

• Design and develop innovative, company impacting products and services to support infrastructure operations
• Design, develop and implement object-oriented PHP applications from prototype through implementation
• Integrate open source and commercial enterprise applications into an exposed API and web-based portal
• Create highly scalable and performant REST/SOAP web services
• Keep focus on end users and goals all through the development process
• Work closely with product management and stakeholders to ensure applications meet needs and expectations
• Adhere to the highest levels of technical discipline and excellence to set a standard for the larger development organization

Requirements

• Bachelor's Degree in Computer Science, related field, or comparable extra work experience
• Solid experience with SQL and relation databases
• Solid experience with Object Oriented Design and Development
• Experience Developing API Interfaces
• Experience with version control systems, preferably Git

Beneficial Skills

• Experience with non-relational data stores such as ZooKeeper or Memcache