Partner Solutions Architect at Mactores Cognition Private Limited · Remote only · 3 - 6 years · ₹8L - ₹12L / yr · Profitable · Remote only · Posted 5 Aug 2026

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
As a Partner Solutions Architect, you own that documentation across all of our partnerships, not just AWS. You're given project and architecture details by the delivery team, and you turn them into the competency documentation each partner program requires, and into case studies you can explain and defend to a partner reviewer, to a prospect, to anyone asking "what did Mactores actually ship here." AI tools are fair game for drafting; the bar is on accuracy and whether it holds up under questioning. Do this well, and the natural next step is a presales architect role, taking these case studies and this partner fluency directly into prospect conversations.
What you’ll do?
- Create and maintain competency documentation across all of Mactores' partnerships AWS, Snowflake, Databricks, Anthropic, OpenAI using project and architecture details provided by the delivery team.
- Produce the technical validation write-ups, architecture diagrams, and case study documentation each partner's competency and service delivery program requires.
- Build a working command of Mactores' case studies well enough to explain them clearly the problem, the architecture, the outcome to partner reviewers, prospects, or internal stakeholders.
- Use AI tools to accelerate drafting, while owning the accuracy and review-readiness of the final document.
- Keep documentation format and quality consistent across partners and engagements.
- Flag gaps in the project details you're given when they're not sufficient to produce audit-ready documentation.
- Work against fixed deadlines tied to partner program renewal and review cycles.
What we’re looking for?
- 2–3 years of experience in technical documentation, solutions architecture, or a related role touching AWS and/or modern data/AI platforms (Snowflake, Databricks, Anthropic, OpenAI).
- Working knowledge of cloud architecture concepts enough to read a design across different platforms and document it accurately.
- Strong technical writing skills; comfortable turning raw project detail into a document that reads cleanly to an external reviewer.
- Comfortable explaining technical case studies out loud, not just writing them this role grows toward customer-facing work.
- Familiarity with diagramming tools (draw.io, Lucidchart, or similar) for architecture diagrams.
- Comfortable using AI tools as part of a documentation workflow, without leaning on them for accuracy you haven't verified.
- Detail-oriented, organized, and able to hold a deadline without supervision.
Life at Mactores
We care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.
1. Be one step ahead
2. Deliver the best
3. Be bold
4. Pay attention to the detail
5. Enjoy the challenge
6. Be curious and take action
7. Take leadership
8. Own it
9. Deliver value
10. Be collaborative
We would like you to read more details about the work culture on https://mactores.com/careers

Similar jobs (10)
As a Solutions Engineer/Sales Engineer, you will act as a trusted technical advisor to prospective customers in the US market. You will own the technical evaluation journey end-to-end, from the first discovery call to closing the deal, by demonstrating how our platform solves real-world data integration challenges. This role involves working closely with global customers (primarily North America ), designing scalable architectures, running tailored product demos, and building proofs-of-concept that showcase value.
Responsibilities:
- Run technical discovery calls with Heads of Data, Data Engineering Managers, and CTOs to understand their stack, pain points, and constraints. These are global conversations, primarily with customers in North America and Europe, and you will own them end-to-end.
- Design and present reference architectures showing how Hevo fits into their existing data stack (e. g., Salesforce, Postgres, GA4 Snowflake, dbt).
- Run live product demos tailored to the customer's stack. These are not scripted walkthroughs. You will need to read the room, adapt on the fly, and handle unexpected technical questions with confidence.
- Own the technical evaluation from the first conversation to the closed deal by addressing deep technical questions and earning trust with engineering teams.
- Build proofs-of-concept by configuring real pipelines from source systems (Salesforce, Outreach, Postgres, MySQL) into destinations like Snowflake or BigQuery.
- Develop deep expertise in the data integration landscape, including native solutions from AWS, GCP, and Azure (AWS Glue, Azure Data Factory, Google Cloud Dataflow) as well as other data pipeline and integration platforms, and articulate Hevo's technical advantages in a way that lands with both technical and non-technical buyers.
- Partner with Account Executives to drive technical wins and with Customer Success to ensure smooth handoffs after a deal closes.
- Share customer feedback and patterns with Product and Engineering to influence the roadmap.
Requirements:
- 2 to 6 years of hands-on experience as a Data engineer, Analytics engineer, ETL/ELT developer, or Data warehouse engineer.
- Experience building and operating real data pipelines in production, including handling source schema changes, failures, and reliability issues.
- Strong fundamentals in SQL and at least one cloud data warehouse (Snowflake, BigQuery, or Redshift).
- Experience with at least one orchestration or transformation tool (Airflow, dbt, or similar).
- Exceptional communication and presentation skills.
- This is non-negotiable. You will be the face of Hevo's technical capability to a global customer base. That means:
- Your spoken English is clear, confident, and easy to follow for an international audience.
- You are comfortable presenting to groups of 5 to 15 people, including senior technical leaders, over video calls.
- You can structure a technical narrative, not just answer questions but guide a conversation toward the right conclusion.
- You can hold your own when a customer pushes back or challenges your recommendation.
- You have presented or demoed something technical to an audience before, in any context: internal reviews, client calls, meetups, or conferences.
- Genuine interest in customer-facing work, even if you have not done it formally before.
Good to have:
- Experience with CDC tools or data integration platforms, whether cloud-native (AWS Glue, Azure Data Factory, or Google Cloud Dataflow) or third-party pipeline and integration tools.
- Exposure to multiple source system types such as CRMs, ad platforms, SaaS APIs, and OLTP databases.
- Public technical writing, conference talks, or open-source contributions.
- Prior experience in customer conversations, even informally. For example, presenting to internal stakeholders or analytics teams or working with international teams across time zones.

About the Role
You'll be at the forefront of designing and implementing robust data platform solutions that power advanced analytics, AI, and machine learning. Working with modern cloud technologies, you'll build scalable data foundations that enable clients to make smarter, data-driven decisions.
Key Responsibilities
- Build scalable data pipelines using Snowflake, AWS, GCP, and Databricks.
- Design and optimize data models for AI and machine learning workloads.
- Develop reliable data foundations for MLOps, governance, and data lineage.
- Integrate data from multiple sources into modern data platforms.
- Leverage Snowpark ML and Snowflake's native AI capabilities.
- Ensure data platforms are secure, scalable, and high-performing.
What We're Looking For
- 5+ years of hands-on experience with Snowflake.
- Strong proficiency in SQL and Python.
- Experience with AWS, Azure, or GCP.
- Knowledge of cloud storage services such as S3, ADLS, or GCS.
- Strong understanding of Dimensional Modeling and Data Vault.
- Experience with Scala or Java is a plus.
Tech Stack
- Data Warehouse: Snowflake
- Programming: SQL, Python, Scala (Good to Have), Java (Good to Have)
- Cloud: AWS, Azure, GCP
- Storage: S3, ADLS, GCS
- AI/ML: Snowpark ML, MLOps
Perks & Benefits
- Public Speaking & Communication Program
- Mentoring Program with Senior Support Leads
- 360° Progress Reviews
- Weekly Learning Sessions & Guilds
- Paid Certifications
- Hackathons & Innovation Days
- Recognition & Rewards Programs
- Team Socials & Annual Offsites
- Employee Assistance Program (24/7 Wellbeing Support)
The Data People Shaping Tomorrow
Our client helps organizations unlock the power of data through modern cloud, analytics, and AI solutions. We believe in creating an environment where talented technologists can learn, innovate, and make a real impact while building cutting-edge data platforms for global clients. If you're passionate about data engineering and want to work with the latest technologies in AI, cloud, and analytics, we'd love to hear from you.
Key Responsibilities
· System Design: Design secure, scalable, and highly available multi-tenant cloud-based application architectures.
· Integration Strategy: Build robust APIs, webhooks, and data pipelines for complex enterprise client connections.
· Technical Guidance: Mentor software engineers and lead critical code and architecture reviews to ensure engineering excellence.
· Performance & Security: Drive non-functional infrastructure needs including high uptime, strict data privacy compliance, and fast application response times.
· Cross-Functional Collaboration: Partner closely with Product, Security, and Customer Success teams to align technical execution with business roadmaps.
Required Qualifications
· Experience: 8+ years of experience in software engineering with at least 3+ years operating as a technical or solutions architect within a B2B SaaS environment.
· Cloud & DevOps: Deep production knowledge of major cloud infrastructure (AWS, GCP, or Azure), containerization technologies (Docker, Kubernetes), and modern CI/CD automation pipelines.
· Architecture Patterns: Proven expertise designing microservices, event-driven architectures, and high-performance relational and NoSQL database structures.
· Communication: Strong written and verbal communication skills, with a proven ability to translate complex technical concepts clearly to both engineers and business stakeholders.
· Education: Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent practical work experience).
Preferred Skills
· Prior experience managing architectural frameworks for enterprise compliance frameworks like SOC2, ISO 27001, or GDPR.
· Background in building real-time data processing engines, stream frameworks, or integrating enterprise AI/ML components.
Position: Technical Architect – Data Engineering
Job Summary:
- We are looking for an experienced Technical Architect to lead the design and implementation of modern cloud-based data platforms.
- The ideal candidate should have strong expertise in Azure and/or AWS, Databricks, Snowflake, modern data architecture, and large-scale data engineering.
- The candidate will work closely with business stakeholders, architects, and engineering teams to deliver scalable, secure, and high-performance data solutions.
Key Responsibilities
• Design enterprise-scale data lakehouse and data warehouse architectures.
• Define data ingestion, transformation, and serving architecture.
• Lead architecture discussions and technical governance.
• Design scalable ETL/ELT frameworks using Databricks and Snowflake.
• Define best practices for security, performance, CI/CD, and DevOps.
• Guide engineering teams on implementation.
• Collaborate with business, product, and data governance teams.
Must Have Skills :
• Azure or AWS
• Databricks
• Snowflake
• Data Lakehouse Architecture
• PySpark
• SQL
• Data Modelling
• ETL/ELT Architecture
• Performance Optimization
• CI/CD
• Terraform or Infrastructure as Code (preferred)
Preferred
• Insurance domain
• dbt
• Unity Catalog
• Delta Lake
• Iceberg
• Azure Data Factory / AWS Glue
About the Role
We are looking for a dynamic and customer-focused Presales Engineer – Cloud & AI to support our Cloud Transformation, Modernization, Managed Services, and AI/GenAI practices.
This role is pivotal in shaping technical solutions for prospective customers, driving value-based conversations, and bridging the gap between customer challenges and Comprinno's cloud and AI capabilities.
As a Presales Engineer – Cloud & AI, you will work closely with Sales, Solution Architects, Data & AI teams, and Delivery teams to understand customer requirements, design high-level solutions, and articulate how Comprinno's offerings can accelerate digital transformation and business outcomes.
This is a high-impact role that combines cloud solutioning, technical consulting, AI awareness, customer engagement, and presales excellence.
Key Responsibilities
Customer Discovery & Solutioning
- Engage with prospective customers to understand business objectives, technical challenges, and transformation goals.
- Conduct discovery workshops, assessments, and technical discussions to identify cloud and AI opportunities.
- Translate business requirements into high-level cloud and AI solution architectures.
- Collaborate with Solution Architects and technical teams to develop scalable and cost-effective solutions.
Cloud Transformation Consulting
- Support customer initiatives across:
- Cloud Migration
- Application Modernization
- DevOps Transformation
- Managed Services
- Security & Compliance
- Resilience & Disaster Recovery
- Conduct cloud assessments and migration readiness evaluations.
- Prepare cloud cost estimates, modernization roadmaps, and optimization recommendations.
- Leverage AWS programs and frameworks such as:
- Migration Acceleration Program (MAP)
- AWS Well-Architected Framework (WAFR)
- Foundational Technical Review (FTR)
AI & GenAI Solution Consulting
- Identify opportunities for AI, GenAI, and Agentic AI adoption within customer environments.
- Participate in AI discovery workshops and business value discussions.
- Support solution design for AI-powered applications leveraging AWS AI services.
- Collaborate with Data & AI teams to position analytics, machine learning, and Generative AI offerings.
- Assist customers in identifying suitable use cases for:
- Generative AI
- AI Assistants
- Knowledge Management Solutions
- Intelligent Automation
- Conversational AI
Proposal Development & Technical Presales
- Collaborate with Solution Architects to create:
- Technical Proposals
- Architecture Diagrams
- Effort Estimates
- Statements of Work (SOWs)
- Technical Responses to RFPs/RFIs
- Present solutions, recommendations, and technical approaches to customer stakeholders.
- Support Proof of Concepts (PoCs), demonstrations, and technical validations.
- Participate in technical reviews and solution walkthroughs.
Customer Engagement & Thought Leadership
- Attend customer meetings jointly with Sales teams to provide technical expertise.
- Build credibility and trust with customer technical and business stakeholders.
- Contribute to webinars, workshops, technical presentations, and customer-facing events.
- Write blogs, case studies, solution briefs, and technical content that supports business growth.
- Maintain an active presence in cloud and AI communities.
Collaboration & Knowledge Management
- Collaborate with Delivery teams to ensure smooth handover and alignment between presales and execution.
- Maintain reusable presales assets, templates, assessment frameworks, and knowledge repositories.
- Continuously stay updated on AWS services, AI advancements, partner programs, and emerging technology trends.
- Contribute to internal capability building and knowledge-sharing initiatives.
Travel & Customer Interaction
- Travel as required for customer meetings, workshops, assessments, events, and strategic engagements.
- Represent Comprinno professionally during all customer-facing interactions.
Required Qualifications & Skills
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- 3–5 years of experience in Presales, Solution Consulting, Cloud Consulting, Technical Sales, or related customer-facing roles.
- Strong understanding of AWS cloud services across:
- Compute
- Networking
- Storage
- Security
- Databases
- Knowledge of cloud migration and modernization frameworks such as AWS MAP.
- Familiarity with AWS cloud assessment tools including Migration Evaluator and AWS Well-Architected Tool.
- Understanding of:
- Kubernetes
- Containerization
- Cloud-Native Architectures
- DevOps Practices
- Hands-on exposure to Infrastructure as Code using Terraform or CloudFormation.
- Ability to create:
- Solution Documents
- Architecture Diagrams
- Technical Proposals
- Effort Estimates
- Statements of Work
- Understanding of Generative AI concepts including:
- Large Language Models (LLMs)
- Prompt Engineering
- Retrieval-Augmented Generation (RAG)
- AI Assistants
- Agentic AI Concepts
- Familiarity with AWS AI services such as:
- Amazon Bedrock
- Amazon SageMaker
- Amazon Q
- AWS Solutions Architect – Professional Certification.
- Experience positioning AI, GenAI, Analytics, or Data Engineering solutions.
- Familiarity with AI frameworks such as:
- LangChain
- LangGraph
- CrewAI
- OpenAI APIs
- Anthropic APIs
- Strong communication, presentation, and stakeholder management skills.
- Experience conducting AI assessments, GenAI workshops, or AI proof-of-concepts.
- Experience contributing to webinars, blogs, case studies, or technical marketing content.
- AWS Solutions Architect – Associate Certification (Mandatory).
- Customer-centric mindset with strong problem-solving abilities.
Desired Qualifications & Skills
- AWS Specialty Certifications such as:
- Security Specialty
- Advanced Networking Specialty
- Machine Learning Specialty
- DevOps Engineer Professional
- Understanding of compliance frameworks such as:
- ISO 27001
- SOC 2
- HIPAA
- MBA or equivalent business qualification.
- Contributions to industry blogs, webinars, conferences, technical communities, or open-source initiatives.
What We're Looking For
- Strong consulting mindset with the ability to understand customer business challenges.
- Excellent communication and presentation skills.
- Ability to balance technical depth with business value articulation.
- Passion for cloud technologies, AI, and emerging innovation.
- Collaborative team player who can work across Sales, Architecture, Delivery, and Product teams.
- High ownership and accountability.
- Curiosity and continuous learning mindset.
- Willingness to travel and work from customer locations across India and internationally as required by project engagements.
What Success Looks Like
- Consistently contributes to qualified pipeline creation and deal progression.
- Produces high-quality proposals, architecture recommendations, assessments, and Statements of Work.
- Builds credibility with customers through strong technical consulting and solution design.
- Successfully supports closure of Migration, Modernization, Managed Services, Security, and AI opportunities.
- Develops reusable presales assets, assessment frameworks, and solution accelerators.
- Contributes to thought leadership through blogs, webinars, technical presentations, and customer-facing content.
- Continuously expands expertise in AWS, Cloud, AI, and emerging technologies.
Why Join Comprinno
- Work at the forefront of Cloud, AI, and AWS innovation with one of the leading AWS Partners in APJ.
- Be part of real transformation initiatives involving Migration, Modernization, DevOps, Security, Managed Services, and Generative AI.
- Collaborate directly with enterprise customers and influence strategic technology decisions.
- Accelerate your growth through AWS certifications, mentorship, and hands-on customer engagements.
- Contribute to innovative solutions including Tevico and future AI-powered offerings.
- Build thought leadership through webinars, blogs, events, and community participation.
- Join a collaborative, high-performance culture that values ownership, innovation, and continuous learning.
Location: Bangalore (Hybrid)
Experience: 10–15 Years
About the Role
At Twenty20 Systems, we are looking for a Solution Architect – Integration (Pre-Sales & Delivery) who can bridge the gap between business, technology, and client success.
This role is ideal for someone who combines strong integration architecture expertise with client-facing consulting, solutioning, and delivery leadership. You will play a key role in shaping client solutions, driving technical discussions, building scalable architectures, and ensuring successful delivery of enterprise integration programs.
This is a role for someone who enjoys owning the solution end-to-end — from pre-sales conversations to delivery execution.
What You’ll Do
- Lead solution architecture and technical consulting for enterprise integration opportunities.
- Work closely with sales, customers, and internal teams to understand requirements and design scalable integration solutions.
- Drive pre-sales activities including solutioning, technical proposals, architecture diagrams, effort estimation, and client presentations.
- Design and review API-led, event-driven, and iPaaS-based integration architectures across enterprise applications.
- Support delivery teams in ensuring architecture alignment, best practices, and successful implementation.
- Provide technical leadership across integration design, troubleshooting, governance, and production support.
- Partner with clients and internal stakeholders to solve business challenges through integration-led digital transformation.
- Mentor engineering teams and contribute to reusable frameworks, accelerators, and delivery playbooks.
What Your First 3 Months Will Look Like
- Understand our product, integration ecosystem, and customer requirements.
- Start leading client solution discussions and pre-sales technical conversations.
- Support ongoing delivery programs with architecture guidance and solution oversight.
- Build strong alignment across sales, product, engineering, and customer teams.
Where You’ll Be in 6 Months
- Leading end-to-end integration solutioning for key customer opportunities.
- Acting as a trusted technical advisor during both pre-sales and delivery stages.
- Driving architecture best practices and reusable integration frameworks.
- Contributing to business growth by enabling stronger technical solutioning and client confidence.
Data Architect – Databricks & AWS
- Strong experience in Data Architecture, Data Engineering, Databricks, Apache Spark/PySpark, Python, and Advanced SQL.
- Design and implement scalable ETL/ELT pipelines, data platforms, and Lakehouse architectures using Medallion Architecture.
- Experience with Databricks, Databricks Workflows, Unity Catalog OR Databricks Jobs
- Strong knowledge of Delta Lake, Databricks Workflows, Delta Live Tables (DLT), and dimensional data modeling.
- Hands-on experience with AWS services such as S3, Glue, IAM, Lambda, and CloudWatch.
- Experience with Apache Airflow, Data Warehouse concepts, Git/CI-CD, performance optimization, and data quality.
- Good to have exposure to Kafka/Structured Streaming, Unity Catalog, and modern data governance.
Technical Architect – Product Engineering
Experience: 15+ Years
Location: Pune, India
Employment Type: Full-time
Desired Skills: Python, Technical Architecture, AWS, Microservices, SaaS / Multi-tenant Architecture, Kubernetes, System Design
About the Role
We are looking for a Senior Technical Architect to lead the architecture, design, and technical evolution of an enterprise SaaS product. This is a hands-on leadership role requiring deep technical expertise, strong product engineering experience, and the ability to build scalable, secure, and high-performance platforms.
The ideal candidate should be passionate about solving complex engineering problems, driving innovation, mentoring development teams, and effectively leveraging AI to accelerate software development.
Key Responsibilities
- Own the overall product architecture and technical roadmap.
- Design and build scalable, secure, and highly available enterprise applications.
- Lead the design and implementation of new product features from concept to production.
- Remain hands-on with coding and contribute to critical product components.
- Drive architecture reviews, code quality, performance optimization, and engineering best practices.
- Lead cloud architecture, security, scalability, and DevOps initiatives.
- Evaluate and adopt modern technologies to improve product capabilities and engineering efficiency.
- Leverage AI tools (ChatGPT, GitHub Copilot, Cursor, Claude, etc.) to accelerate software development, code reviews, testing, documentation, debugging, and productivity.
Required Skills & Qualifications
- 15+ years of software product engineering experience with at least 5 years in a Technical Architect role.
- Strong hands-on expertise in Python and modern backend frameworks.
- Deep experience with AWS services and cloud-native application architecture.
- Strong understanding of DevOps, CI/CD pipelines, Infrastructure as Code (Terraform/CloudFormation), Docker, Kubernetes, and container orchestration.
- Experience designing microservices, REST APIs, event-driven architectures, and distributed systems.
- Strong knowledge of SQL and NoSQL databases.
- Experience with scalable SaaS platforms, multi-tenant architectures, and secure application design.
- Excellent understanding of software design patterns, performance tuning, observability, and system reliability.
- Strong analytical, problem-solving, and decision-making skills.
Key Skills:
Python & System Design: Strong expertise in Python and system design, with proven experience architecting scalable, production-grade systems.
LLM & Agentic AI: Proven experience building LLM-based and agentic systems from the ground up and evaluating them based on reproducibility, calibration, and cost.
Cloud & Data Architecture: Deep understanding of data and cloud architecture across AWS and Azure, including multi-store data design, distributed systems, streaming, security, and cost optimization.
Azure Databricks: Hands-on production experience with Azure Databricks architecture, including Unity Catalog, Delta Lake, cluster policy design, job orchestration, and Terraform provisioning.
Supply Chain & Inventory Management: Strong domain knowledge of supply chain and inventory operations, including demand planning, MRP logic, inventory parameters, and translating business planning decisions into data requirements.
System Architecture & Technical Decision-Making: Ability to make sound architectural decisions based on first principles, evaluate technical trade-offs, and avoid unnecessary complexity and abstraction.
LLM & Agentic AI: Proven experience building LLM-based and agentic systems from the ground up and evaluating them based on reproducibility, calibration, and cost.
Technical Leadership: Ability to influence teams without direct authority, establish technical standards, prepare technical specifications and documentation, and mentor team members.
Experience in pharmaceutical or regulated industries is highly valued.
Job Title : Senior AWS Data Engineer – Data Lake Platform
Experience : 5+ Years
Location: Gurugram Sector 43, Haryana
Work Mode : Work From Office (5 Days a Week – Monday to Friday)
Open Positions : 8+
About the Role :
We are looking for a skilled Senior AWS Data Engineer with strong hands-on experience in building, managing, and optimizing enterprise-scale data lake platforms on AWS.
The ideal candidate will have expertise in AWS data services, PySpark, Apache Airflow, and large-scale data pipeline development. The role involves designing end-to-end data ingestion and processing workflows, maintaining data quality, optimizing platform performance, and supporting analytics and downstream data consumption requirements.
Mandatory skills :
AWS Data Lake, Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, IAM, PySpark, Apache Spark, Apache Airflow, Python, Advanced SQL, Data Modeling, Production Data Pipelines, Hasura/GraphQL, PostgreSQL, and Production Support.
Key Responsibilities :
- Design, develop, and maintain scalable AWS-based data lake platforms and end-to-end data pipelines.
- Build data ingestion, staging, transformation, curated, and consumption layers using AWS services.
- Develop and optimize data processing pipelines using PySpark, Apache Spark, and AWS EMR.
- Implement workflow orchestration and scheduling using Apache Airflow.
- Work with Amazon S3, AWS Glue, Glue Data Catalog, Amazon Athena, and Amazon Redshift for data storage, cataloging, processing, and analytics.
- Develop efficient SQL queries and implement data modeling strategies for enterprise reporting and analytics.
- Build and support data-serving solutions using Amazon RDS, AWS Lambda, API Gateway, and PostgreSQL-based platforms.
- Monitor pipeline performance, troubleshoot production issues, perform root-cause analysis, and ensure data pipeline SLAs.
- Implement data security, access controls, PII protection, and governance best practices across the platform.
- Optimize data processing performance, query execution, storage utilization, and AWS infrastructure costs.
- Collaborate with application, analytics, and business teams to deliver reliable and scalable data solutions.
Mandatory Skills :
- AWS Data Services : Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, and IAM.
- Data Engineering : Strong hands-on experience building and maintaining enterprise data lake platforms.
- Programming : Python, PySpark, and Apache Spark.
- Orchestration : Production experience with Apache Airflow.
- Database & SQL : Advanced SQL, data modeling, and query optimization.
- Data Architecture : Experience with data ingestion, staging, transformation, curated layers, and consumption architecture.
- Production Support : Pipeline monitoring, troubleshooting, root-cause analysis, and SLA management.
- API / Data Serving : Experience with Hasura or a similar GraphQL-based data-serving layer integrated with PostgreSQL.
- Platform Ownership : Ability to independently manage data pipelines, improve platform reliability, and collaborate with cross-functional teams.
Good-to-Have Skills :
- Experience with dbt for data transformation and modeling.
- Knowledge of data lakehouse architectures and table formats such as Apache Iceberg, Delta Lake, or Apache Hudi.
- Experience with Amazon Redshift workload optimization, distribution keys, sort keys, and Spectrum.
- Knowledge of Kafka and real-time or streaming data ingestion.
- Experience with PostgreSQL or Amazon Aurora as a data-serving layer.
- Familiarity with data governance, compliance, and sensitive-data management.
- Experience in the BFSI or health insurance domain.
Ideal Candidate Profile :
- 5+ years of hands-on experience in AWS Data Engineering.
- Strong experience building and supporting production-grade AWS data lake platforms.
- Practical expertise in PySpark, Apache Airflow, SQL, and AWS data services.
- Ability to troubleshoot complex data pipeline issues and optimize performance.
- Strong understanding of data architecture, data modeling, and production support practices.
- Candidates with experience in enterprise data platforms and insurance or BFSI environments will be preferred.














