QA Automation Engineer

About the Role

We are looking for a skilled SQL Server DBA with 4–5 years of experience in SQL Server database administration, performance tuning, and enterprise data integration. The ideal candidate should have hands-on experience working with Product Lifecycle Management (PLM) systems, ERP integrations, and data bridge solutions to enable seamless data exchange between enterprise applications.

Key Responsibilities

· Administer, monitor, and maintain Microsoft SQL Server databases to ensure high availability, security, and performance.

· Design, implement, and support PLM–ERP data bridge solutions for seamless integration between Product Lifecycle Management and ERP systems.

· Develop and optimize SQL queries, stored procedures, views, triggers, and database objects.

· Monitor database performance and perform query optimization, indexing, and troubleshooting.

· Design and implement database backup, recovery, disaster recovery, and high availability strategies.

· Build and maintain ETL processes and data synchronization workflows between PLM, ERP, and other enterprise applications. 

· Collaborate with application development teams to support database design and application deployments.

· Perform database migrations, upgrades, patching, and environment maintenance.

· Ensure database security, user management, and compliance with organizational standards.

· Create and maintain technical documentation, database architecture, and operational procedures. 

Required Skills & Experience

· 4–5 years of hands-on experience as a SQL Server DBA.

· Strong expertise in Microsoft SQL Server (2016/2019/2022 or later).

· Excellent knowledge of SQL, T-SQL, Stored Procedures, Functions, Triggers, Views, and Performance Tuning.

· Experience in database backup, restore, replication, indexing, and high availability (Always On, Log Shipping, Replication).

· Hands-on experience working with Product Lifecycle Management (PLM) systems.

· Experience implementing or supporting PLM–ERP data bridge/integration solutions.

· Knowledge of ERP systems such as SAP, Oracle E-Business Suite, Microsoft Dynamics, Infor, or similar platforms.

· Experience with ETL tools and enterprise data integration.

· Strong troubleshooting and root cause analysis skills. 

Preferred Skills

· Experience with Teamcenter, Windchill, Enovia, Arena PLM, or similar PLM platforms.

· Knowledge of SSIS, SSRS, and SSAS.

· Experience with PowerShell or Python scripting for database automation.

· Exposure to Azure SQL Database or cloud-based SQL environments. 

· Understanding of manufacturing, engineering, or product development processes.

· Familiarity with CI/CD and DevOps practices. 

Educational Qualification

· Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.

Key Competencies

· Strong analytical and problem-solving skills.

· Excellent communication and stakeholder management abilities.

· Ability to work independently in a remote environment.

· Strong attention to detail and commitment to database reliability and performance.

· Ability to manage multiple priorities in a fast-paced environment.

Job Description :

Job Title : Data Engineer

Location : Pune (Hybrid Work Model)

Experience Required : 4 to 8 Years

Role Overview :

We are seeking talented and driven Data Engineers to join our team in Pune. The ideal candidate will have a strong background in data engineering with expertise in Python, PySpark, and SQL. You will be responsible for designing, building, and maintaining scalable data pipelines and systems that empower our business intelligence and analytics initiatives.

Key Responsibilities:

• Develop, optimize, and maintain ETL pipelines and data workflows.
• Design and implement scalable data solutions using Python, PySpark, and SQL.
• Collaborate with cross-functional teams to gather and analyze data requirements.
• Ensure data quality, integrity, and security throughout the data lifecycle.
• Monitor and troubleshoot data pipelines to ensure reliability and performance.
• Work on hybrid data environments involving on-premise and cloud-based systems.
• Assist in the deployment and maintenance of big data solutions.

Required Skills and Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 4 to 8 Years of experience in Data Engineering or related roles.
• Proficiency in Python and PySpark for data processing and analysis.
• Strong SQL skills with experience in writing complex queries and optimizing performance.
• Familiarity with data pipeline tools and frameworks.
• Knowledge of cloud platforms such as AWS, Azure, or GCP is a plus.
• Excellent problem-solving and analytical skills.
• Strong communication and teamwork abilities.

Preferred Qualifications:

• Experience with big data technologies like Hadoop, Hive, or Spark.
• Familiarity with data visualization tools and techniques.
• Knowledge of CI/CD pipelines and DevOps practices in a data engineering context.

Work Model:

• This position follows a hybrid work model, with candidates expected to work from the Pune office as per business needs.

Why Join Us?

• Opportunity to work with cutting-edge technologies.
• Collaborative and innovative work environment.
• Competitive compensation and benefits.
• Clear career progression and growth opportunities.

Job description:

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please note: This is not a standard Big Data / Infra-heavy Data Engineering role. We are specifically looking for a SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic. Python will be your primary tool for moving and orchestrating data, but SQL and database architecture are the heart of this role.

Key Responsibilities

• Database Architecture & Schema Design: Design, implement, and maintain robust relational database schemas, ensuring optimal data modeling (OLTP and OLAP/Data Warehousing).
• Advanced Database Programmability: Write, debug, and optimize complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Performance Tuning & Indexing: Analyze query execution plans, identify bottlenecks, and implement advanced indexing strategies, partitioning, and query refactoring to ensure sub-second response times.
• Python ETL/ELT Pipelines: Develop, schedule, and maintain scalable data ingestion and transformation pipelines using Python to connect disparate data sources.
• Data Integrity & Governance: Establish constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing complex queries (CTEs, Window Functions, Analytical queries) and server-side logic (Stored Procedures/Functions) in platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep understanding of how databases work under the hood—specifically indexing (B-Tree, Hash, Clustered/Non-Clustered), execution plans, statistics, and locking/concurrency mechanisms.
• Python for Data Ingestion (3+ Years): Proficient in writing clean, modular Python scripts for data manipulation, API integration, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, Normalization (3NF), and handling Slowly Changing Dimensions (SCD).

Remote & Soft Skills

• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
• Legacy Refactoring Mindset: You enjoy opening up a massive, poorly optimized 500-line stored procedure and refactoring it for 10x performance.

Nice-to-Haves

• Experience migrating legacy on-premise stored procedures to modern cloud data warehouses (Snowflake, BigQuery, Redshift).
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Experience with dbt (data build tool).

Work Location: Remote

Job Title: Assistant Manager – Sales (Building Automation Solutions)

Location: Chennai

1. Job Overview

• Responsible for sales and business development of Building Automation Solutions (BAS) & ELV projects.
• Drive revenue growth through client acquisition, relationship management, and technical solution promotion.
• Work closely with clients, consultants, and internal teams to achieve business objectives.

2. Key Responsibilities

Sales & Business Development

• Develop and execute sales strategies for Building Automation Solutions.
• Identify and pursue new business opportunities in target industries.
• Achieve sales targets and contribute to revenue growth.

Client Engagement

• Build and maintain strong client relationships.
• Understand client requirements and propose tailored BAS/ELV solutions.
• Conduct product demonstrations, presentations, and negotiations.

Technical & Project Support

• Provide pre-sales and post-sales technical support to clients.
• Possess strong technical knowledge of BAS, HVAC, and ELV systems.
• Coordinate with project and technical teams for smooth execution.

Market Analysis & Reporting

• Monitor competitor activities, market trends, and customer feedback.
• Prepare periodic sales reports and forecasts for management review.
• Suggest improvements to strengthen market positioning.

3. Qualifications

• Bachelor’s Degree in Instrumentation / Electronics / Automation / related field.
• 8–10 years’ experience in Sales & Marketing of Building Automation Solutions / ELV / HVAC projects.
• Proven track record of project sales and target achievements.

4. Key Skills (Must-Have)

• Sales & Business Development in Building Automation Solutions / ELV projects
• Technical knowledge of BAS, HVAC, Automation Products
• Client Relationship Management
• Pre-Sales & Post-Sales Support
• Excellent Communication & Presentation skills
• Market Analysis & Negotiation

5. Additional Skills (Good-to-Have)

• Knowledge of emerging automation products and technologies.
• Ability to handle large-scale project sales independently.
• Strong networking with consultants, contractors, and system integrators.

6. Benefits

• Competitive salary with attractive incentives/commissions.
• Health insurance and employee benefits.
• Professional growth and learning opportunities.

Required Qualifications:

• 5+ years of professional software development experience.
• Post-secondary degree in computer science, software engineering or related discipline, or equivalent working experience.
• Development of distributed applications with Microsoft technologies: C# .NET/Core, SQL Server, Entity Framework.
• Deep expertise with microservices architectures and design patterns.
• Cloud Native AWS experience with services such as Lambda, SQS, RDS/Aurora, S3, Lex, and Polly.
• Mastery of both Windows and Linux environments and their use in the development and management of complex distributed systems architectures.
• Git source code repository and continuous integration tools.

Designation: eCommerce Manager (Exports)

● Location: Bandra West, Mumbai, India

● Position Type: Full-time, Permanent

Company Description

Brown Living (www.brownliving.in) is a platform focused on making Sustainable Living Easy, Accessible, and Affordable. As India's first plastic-free marketplace, we promote a sustainable and earth-friendly lifestyle. Our team curates a wide range of everyday-use products that are

ethically sourced and promote minimal waste. We support artisan groups and sustainable brands dedicated to creating a positive environmental impact. Through our platform, we are building India's largest ecosystem for sustainable living and empowering artisans, women entrepreneurs, and innovators to combat plastic pollution.

Role Description

The eCommerce Manager (Exports) will lead the expansion of Brown Living into international markets by developing and executing strategies for exporting products through various digital platforms. This role will involve setting up international fulfillment centers, managing export pricing strategies, ensuring compliance with international trade regulations, and overseeing marketing and merchandising efforts globally. The ideal candidate will be an experienced eCommerce professional with a

strong understanding of international markets, digital marketing, and brand management.

Roles and Responsibilities:

1. International Market Expansion:

a. Develop and execute a strategic plan to expand Brown Living's presence in international markets, focusing on key regions with high potential for sustainable products.

b. Identify and establish partnerships with international fulfillment centers to streamline the export process and ensure timely delivery of products.

c. Collaborate with legal and compliance teams to set up processes that

adhere to international trade regulations, customs requirements, and

other compliance standards.

2. Export Pricing Strategy:

a. Develop and execute comprehensive export pricing strategies for Brown Living's products across various digital platforms, ensuring

competitiveness while maintaining profitability.

b. Monitor global market trends, exchange rates, and competitor pricing to

adjust pricing strategies as needed.

c. Work closely with the finance team to ensure accurate pricing models that consider costs, tariffs, and logistics.

3. Brand Management & Global Messaging:

a. Manage Brown Living's brand image and messaging across all

international markets, ensuring consistency with the company's values

and mission.

b. Tailor brand messaging to resonate with different cultural contexts and

customer preferences in target markets.

c. Oversee the development of localized content, including website copy,

product descriptions, and marketing materials, in collaboration with

internal teams and external agencies.

4. Marketing Campaigns:

a. Plan and execute marketing campaigns tailored to international

audiences, with the support of internal teams and external agencies.

b. Manage campaign budgets, allocate resources effectively, and ensure

alignment with overall business objectives.

c. Track and analyze the performance of marketing campaigns, adjusting

strategies and tactics as needed to optimize results.

5. Market Research:

a. Conduct in-depth market research to understand the needs, preferences, and behaviors of international customers.

b. Use insights from market research to inform product offerings, marketing strategies, and customer engagement initiatives.

c. Identify emerging trends in sustainable consumption and incorporate

them into Brown Living's international strategies.

6. Merchandising Strategy:

a. Execute the merchandising strategy across various marketing channels

outside India, ensuring that product assortments meet the demands of

international customers.

b. Collaborate with the sourcing and product teams to curate product

collections that appeal to global markets.

c. Monitor inventory levels and product performance in international

markets, making data-driven decisions to optimize merchandising

strategies.

7. Collaboration & Coordination:

a. Coordinate with cross-functional teams, including operations, logistics,

legal, and finance, to ensure seamless execution of export strategies.

b. Work closely with external partners, such as fulfillment centers, marketing agencies, and distributors, to drive international growth.

c. Regularly report on the progress of international market expansion efforts to senior management.

Key Result Areas (KRA):

1. Market Expansion:

a. Successfully launch Brown Living's products in at least three new

international markets within the first year.

b. Establish and maintain partnerships with at least two international

fulfillment centers.

2. Export Pricing & Profitability:

a. Develop and implement export pricing strategies that achieve a minimum of 10% margin growth across international markets.

b. Maintain competitive pricing while ensuring profitability by continuously

monitoring market conditions.

3. Brand Image & Global Messaging:

a. Ensure consistent brand messaging across all international platforms with a minimum of 95% compliance with brand guidelines.

b. Achieve positive brand recognition and customer feedback in new

markets within six months of launch.

4. Marketing Campaign Performance:

a. Achieve a minimum ROI of 4:1 on international marketing campaigns.

b. Increase website traffic from international markets by 50% within the first year.

5. Market Research & Customer Insights:

a. Conduct comprehensive market research in at least five target regions

within the first six months.

b. Utilize market insights to influence product and marketing strategies,

resulting in a 20% increase in international sales.

6. Merchandising Success:

a. Implement a merchandising strategy that leads to a 30% increase in

conversion rates on international platforms.

b. Ensure optimal inventory levels, resulting in a stockout rate of less than 5% in international markets.

7. Collaboration & Team Coordination:

a. Facilitate seamless coordination among internal teams and external

partners, achieving project milestones on time and within budget.

b. Provide regular updates to senior management, demonstrating clear

progress on international market expansion goals.

This role is ideal for a strategic thinker with a passion for sustainability and a proven track record in international eCommerce. The successful candidate will play a critical role in establishing Brown Living as a global brand for sustainable living.

How to Apply:

Interested candidates can apply online via the job application form available here - https://docs.google.com/forms/d/e/1FAIpQLSdgb8MMrZX0STJb1Nt63jizdYccAxTQWbAmFAt4YcoAJBJlmg/viewform

Read More:

1. Website - https://brownliving.in/

2. About Brown Living’s Mission & Vision - https://brownliving.in/pages/about-us

3. Meet the Brown Living Team - https://brownliving.in/pages/our-team

4. Work with Us - https://brownliving.in/pages/work-with-us

5. The Brown Lens Curation Method - https://brownliving.in/pages/the-brown-lens

6. Brown Living’s Impact - https://brownliving.in/pages/our-impact-plastic-free-carbon-neutral-shopping

Full Stack Developer (Python, Javascript, HTML, API)

Job Overview

The SkillTurk Team is seeking a skilled Full Stack Developer with expertise in Python, JavaScript, HTML, and API functions to join our dynamic team. As a Full Stack Developer, you will be responsible for designing, developing, and maintaining web applications that seamlessly integrate front-end and back-end components. Your role will involve working on server-side development, utilizing your knowledge of Python, JavaScript, HTML, and API integration to deliver robust and scalable solutions.

Responsibilities:

·      Full Stack Development: Design, develop, and deploy feature-rich web applications using Python, JavaScript, HTML, and CSS technologies.

·      Front-end Development: Create responsive and intuitive user interfaces using HTML, CSS, and JavaScript frameworks, ensuring optimal user experience across different devices and browsers.

·      Back-end Development: Develop server-side logic and APIs using Python frameworks such as Django or Flask to enable smooth data flow and interaction between the front-end and the database.

·      API Integration: Understand and integrate third-party APIs and services to enhance the functionality and capabilities of web applications.

·      Database Management: Design and implement efficient database schemas, write optimized SQL queries, and ensure data integrity and security.

·      Testing and Debugging: Conduct rigorous testing and debugging to identify and fix issues, ensuring high-quality and bug-free code.

·      Collaborate with Teams: Work closely with the data engineer and stakeholders to gather requirements, provide technical insights, and ensure seamless integration of front-end and back-end components.

·      Continuous Learning: Stay up to date with industry trends, emerging technologies, and best practices in full stack development, and apply them to enhance the development process and deliver innovative solutions.

·      Troubleshooting and Issue Resolution: Identify and resolve technical issues, performance bottlenecks, and system failures, both during development and in production environments.

·      Code Maintenance and Version Control: Manage code repositories, version control systems (e.g., Git), and documentation to ensure efficient collaboration and codebase integrity.

Requirements:

·      Strong proficiency in Python programming language.

·      Proficiency in client-side web technologies including JavaScript, HTML, and CSS.

·      Experience with server-side frameworks such as Django or Flask.

·      Understanding of API design principles and experience with API integration.

·      Knowledge of database systems, SQL and the ability to write optimized queries.

·      Familiarity with version control systems like Git.

·      Solid understanding of web development principles, including responsive design, cross-browser compatibility, and accessibility.

·      Strong problem-solving and debugging skills.

·      Excellent teamwork and communication abilities.

Preferred Skills (not mandatory but beneficial):

·      Experience with cloud platforms such as AWS or Azure.

·      Understanding of Github deployments.

·      Understanding of security principles and best practices in web development.

If you are a highly motivated individual with a passion for full stack development and possess the required skills, we encourage you to apply for this position. Join our team and contribute to the creation of cutting-edge web applications that deliver seamless user experiences and drive innovation.

• Perform analysis, design and implementation of assigned projects using sound engineering principles and adhering to business standards, practices, processes, and product / program requirements
• Engage with global teams to effectively translate customer requirements to software requirements and identify potential solutions that are optimized to operate with in constraints of the product
• Troubleshoot variety of complex software problems
• Provide timely status updates and proactive communications on issues to the stakeholders.
• Able to interface with internal and external stake holders regarding software issues.
• Contribute as part of teams put together to meet overall organization initiatives/objectives
• Have the ability and willingness to acquire in-depth understanding of domain and existing products (beyond software) and apply that knowledge to develop new products and to deliver enhancements/ fixes for customer requirements.

• Bachelor of Engineering degree in Computer Science/Information Science/Electronics/Electrical/Instrumentation with appropriate experience in required skills
• C#, WinForms/Wpf
• Source control tools such as ClearCase, Git
• Methodical problem-solving skills and troubleshooting skills
• Good to Have:
• REST/SOAP, Web services, ClickOnce,
• Developing custom controls,
• Image rendering
• hands-on experience using various data structures and multi-threaded programming

RESPONSIBILITIES

• Write, execute and maintain test automation scripts using Java/Javascript – Web/API/DB.

• Experience in Agile Methodologies

• Knowledge of In-Sprint Automation

• Have working experience in Automated API Testing

• Design and implementation Experience in Test Strategy

• Write, maintain and execute regression and sanity automation test suite – per build/on demand

• Design data driven tests and fetch the data from API calls/ different Databases(Like MySQL, Oracle, Mongo)

• Attend daily scrum calls, update status

• Good to have Design and Implementation Experience in Test Automation Framework

• Good to have TDD implementation using Mocha or Jest

• Good to have Experience in IOS Automation Testing.

• Interact and collaborate with cross functional teams and understand the business requirements

• Technical Skills:

• 4+ years experience in Automation using Java/Javascript

• Should be Strong in oops concepts

• Strong Knowledge /experience in API and UI framework

• Experience in GIT, CI/CD Jobs development and implementation

• Any one of this is mandatory - TestNG,MOCHA,JEST

• Software Engineering Skills:

• Excellent problem solving and critical thinking

• Experience of In-Sprint Automation

• Take ownership of business problems and technical solutions

• Strong Communication and interpersonal skills

• Hands on with engineering excellence & continuous integration practices

• Experience with Agile and strong collaboration skills with Business and Ops

• What we value as a team:

• Scripts written for readability, performance, scale and maintainability

• Proactive in communication

• Collaborate with other members in agile ecosystem

• Out of the box thinking to resolve issues and bringing New Ideas to bringing Quality in the Applications

• Ability to suggest changes in the product with respect to user experience