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

Tech Stack: Power BI, DAX, SQL, Microsoft Fabric

The Role

You are the bridge between raw data and business decisions.You will be responsible for taking processed data and transforming it into high-performance, scalable semantic models. Your goal is to ensure that the data is structured so perfectly that building a report becomes the easiest part of the job.

Key Responsibilities

• Semantic Architecture: Design and build Star Schemas that serve as the single source of truth.
• Gold Layer Ownership: Transform Silver-layer tables into business-ready dimensions and facts.
• Advanced DAX: Write clean, optimized DAX for complex business logic (not just basic sums).
• Visual Storytelling: Build intuitive Power BI reports that focus on clarity and actionable insights.
• Performance Tuning: Optimize models for fast load times, query folding, and efficient refreshes.
• Stakeholder Sync: Work with clients to define KPIs and ensure the model actually answers their questions.

What We’re Looking For

• Modeling DNA: You think in Star Schemas and understand why a flat table is a bad idea for Power BI.
• DAX Proficiency: Deep understanding of Filter vs. Row context and time-intelligence functions.
• SQL Fluency: You can write complex queries to validate your models against the source data.
• Visual Logic: You have a sharp eye for UI/UX—no cluttered dashboards or "chart junk."
• Fabric Familiarity: Experience with (or a strong desire to learn) the Microsoft Fabric ecosystem.

Why Work With Us?

• Microsoft Partner Edge: Hands-on with the latest Fabric and Power BI features before they go mainstream.
• Flat Hierarchy
• Technical Autonomy: You own the Gold layer architecture; you set the modeling standards.
• High-Stakes Projects: Solve real data problems for enterprise clients in Healthcare and Government.
• Career Growth: Structured learning paths to master the wider Azure Data & AI stack.
• Competitive Pay
• Flexible Hours

Role: React Developer

Location: Pune

Experience Range: 3–4 years (Mandatory)

Experience Required:

• Strong experience in JavaScript / TypeScript, modern JS concepts, frameworks, and libraries
• Hands-on experience with React.js, including async programming concepts
• Solid experience building production-grade mobile applications using React Native
• Strong state management expertise, including:
• Redux / Redux Toolkit
• Context API
• Other relevant state management libraries or patterns

Job Title: Sr. ETL Test Engineer

Experience: 7+ Years

Location: Gurgaon / Noida / Pune (Work From Office)

Joining: Immediate joiners only (≤15 days notice)

About the Role

We are seeking an experienced ETL Test Engineer with strong expertise in cloud-based ETL tools, Azure ecosystem, and advanced SQL skills. The ideal candidate will have a proven track record in validating complex data pipelines, ensuring data integrity, and collaborating with cross-functional teams in an Agile environment.

Key Responsibilities

• Design, develop, and execute ETL test plans, test cases, and test scripts for cloud-based data pipelines.
• Perform data validation, transformation, and reconciliation between source and target systems.
• Work extensively with Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, and related Azure services.
• Develop and run complex SQL queries for data extraction, analysis, and validation.
• Collaborate with developers, business analysts, and product owners to clarify requirements and ensure comprehensive test coverage.
• Perform regression, functional, and performance testing of ETL processes.
• Identify defects, log them, and work with development teams to ensure timely resolution.
• Participate in Agile ceremonies (daily stand-ups, sprint planning, retrospectives) and contribute to continuous improvement.
• Ensure adherence to data quality and compliance standards.

Required Skills & Experience

• 5+ years of experience in ETL testing, preferably with cloud-based ETL tools.
• Strong hands-on experience with Azure Data Factory, Azure Synapse Analytics, and Azure SQL.
• Advanced SQL query writing and performance tuning skills.
• Strong understanding of data warehousing concepts, data models, and data governance.
• Experience with Agile methodologies and working in a Scrum team.
• Excellent communication and stakeholder management skills.
• Strong problem-solving skills and attention to detail.

Preferred Skills

• Experience with Python, PySpark, or automation frameworks for ETL testing.
• Exposure to CI/CD pipelines in Azure DevOps or similar tools.
• Knowledge of data security, compliance, and privacy regulations.

Lead Data Engineer

What are we looking for

real solver?

Solver? Absolutely. But not the usual kind. We're searching for the architects of the audacious & the pioneers of the possible. If you're the type to dismantle assumptions, re-engineer ‘best practices,’ and build solutions that make the future possible NOW, then you're speaking our language.

Your Responsibilities

What you will wake up to solve.

• Lead Technical Design & Data Architecture: Architect and lead the end-to-end development of scalable, cloud-native data platforms. You’ll guide the squad on critical architectural decisions—choosing between Batch vs. Streaming or ETL vs. ELT—while remaining 100% hands-on, contributing high-quality, production-grade code.
• Build High-Velocity Data Pipelines: Drive the implementation of robust data transports and ingestion frameworks using Python, SQL, and Spark. You will build integration layers that connect heterogeneous sources (SaaS, RDBMS, NoSQL) into unified, high-availability environments like BigQuery, Snowflake, or Redshift.
• Mentor & Elevate the Squad: Foster a culture of technical excellence by mentoring and inspiring a team of data analysts and engineers. Lead deep-dive code reviews, promote best-practice data modeling (Star/Snowflake schema), and ensure the squad adopts modern engineering standards like CI/CD for data.
• Drive AI-Ready Data Strategy: Be the expert in designing data foundations optimized for AI and Machine Learning. You will champion the use of GCP (Dataflow, Pub/Sub, BigQuery) and AWS (Lambda, Glue, EMR) to create "clean room" environments that fuel advanced analytics and generative AI models.
• Partner with Clients as a Technical DRI: Act as the Directly Responsible Individual for client success. Translate ambiguous business questions into elegant data services, manage project deliverables using Agile methodologies, and ensure that the data provided is accurate, consistent, and mission-critical.
• Troubleshoot & Optimize for Scale: Own the reliability of the reporting layer. You will proactively monitor pipelines, troubleshoot complex transformation bottlenecks, and propose ways to improve platform performance and cost-efficiency.
• Innovate and Build Reusable IP: Spearhead the creation of reusable data frameworks, custom operators, and transformation libraries that accelerate future projects and establish Searce’s unique technical advantage in the market.

Welcome to Searce

The AI-Native tech consultancy that's rewriting the rules.

Searce is an AI-native, engineering-led, modern tech consultancy that empowers clients to futurify their business by delivering intelligent, impactful, real business outcomes. Searce solvers co-innovate with clients as their trusted transformational partners ensuring sustained competitive advantage. Searce clients realize smarter, faster, better business outcomes delivered by AI-native Searce solver squads. 

Functional Skills 

the solver personas.

• The Data Architect: This persona deconstructs ambiguous business goals into scalable, elegant data blueprints. They don't just move data; they design the foundation—from schema design to partitioning strategies—that allows data scientists and analysts to thrive, foreseeing technical bottlenecks and making pragmatic trade-offs.
• The Player-Coach: As a hands-on leader, this persona leads from the front by writing exemplary, production-grade SQL and Python while simultaneously mentoring and elevating the skills of the squad. Their success is measured by the team's ability to deliver high-quality, maintainable code and their growth as engineers.
• The Pragmatic Innovator: This individual balances a passion for modern data tech (like Generative AI and Real-time Streaming) with a sharp focus on business outcomes. They champion new tools where they add real value but are disciplined enough to choose stable, cost-effective solutions to meet deadlines and deliver robust products.
• The Client-Facing Technologist: This persona acts as the crucial technical bridge between the data squad and the client. They build trust by listening actively, explaining complex data concepts (like data latency or idempotency) in simple terms, and demonstrating how engineering decisions align with the client’s strategic goals.
• The Quality Craftsman: This individual possesses an unwavering commitment to data integrity and treats data engineering as a craft. They are the guardian of the reporting layer, advocating for robust testing, data validation frameworks, and clean, modular code to ensure the long-term reliability of the data platform.

Experience & Relevance 

• Engineering Depth: 7-10 years of professional experience in end-to-end data product development. You have a portfolio that proves your ability to build complex, high-velocity pipelines for both Batch and Streaming workloads.
• Cloud-Native Fluency: Deep, hands-on experience designing and deploying scalable data solutions on at least one major cloud platform (AWS, GCP, or Azure). You are comfortable navigating the nuances of EMR, BigQuery, or Synapse at scale.
• AI-Native Workflow: You don’t just build for AI; you build with AI. You must be proficient in using AI coding assistants (e.g., GitHub Copilot) to accelerate your delivery and have a track record of building the data foundations required for Generative AI.
• Architectural Portfolio: Evidence of leading 2-3 large-scale transformations—including platform migrations, data lakehouse builds, or real-time analytics architectures.
• Client-Facing Acumen: You have direct experience in a consultative, client-facing role. You can confidently translate a CEO’s business vision into a Lead Engineer’s technical specification without losing anything in translation.

Join the ‘real solvers’

ready to futurify?

If you are excited by the possibilities of what an AI-native engineering-led, modern tech consultancy can do to futurify businesses, apply here and experience the ‘Art of the possible’. Don’t Just Send a Resume. Send a Statement.

JOB DETAILS:

* Job Title: Lead UX designer

* Industry: Banking and Finance

* Salary: Best in Industry

* Experience: 9 to 13 years

* Location: Pune, Maharashtra

Criteria

Strong UX Design / Product Design profile

Minimum 9+ YOE in UX / Product Design

Strong portfolio of UX / Product Design works,

Team handling of UX designers and project management

Design Education (BDes, MDes, BFA, MFA or Similar Design Degrees)

Should NOT have more than 12 Years of Total Experience

Role & Responsibilities

• Leverage one’s Customer Experience (CX) design skills and deliver an engaging customer-focused digital experience across company assets like website, customer service portal.
• Deliver a human-centered design to create customer journeys, identify pain points and design solutions that deliver superior digital customer experience.
• Translate business requirements into compelling UIUX solutions and develop end-to-end customer journey maps by applying principles of customer-centered design.
• Analyse and map consumer behaviour on all assets using digital experience analytics platforms like Content square, Smartlook, Glassbox etc.
• Hands-on experience on design tools like Sketch, Figma, Zeplin, Invision, Adobe XD and the likes is a must.
• Create customer journeys maps basis the user behaviour analysis, customer segments and personas.
• Conduct usability testing of customer journeys with a tools like UsabiltyHub, UserZoom and objectively evaluate and refine the concepts of UIUX based on the output of the test.
• Own and deliver the KPIs for a zero-error environment, increased journey completion rate and high NPS.
• Work with cross-functional teams to directly influence customer roadmaps that deliver best-in-class digital experiences.
• Build a partner ecosystem to deliver the CX objectives for the company.
• Continuously assess customer experience trends and market landscape to generate most up-to-date insights, findings and the best customer-centric UIUX practices across platforms.
• Ideate and build a comprehensive library of interactive prototypes to define the micro interactions and micro animations.

Ideal Candidate

• Bachelor’s degree in design or a related field
• Working knowledge of UX design principles
• Knowledge of Wireframing/prototyping tools
• Good knowledge of UX design tools such as Figma, Axure, or InVision
• Experience with user testing and usability analysis

Job Title: Salesforce Developer (CI/CD – Jenkins)

Experience: 4–5 Years

Location – Pune

Immediate joiners / Max 15 days

Job Description:

We are looking for a skilled Salesforce Developer with hands-on experience in CI/CD tools, especially Jenkins. The candidate will be responsible for developing, customizing, and deploying Salesforce solutions while ensuring seamless integration and automated release processes.

Key Responsibilities:

• Design, develop, and customize Salesforce applications (Apex, LWC, Aura, Visualforce)
• Implement and manage CI/CD pipelines using Jenkins for Salesforce deployments
• Perform code migration, version control (Git), and release management
• Collaborate with cross-functional teams to gather and translate business requirements
• Ensure code quality through testing frameworks and best practices
• Troubleshoot and resolve production issues

Required Skills:

• Strong experience in Salesforce development (Apex, Lightning components)
• Hands-on experience with Jenkins for CI/CD automation
• Knowledge of Git/version control systems
• Experience with Salesforce DX, ANT, or other deployment tools
• Understanding of REST/SOAP APIs and integrations

Good to Have:

• Salesforce certifications (Platform Developer I/II)
• Experience with Agile/Scrum methodologies

Responsibilities:

• Work with product owners, managers, and customers to explore requirements and translate use-cases into functional requirements.
• Collaborate with cross-functional teams and architects to design, develop, test, and deploy web applications using ASP. NETCore | Open-source web framework for. NET, . NET Core, and C#.
• Build scalable, reliable, clean code and unit tests for. NET applications.
• Help maintain code quality, organization, and automation by performing code reviews, refactoring, and unit testing.
• Develop integration with third-party APIs and external applications to deliver robust and scalable applications.
• Maintain services, enhance, optimize, and upgrade existing systems.
• Contribute to architectural and design discussions and document design decisions.
• Effectively participate in planning meetings, retrospectives, daily stand-ups, and other meetings as part of the software development process.
• Contribute to the continuous improvement of development processes and practices.
• Resolve production issues, participate in production incident analysis by conducting effective troubleshooting and RCA within the SLA.
• Work with Operations teams on product deployment, issue resolution, and support.
• Mentor junior developers and assist in their professional growth. Stay updated with the latest technologies and best practices.

Requirements:

• 5+ years of experience with proficiency in C# language.
• Bachelor's or master's degree in computer science or a related field.
• Good working experience in. NET Framework, . NET Core, and ASP. NETCore | Open-source web framework for. NET and C#.
• Good understanding of OOP and design patterns - SOLID, Integration, REST, Micro-services, and cloud-native designs.
• Understanding of fundamental design principles behind building and scaling distributed applications.
• Knack for writing clean, readable, reusable, and testable C# code.
• Strong knowledge of data structures and collections in C#.
• Good knowledge of front-end development languages, including JavaScript, HTML5 and CSS.
• Experience in designing relational DB schema, PL/SQL queries performance tuning.
• Experience in working in an Agile environment following Scrum/SAFE methodologies.
• Knowledge of CI/CD, DevOps, containers, and automation frameworks.
• Experience in developing and deploying on at least one cloud environment.
• Excellent problem-solving, communication, and collaboration skills.
• Ability to work independently and effectively in a fast-paced environment.

Role - MLops Engineer

Location - Pune, Gurgaon, Noida, Bhopal, Bangalore 

Mode - Hybrid

Role Overview

We are looking for an experienced MLOps Engineer to join our growing AI/ML team. You will be responsible for automating, monitoring, and managing machine learning workflows and infrastructure in production environments. This role is key to ensuring our AI solutions are scalable, reliable, and continuously improving.

Key Responsibilities

• Design, build, and manage end-to-end ML pipelines, including model training, validation, deployment, and monitoring.
• Collaborate with data scientists, software engineers, and DevOps teams to integrate ML models into production systems.
• Develop and manage scalable infrastructure using AWS, particularly AWS Sagemaker.
• Automate ML workflows using CI/CD best practices and tools.
• Ensure model reproducibility, governance, and performance tracking.
• Monitor deployed models for data drift, model decay, and performance metrics.
• Implement robust versioning and model registry systems.
• Apply security, performance, and compliance best practices across ML systems.
• Contribute to documentation, knowledge sharing, and continuous improvement of our MLOps capabilities.

Required Skills & Qualifications

• 4+ years of experience in Software Engineering or MLOps, preferably in a production environment.
• Proven experience with AWS services, especially AWS Sagemaker for model development and deployment.
• Working knowledge of AWS DataZone (preferred).
• Strong programming skills in Python, with exposure to R, Scala, or Apache Spark.
• Experience with ML model lifecycle management, version control, containerization (Docker), and orchestration tools (e.g., Kubernetes).
• Familiarity with MLflow, Airflow, or similar pipeline/orchestration tools.
• Experience integrating ML systems into CI/CD workflows using tools like Jenkins, GitHub Actions, or AWS CodePipeline.
• Solid understanding of DevOps and cloud-native infrastructure practices.
• Excellent problem-solving skills and the ability to work collaboratively across teams.

Position: Frontend Developer

Location: Baner, Pune

Experience: 2+ Years

We are looking for a Senior Developer in the team who will take part in developing our product, mentor other team members, and find creative solutions for customer needs. The ideal candidate is one who is able to communicate well in person, on paper, and in code. You love to make an impact and thrive in small, collaborative, energetic teams. You are a product-focused, self-driven individual taking pride and ownership of your work.

About FlytBase

At FlytBase, we’re not just creating a product—we’re on a zero-to-one journey, building a whole new global category that’s never existed before.

‍

What does that mean? We’re on a mission to unlock the world’s third dimension with fully autonomous drones. It’s the first of its kind. Therefore, everything we do requires first-principle thinking, bold experimentation, and a willingness to push boundaries.

If you’re bored of cookie-cutter playbooks and ready for something fresh, exciting (and yes, involving drones), this is your place.

‍

Don’t believe it? Challenge us—We’d be more than happy to tell you why we’re so confident in what we’re building!

Role and Responsibilities:

• Collaborate with Designers, Product Managers for carving out the right front-end architecture.
• Develop web applications that are secure, reusable, modular, and scalable.
• Develop robust, modular, and testable code
• Optimize frontend load times, debug rendering issues, and overall provide a smooth experience to the user.
• Work directly with UI/UX, Product, and Customer Success to help create impacting customer features as the product face of FlytBase.

Best suited for candidates who

• Experience in building scalable and component-based UI architecture for the enterprise using Angular and/or any modern front-end framework.
• Strong coding experience in TypeScript, JavaScript, HTML, and CSS
• Implementing micro-frontends patterns using technology like NgRX, NgXS, and Web Components.
• Experience working in a complete Software Development life cycle involving analysis, technical design, development, testing, troubleshooting, maintenance, documentation and Agile Methodology
• Good understanding of REST APIs and Microservices. 
• Should have an understanding of how resources are organized and how applications should align based on the same.

1. Market Research: Conduct thorough market research to identify potential clients, industry trends, and competitive landscape.
2. Prospecting and Lead Generation: Identify and reach out to potential clients through various channels, including cold calling, emails, and networking events.
3. Client Engagement: Build and maintain strong relationships with clients by understanding their needs and effectively communicating how our products/services can add value.
4. Sales Support: Collaborate with senior business development executives to develop proposals, presentations, and other sales materials. Assist in preparing and delivering client presentations.
5. Pipeline Management: Maintain a well-organized and updated sales pipeline, ensuring accurate tracking of leads, opportunities, and client interactions.
6. Achieving Targets: Work towards and achieve assigned sales targets and objectives within specified timelines.
7. Feedback and Improvement: Provide feedback from client interactions to internal teams, contributing to the continuous improvement of products/services.

Freshers can apply!