Senior Alteryx Technical Engineer at Ampera Technologies · Hyderabad · 6 - 12 years · Profitable · Posted 12 Nov 2026

We are seeking a highly skilled, hands-on Senior Alteryx Technical Engineer with extensive experience in developing, optimizing, deploying, and supporting enterprise-grade Alteryx workflows. The role requires deep technical expertise in Alteryx Designer, advanced data
transformation, workflow automation, macros, data integration, performance optimization, and platform administration. The engineer will be responsible for managing business-critical workflows supporting Investor Operations and Client Reporting, ensuring data accuracy,
scalability, operational reliability, and efficient processing. The ideal candidate must demonstrate strong technical problem-solving capabilities, independent engineering ownership, and excellent communication skills to engage effectively with business
stakeholders, application teams, and enterprise technology teams.
Key Responsibilities
1. Advanced Alteryx Workflow Engineering
• Design, develop, and maintain complex ETL/ELT and analytical workflows using Alteryx
Designer.
• Demonstrate advanced proficiency with Alteryx tools, including Formula, Multi-Row
Formula, Multi-Field Formula, Join, Join Multiple, Union, Summarize, Cross Tab,
Transpose, Regex, and Dynamic Input/Output.
• Develop reusable Standard Macros, Batch Macros, Iterative Macros, and Analytic Apps to support modular and scalable workflow designs.
Implement complex business rules, conditional processing, parameterized workflows,
dynamic schema handling, and multi-source data transformations.
• Build data cleansing, reconciliation, exception handling, validation, and enrichment
pipelines.
• Design workflows capable of processing large datasets while maintaining accuracy,
performance, and operational stability.
2. Workflow Performance Optimization & Troubleshooting
• Analyze and optimize workflow execution times, memory consumption, and data processing efficiency.
• Apply Alteryx performance optimization techniques, including:
o AMP Engine configuration and performance tuning.
o Efficient use of Select, Filter, Join, Summarize, and In-DB processing tools.
o Pushdown processing to databases where appropriate.
o Optimization of data types, intermediate datasets, and workflow dependencies.
o Efficient handling of large-volume datasets and complex joins.
• Troubleshoot workflow execution failures, schema mismatches, data-type conversion
issues, and connectivity errors.
• Implement robust error handling, validation checkpoints, logging, and exception
reporting.
• Perform root-cause analysis and implement permanent solutions for recurring
production issues.
3. Alteryx Server / Alteryx One Administration
• Deploy, schedule, monitor, and maintain production workflows using Alteryx Server or
applicable Alteryx One capabilities.
• Manage workflow publishing, versioning, scheduling, dependencies, and execution monitoring.
• Configure and troubleshoot data connections, credentials, permissions, and access
controls.
• Work with Alteryx Server components such as Gallery, Controller, Worker, and
Scheduler where applicable.
• Support platform configuration, environment management, and deployment activities.
• Troubleshoot workflow scheduling failures, execution queues, resource constraints, and
connectivity issues.
• Support operational monitoring and platform stability for business-critical workflows.
4. Enterprise Data Integration & SQL
• Integrate Alteryx workflows with enterprise data platforms such as Snowflake, SQL
Server, PostgreSQL, and other relational databases.
• Develop complex SQL queries involving joins, CTEs, aggregations, window functions, and
data validation logic.
• Use Alteryx Input Data, Output Data, Dynamic Input, and In-DB tools for efficient data
processing.
• Integrate REST APIs, JSON, XML, CSV, Excel, and other structured or semi-structured
data sources.
• Configure and troubleshoot ODBC/JDBC connections and database authentication.
• Implement incremental data processing, reconciliation logic, duplicate detection, and
data quality controls.
• Develop automated workflows for scheduled data extraction, transformation, and
reporting.
5. Identity & Access Management – Microsoft Entra ID / SCIM
• Support Alteryx integration with Microsoft Entra ID for enterprise identity and access
management.
• Configure and troubleshoot SCIM-based user and group provisioning, including
automated provisioning, updates, and deprovisioning.
• Manage user/group synchronization, role assignments, and access permissions.
• Investigate SCIM provisioning errors, authentication issues, and synchronization failures.
• Collaborate with IAM and infrastructure teams to maintain secure and controlled access
to the Alteryx platform.
• Support role-based access controls, audit requirements, and enterprise security
standards.
6.Production Support & Engineering Ownership
• Own end-to-end technical delivery of Alteryx solutions, from requirements analysis and
design through development, testing, deployment, and production support.
• Monitor scheduled workflows, investigate failures, and resolve data processing
incidents.
• Implement automated data quality checks, exception notifications, and operational
controls.
• Maintain source-to-target mappings, workflow documentation, technical specifications,
and runbooks.
• Collaborate with upstream and downstream application teams to resolve integration
dependencies.
• Ensure production workflows meet agreed business processing timelines and reporting
requirements.
7. Stakeholder Engagement & Communication
• Work directly with Investor Operations, Client Reporting, and technology stakeholders.
• Translate complex business requirements into robust Alteryx workflow designs
Explain technical solutions, data issues, root causes, and remediation plans to technical
and non-technical audiences.
• Provide clear status updates, proactively identify risks, and independently drive issue
resolution.
• Demonstrate strong ownership, structured problem-solving, and excellent written and
verbal communication.
Mandatory Technical Skills
• Alteryx Certification – Mandatory: Valid Alteryx Designer Core Certification or higher.
• Alteryx Designer: Advanced hands-on expertise in complex workflow development,
data transformation, and automation.
• Alteryx Macros: Practical experience developing Standard, Batch, and Iterative Macros.
• Alteryx Performance Tuning: Strong understanding of workflow optimization, AMP
Engine, memory utilization, and efficient processing of large datasets.
• SQL: Strong hands-on SQL development, complex queries, joins, aggregations, and data
reconciliation.
• Data Integration: Experience connecting Alteryx to databases, APIs, and multiple
enterprise data sources.
• Production Support: Experience troubleshooting failed workflows, scheduling issues,
data discrepancies, and performance bottlenecks.
• Platform Operations: Working knowledge of Alteryx Server or Alteryx One workflow
deployment, scheduling, monitoring, and administration.
• Communication: Excellent verbal and written communication skills with the ability to
interact confidently with business and technical stakeholders.
Preferred / Good-to-Have Skills
• Private Equity or Investment Management domain experience will be a plus.
Job Description
Document No: AMP_HR_F_004 Ver No: 1.1 Rev Date: 04-May-2026
Internal Page 6 of 7
• Alteryx Designer Advanced or Expert Certification.
• Experience administering Alteryx Server, including Gallery, Controller, Worker, and
scheduling components.
• Experience with Alteryx One / Alteryx Analytics Cloud administration.
• Microsoft Entra ID, SCIM 2.0 provisioning, and enterprise identity management.
• Python scripting, including Pandas and data processing automation.
• Snowflake integration and SQL performance optimization.
• Experience with Alteryx Server APIs, REST APIs, and workflow orchestration.
• Knowledge of Git-based version control and CI/CD practices for Alteryx workflows.
• Understanding of financial data reconciliation, investor reporting, data governance, and
audit controls.

About Ampera Technologies
About
At Ampera Technologies, we empower businesses with cutting-edge data analytics, quality assurance, and data engineering solutions
Company social profiles
Similar jobs (10)
Key Skills
Advanced hands-on experience in Alteryx Designer.
Strong knowledge of Alteryx workflows, Macros (Standard, Batch & Iterative).
Excellent SQL skills, including complex queries, joins, CTEs and aggregations.
Strong experience in ETL/ELT, data transformation and integration.
Alteryx workflow performance optimization and troubleshooting.
Experience with Alteryx Server / Alteryx One administration.
Production support, workflow scheduling and deployment.
Knowledge of Snowflake, SQL Server and PostgreSQL.
Microsoft Entra ID and SCIM provisioning knowledge is preferred.
Excellent communication and stakeholder management skills.
Mandatory Requirements
Valid Alteryx Designer Core Certification or higher is mandatory.
Strong hands-on experience in Alteryx workflow development.
Practical experience with Alteryx Macros.
Strong SQL and ETL/ELT expertise.
Experience in production support and performance optimization.
Excellent communication skills.
Good-to-Have Skills
Private Equity / Investment Management domain experience.
Alteryx Designer Advanced or Expert Certification.
Python (Pandas), Snowflake and REST APIs.
Microsoft Entra ID and SCIM 2.0.
Git, CI/CD and workflow automation.
Key Responsibilities
Design, develop and maintain enterprise-grade Alteryx workflows.
Build reusable macros and optimize complex ETL/ELT processes.
Manage workflow deployment, scheduling and monitoring.
Perform performance tuning and troubleshoot production issues.
Integrate multiple databases, APIs and enterprise data sources.
Ensure data accuracy, reconciliation and operational reliability.
Coordinate with business and technical stakeholders.
Job Summary – Axiom Technical Analyst
🔹 Experience: 5+ Years
🔹 Skill Set: Axiom + SQL + ETL
🔹 Locations: Bangalore / Hyderabad
🔹 Notice Period: Immediate to 15 Days Joiners Preferred
Required Skills:
🔹 Strong hands-on experience in Axiom
🔹 Good knowledge of SQL and database concepts
🔹 Hands-on experience with ETL processes
🔹 Experience in data extraction, transformation, and loading
🔹 Good understanding of data integration and data processing
🔹 Experience in developing, maintaining, and troubleshooting data workflows
🔹 Strong analytical and problem-solving skills
🔹 Good communication and collaboration skills
🔹 Ability to troubleshoot technical issues and support application/data processes
🔹 Understanding of SDLC and Agile methodologies
Immediate Joining
We are looking for a Dedicated Resource on Contract for –
Role: Data Engineer
Experience: 5+ Years
Location: Remote
Duration: 3+ Months
Strong hands-on experience with Snowflake, including writing SQL queries, creating views, stored procedures, and functions.
Good knowledge of AI tools such as Claude.
Experience with ETL tools like Alteryx is good to have.
Power BI experience is good to have.
Strong communication skills.
Job Title : Data Platform Engineer (SDE 2 / SDE 3)
Experience : 3 to 8 Years (SDE2 : 3 to 5 Years | SDE3 : 5.5 to 8 Years)
Location : Remote (Contract) → Pune (Post Conversion)
Employment Type : Contract-to-Hire (3 Months)
Mandatory Skills :
Java / Python / Go, SQL, Data Engineering, ETL / ELT, Apache Airflow, Apache Spark / Flink, Kafka, AWS/GCP/Azure, Distributed Systems, API Development, Docker, Kubernetes, CI/CD, System Design
Role Overview :
We are looking for a Data Platform Engineer with strong backend engineering expertise to build scalable, high-performance data platforms and distributed systems. The ideal candidate should have hands-on experience in developing production-grade backend applications along with designing and maintaining modern data pipelines.
Key Responsibilities :
- Build and maintain scalable ETL/ELT and data processing pipelines.
- Develop backend services and APIs using Java (preferred), Python, or Go.
- Design batch and real-time data pipelines using Spark, Flink, Kafka, and Airflow.
- Optimize SQL queries, data models, and distributed data systems.
- Work with cloud platforms (AWS, GCP, or Azure) and container technologies (Docker, Kubernetes).
- Implement CI/CD, monitoring, logging, and performance optimization.
- Collaborate with product and engineering teams on scalable system design and architecture.
Required Qualifications :
- SDE 2 : 3 to 5 years of Backend + Data Engineering experience.
- SDE 3 : 5.5 to 8 years of Backend + Data Engineering experience.
- Strong coding skills in Java (preferred), Python, or Go.
- Excellent SQL and data modeling knowledge.
- Hands-on experience with Airflow, Apache Spark / Apache Flink, or similar technologies.
- Experience building scalable backend services and APIs.
- Good understanding of distributed systems, system design. and scalable architecture.
- Experience with cloud platforms (AWS, Azure, or GCP).
- Hands-on experience with Docker and Kubernetes.
- Strong understanding of CI/CD pipelines.
- Excellent problem-solving and debugging skills.
Good to Have :
- Experience with Snowflake, BigQuery, or Redshift.
- Understanding of Kafka, Kinesis, or Pub/Sub
- Performance optimization of large-scale distributed systems
- FinTech or high-scale distributed systems experience.
- Knowledge of data governance, security, and compliance.
Preferred Candidate Profile :
- Strong Backend + Data Engineering experience
- Experience building scalable production systems
- Strong ownership mindset
- Good system design knowledge
- Experience processing millions of events using Kafka/Spark
- Built APIs supporting data infrastructure
- Production engineering experience
Interview Process :
- Take-home Coding Assignment (48 Hours)
- Leadership & Strategy Round (1 Hour)
- Technical Depth – Data Engineering & Performance (1 Hour)
- Culture & Values Fit (30 Minutes)
Job Summary
Role Overview
We are looking for an experienced Data Engineer with strong expertise in Python, ETL, Advanced SQL, CI/CD, DevOps, and Data Analytics. The ideal candidate should have hands-on experience designing and developing scalable data pipelines, transforming large datasets, and supporting data-driven applications.
Experience with Google Cloud Platform (GCP) will be an added advantage.
Key Responsibilities
- Design, develop, and maintain scalable ETL/ELT data pipelines using Python and SQL.
- Develop complex and optimized SQL queries, stored procedures, and data transformations.
- Build and maintain reliable data integration workflows across multiple data sources.
- Perform data cleansing, validation, transformation, and quality checks.
- Analyze data and provide insights to support business and technical requirements.
- Implement and maintain CI/CD pipelines for data engineering applications.
- Work with DevOps practices and tools to automate deployments, monitoring, and infrastructure processes.
- Troubleshoot data pipeline failures, performance issues, and production incidents.
- Optimize data processing workflows for performance, scalability, and reliability.
- Collaborate with Data Analysts, Data Scientists, Developers, and other stakeholders.
- Follow best practices for version control, testing, documentation, and deployment.
- Contribute to cloud-based data engineering initiatives, preferably on GCP.
Required Skills
- 5–7 years of hands-on experience in Data Engineering.
- Strong programming skills in Python.
- Strong expertise in Advanced SQL and database concepts.
- Hands-on experience with ETL/ELT processes and data pipelines.
- Good understanding of Data Warehousing and Data Modeling concepts.
- Experience with CI/CD practices and tools.
- Strong understanding of DevOps principles, automation, and deployment processes.
- Strong data analytics and problem-solving skills.
- Experience working with large datasets and performance optimization.
- Good understanding of Git/version control and software development best practices.
Good to Have
- Hands-on experience with Google Cloud Platform (GCP).
- Exposure to GCP data services such as BigQuery, Cloud Storage, Dataflow, Composer, or Pub/Sub.
- Experience with containerization/orchestration technologies such as Docker/Kubernetes.
- Experience with workflow orchestration tools such as Airflow.
- Knowledge of cloud-based data architecture and distributed data processing.
Preferred Candidate Profile
- Strong analytical and problem-solving abilities.
- Good communication and stakeholder management skills.
- Ability to work independently as well as in a collaborative team environment.
- Strong ownership of data pipelines and production systems.
- Candidates who can join at short notice are preferred.
Mandatory Skills
Data Engineer, Python , ETL, GCP, Advanced SQL, Strong Data Analytics skills, CICD, Devops
Job Title : Data / AI / GenAI – Engineering & Analytics
Experience : 4+ Years
Location : Noida / Gurugram / Ahmedabad
Employment Type : Full-time | On-site at client location
Working Days : 5 days per week
Working Hours : Standard business hours
Position Overview : We are seeking professionals to deliver modern data engineering, business intelligence, cloud analytics and AI-powered applications, according to their specialization.
Mandatory Skills :
Python, SQL, ETL/ELT, Data Engineering, Power BI, Azure Data Factory, Databricks, PySpark, Data Modeling, GenAI/LLMs, RAG, Vector Databases, AI Agents (as per role specialization).
Key Roles / Specializations :
- Power BI Developers : Dashboards, DAX, Power Query, reporting and data modeling
- Azure Data Engineers : Azure Data Factory, Data Lake, Azure SQL and cloud pipelines
- Databricks Engineers : Apache Spark, PySpark, Delta Lake and scalable processing
- Data Engineers : ETL/ELT, SQL, Python, data warehousing and quality
- GenAI / RAG Engineers : LLMs, prompts, embeddings, vector databases and retrieval pipelines
- Agentic AI Engineers : AI agents, tool calling, orchestration and multi-agent workflows
Key Responsibilities :
- Design, develop and maintain data pipelines, analytics solutions or AI applications.
- Build and optimize data integration, transformation and processing workflows.
- Develop dashboards and analytical models for business decision-making.
- Use cloud data platforms and modern engineering frameworks.
- Develop and evaluate LLM applications, RAG solutions or AI agents as applicable.
- Ensure data quality, security, performance and reliability.
- Collaborate with engineering teams and stakeholders on testing, deployment and documentation.
Required Skills & Qualifications :
- Bachelor’s degree in Computer Science, IT, Data Science, Engineering or related discipline.
- 4–5 years of relevant experience in data, analytics, AI or software engineering.
- Hands-on expertise in at least one listed specialization; not all technologies are required.
- Relevant Python, SQL, DAX or other technical skills depending on the position.
- Understanding of cloud platforms, APIs, integration and software practices.
Preferred Qualifications :
- Azure, Databricks or Microsoft Fabric experience.
- For GenAI roles : Azure OpenAI, OpenAI APIs, LangChain, LlamaIndex or LangGraph.
- For relevant roles : vector databases, CI/CD, Docker, MLOps or LLMOps.
Note : Candidates are expected to have expertise in their relevant specialization, not in every listed technology or role.
Location: Bangalore Experience: 5 to 7 years Employment type: Full-time, permanent Work Hours: General Shift (10.00 AM to 7.00 PM) website: www.amazech.com Qualifications: Minimum B.E./B.Tech, or higher in Computer Science, Information Technology, Data Engineering, or a related field, with a good academic background. Key Responsibilities: • Design, develop, and maintain end-to-end data pipelines. • Build and optimize ETL/ELT processes for large-scale data processing. • Implement Azure-based data solutions ensuring scalability and performance. • Collaborate with stakeholders to understand business data requirements. • Perform performance tuning and optimization across data platforms. • Support production environments, conduct root cause analysis, and resolve data-related issues. • Maintain comprehensive technical documentation and structured knowledge transfer documents. • Work effectively within Agile/Scrum frameworks and contribute to sprint planning and delivery. • Ensure secure and compliant data handling using Azure best practices. Required Skills & Experience • End-to-end ETL/ELT pipeline development, integration, and performance optimization • Azure Synapse, Azure Logic Apps, Azure SQL, and Azure Databricks, with a strong focus on performance tuning • Microsoft Azure services, including Storage Accounts, Key Vault, and Cognitive Services • Advanced proficiency in Python development and modern productivity tools such as GitHub Copilot and Cursor • Strong documentation discipline, including technical design documentation, and structured knowledge transfer documents • Experience operating within Agile/Scrum frameworks, including production support, root cause analysis, and effective stakeholder collaboration
About Us:
The QX Impact was launched with a mission to make A.I accessible and affordable and deliver AI Products/Solutions at scale for the enterprises by bringing the power of Data, AI, and Engineering to drive digital transformation. We believe without insights; businesses will continue to face challenges to better understand their customers and even lose them. Secondly, without insights businesses won't’ be able to deliver differentiated products/services; and finally, without insights, businesses can’t achieve a new level of “Operational Excellence” is crucial to remain competitive, meeting rising customer expectations, expanding markets, and digitalization.
Job Summary:
We are looking for a Senior Data Engineer who is creative, collaborative, and adaptable to join our agile team of data scientists, engineers, and UX developers. The role focuses on building and maintaining robust data pipelines to support advanced analytics, data science, and BI solutions.
As a Senior Data Engineer, you will work with internal and external data, collaborate with data scientists, and contribute to the design, development, and deployment of innovative solutions.
Key Responsibilities:
- Design, develop, test, and maintain optimal data pipeline and ETL architectures.
- Map out data systems and define/design required integrations, ETL, BI, and AI systems/processes.
- Prepare and optimize data for predictive and prescriptive modeling.
- Collaborate with teams to integrate ERP data into the enterprise data lake, ensuring seamless flow and quality.
- Enhance cloud data infrastructure on AWS or Azure for scalability and performance.
- Utilize big data tools and frameworks to optimize data acquisition and preparation.
- Build architectures to move data to/from data lakes and data warehouses for advanced analytics.
- Develop and curate data models for analytics, dashboards, and reports.
- Conduct code reviews, maintain production-level code, and implement testing approaches.
- Monitor, troubleshoot, and resolve data ingestion workflows to maintain reliability and uptime.
- Drive innovation and implement efficient new approaches to data engineering tasks.
Must-Have Skills:
- Bachelor’s degree in Computer Science, Mathematics, Engineering, or a related field.
- 5+ years of experience working with enterprise data platforms, including building and managing data lakes.
- 3–5 years of experience designing and implementing data warehouse solutions.
- Expertise in SQL, including developing stored procedures (SP) and applying advanced data design concepts.
- Proficiency in Spark (Python/Scala) and Spark Streaming for real-time data pipelines.
- Experience with AWS or Azure services (e.g., AWS Glue, Azure Data Factory, Redshift, Snowflake).
- Familiarity with big data tools such as Apache Kafka, Apache Spark, or Flink.
- Hands-on experience with orchestration tools (e.g., Apache Airflow, Prefect).
- Knowledge of CI/CD processes, version control (e.g., Git, Jenkins), and deployment automation.
- Strong problem-solving, communication, and collaboration skills.
Good-to-Have Skills:
- Experience in integrating ERP data into data lakes.
- Experience with traditional ETL tools (e.g., Talend, Pentaho).
Competencies:
- Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
- Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
Why Join Us?
- Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
- Work on impactful projects that make a difference across industries.
- Opportunities for professional growth and continuous learning.
- Competitive salary and benefits package.
Application Details
Ready to make an impact? Apply today and become part of the QX Impact team!
🚀 Job Title : Data Engineer – AWS, PySpark & Airflow
Experience : 5+ Years
Industry : Health Insurance / BFSI
Location : Sector 43, Gurugram, Haryana
Work Mode : Work From Office (5 Days a Week)
Employment Type : Full-Time
Role Overview :
We are looking for an experienced Data Engineer with strong hands-on expertise in AWS Data Engineering, Data Lake Architecture, Python, SQL, PySpark, and Apache Airflow.
The candidate will be responsible for designing, developing, and maintaining scalable, reliable, and high-performance data pipelines using AWS cloud technologies. The role involves building end-to-end ETL / ELT workflows, implementing data transformation and processing solutions, optimizing pipeline performance, and ensuring the reliability of production data systems.
Mandatory Skills :
AWS Data Engineering | Data Lake Architecture | Amazon S3 | AWS Glue | Amazon EMR | Athena | Redshift | Python | SQL | PySpark | Apache Spark | Apache Airflow | ETL/ELT | PostgreSQL | Data Modelling | Pipeline Optimization | Production Support | Root Cause Analysis
Key Responsibilities :
- Design, develop, and maintain end-to-end data pipelines for data ingestion, staging, transformation, curation, and consumption.
- Build and manage AWS-based data lake solutions using Amazon S3, AWS Glue, Amazon EMR, Athena, and Redshift.
- Develop, maintain, and optimize ETL / ELT pipelines using Python, SQL, Apache Spark, and PySpark.
- Implement and manage workflow orchestration using Apache Airflow, including scheduling, dependency management, retries, monitoring, and failure handling.
- Integrate data from multiple structured and semi-structured sources.
- Design and maintain data models, dimensional models, and analytical data marts.
- Work with relational databases, including PostgreSQL and Amazon RDS.
- Optimize Spark jobs, SQL queries, data transformations, and cloud resource utilization.
- Implement data quality checks, validation rules, and error-handling mechanisms.
- Monitor production data pipelines, troubleshoot failures, and perform root cause analysis (RCA).
- Ensure pipeline reliability, scalability, performance, and compliance with service-level agreements (SLAs).
- Follow data security, access management, governance, and sensitive-data protection best practices.
- Collaborate with business, analytics, and application teams to deliver effective data solutions.
- Maintain technical documentation and follow established data engineering standards.
Required Technical Skills :
- AWS Data Engineering : Strong hands-on experience with AWS-based data engineering and data lake architecture.
- AWS Services : Amazon S3, AWS Glue, Glue Data Catalog, Amazon EMR, Athena, Redshift, AWS Lambda, and IAM.
- Programming : Strong proficiency in Python and SQL.
- Big Data Processing : Hands-on experience with Apache Spark and PySpark.
- Workflow Orchestration : Experience developing and managing workflows using Apache Airflow.
- ETL/ELT Development : Experience building scalable data ingestion, transformation, and processing pipelines.
- Database Technologies : Good understanding of relational databases and PostgreSQL concepts.
- Data Modelling : Experience with data modelling, data transformation, and analytical data structures.
- Production Support : Ability to monitor pipelines, troubleshoot failures, perform RCA, and resolve production issues.
- Performance Optimization : Experience optimizing SQL queries, Spark jobs, and data processing workflows.
Good-to-Have Skills :
- Experience with AWS Database Migration Service (DMS) and Amazon RDS.
- Familiarity with dbt for data transformation and modelling.
- Knowledge of Delta Lake, Apache Iceberg, or Apache Hudi.
- Exposure to Apache Kafka and real-time data streaming.
- Familiarity with GraphQL, Hasura, or similar data-serving technologies.
- Understanding of data governance and data quality frameworks.
- Experience in the BFSI, healthcare, or health insurance domain.
Candidate Requirements :
- 5+ years of relevant experience in Data Engineering.
- Proven hands-on experience building and maintaining production-grade data pipelines on AWS.
- Strong understanding of data lake architecture and large-scale data processing.
- Practical experience with Apache Airflow and Spark / PySpark-based transformations.
- Strong programming, analytical, debugging, and problem-solving skills.
- Experience handling production incidents, pipeline failures, and performance bottlenecks.
- Ability to take ownership of deliverables and work effectively with cross-functional teams.
- Good communication, collaboration, and technical documentation skills.
- Willingness to work from the Gurugram office five days a week.
Ideal Candidate :
The ideal candidate is a hands-on Data Engineer who can independently build, optimize, and maintain AWS-based data pipelines, work with large datasets using PySpark, orchestrate workflows through Airflow, and resolve production issues in a business-critical environment.
Navtech is a premier IT software and services provider. Our mission is to increase public cloud adoption and build cloud-first solutions that become trendsetting platforms of the future.
We have been recognized as the Best Cloud Service Provider by GoodFirms for delivering quality services and results. We strive to innovate and push technology and service boundaries to provide best-in-class technology solutions to our clients globally.
We are a fast-growing company serving clients across the United States, UK and Europe. You will work with a team of talented developers, quality engineers and product managers who are passionate about building impactful technology solutions.
About the Role
We are looking for an experienced Senior SQL Server / SSIS Engineer to design, develop, maintain and optimise database solutions and ETL workflows.
The ideal candidate should have strong hands-on experience with Microsoft SQL Server, SSIS package development, T-SQL programming, database performance tuning and data migration.
You should be comfortable working with existing database systems, troubleshooting complex issues, improving performance and ensuring data integrity, security and availability.
Key Responsibilities
- Design, develop and maintain SQL Server databases, database objects and logical data models.
- Develop, deploy and maintain SSIS packages for ETL processes and data integration.
- Build and optimise complex SQL queries, stored procedures, functions, views and triggers.
- Design and implement data extraction, transformation and loading workflows across multiple systems.
- Perform database migrations, data transformations and validation activities.
- Monitor and troubleshoot SQL Server databases, SSIS packages and SQL Server Agent jobs.
- Identify and resolve performance bottlenecks through query optimisation, indexing and execution plan analysis.
- Handle database administration activities, including upgrades, backups, recovery and maintenance.
- Ensure database performance, security, availability and data integrity.
- Troubleshoot database locking, blocking and resource utilisation issues.
- Collaborate with developers, QA engineers and other stakeholders to understand database requirements.
- Maintain technical documentation for database structures, ETL workflows and processes.
- Provide production support and proactively identify opportunities to improve database performance and reliability.
Who Are We Looking For?
- 6–10 years of experience in SQL Server development and database engineering.
- Strong hands-on experience with Microsoft SQL Server, preferably SQL Server 2016/2017 or above.
- Hands-on experience in developing, deploying and maintaining SSIS packages.
- Strong understanding of ETL processes, data integration and data migration.
- Advanced knowledge of T-SQL, stored procedures, functions, views and triggers.
- Experience in database performance tuning, query optimisation, indexing and execution plans.
- Experience in SQL Server monitoring, troubleshooting and resolving database performance issues.
- Good understanding of SQL Server Agent jobs, database backups, recovery and maintenance.
- Experience resolving database locking conflicts, blocking and resource utilisation issues.
- Knowledge of SQL Server system tables and Dynamic Management Views (DMVs).
- Experience with PowerShell scripting and automation is preferred.
- Exposure to AWS RDS, Azure SQL or other cloud database environments is an advantage.
- Knowledge of PostgreSQL or NoSQL databases is a plus.
- Experience leading or mentoring junior developers is preferred.
- Bachelor's or Master's degree in Computer Science, Software Engineering, IT or a related field.
- Excellent analytical, logical, troubleshooting and communication skills.
Good to Have
- Experience with SSRS or SSAS.
- Knowledge of AWS RDS or Azure SQL.
- Experience with PowerShell scripting.
- Exposure to PostgreSQL or NoSQL databases.
- Relevant Microsoft SQL Server certifications.
Why Navtech?
- Performance reviews and appraisals twice a year.
- Competitive compensation package with additional bonuses and benefits.
- Opportunities to work with renowned clients across the US, UK and Europe.
- Medical insurance coverage for self and immediate family.
- Opportunity to work with a culturally diverse and collaborative team.
- Opportunities for continuous learning and technical growth.












