Integration Engineer

Sonata Software (SonataOne); Irving (TX); Remote; USD 96,000 - 165,000; Full time

Job summary

Sonata Software is seeking a Senior Integration Engineer with 7-10 years of experience to design and implement scalable data ingestion, transformation, and integration pipelines in AWS. You will work on cloud-native data solutions, database migrations, and production-grade data platforms across cross-functional teams.

The role emphasizes Databricks migrations, Apache Airflow orchestration, containerized deployments with Docker and Kubernetes, and robust CI/CD and testing practices to ensure

Qualifications

• 7-15 years of hands-on experience in Data Engineering, Cloud Engineering, or Integration Engineering roles.
• Experience designing and supporting enterprise-scale data platforms and integrations.

Responsibilities

• Design, develop, and maintain scalable data ingestion, transformation, and integration pipelines using Python and SQL.
• Build and manage cloud-native data solutions in AWS (S3, EC2, IAM) and other services.
• Develop database migration frameworks using Alembic for seamless schema evolution.
• Orchestrate, monitor, and optimize data workflows with Apache Airflow and Astronomer.
• Collaborate with product owners, data engineers, analysts, and stakeholders to deliver production-grade solutions.
• Lead migration initiatives to Databricks to improve performance and analytics.
• Create automated validation and testing using Python and AI-assisted tools (e.g., Grok).
• Identify gaps, design improvements, and enhance system reliability and efficiency.
• Implement containerized apps with Docker and deploy workloads on Kubernetes for scalability.
• Drive CI/CD, code quality standards, release management, and infrastructure automation.
• Monitor performance, troubleshoot production issues, and optimize cloud resources for cost.
• Ensure security, governance, and best practices for cloud/data platforms.

Skills

AWS

Docker

Python

SQL

Databricks

Airflow

Alembic

Kubernetes

Git

Grok

CI/CD

REST API

PySpark

Education

Bachelor's or Master's degree in Computer Science/IT/Engineering

Tools

AWS

Terraform

Snowflake

Kafka

Airflow

Docker

Kubernetes

Alembic

Job description

Job Title- Windows App Deployment Engineer

Location- Remote within US

Engagement Type: Contract

About Role:

Weare seeking a highly skilled Senior Integration Engineer with 7-10years of experience in data engineering, cloud technologies, and enterpriseintegration solutions. The ideal candidate will have strong expertise in AWScloud services, Python, SQL, Databricks, workflow orchestration, and modernDevOps practices. This role requires the ability to independently analyzebusiness requirements, identify gaps, develop robust data solutions, and buildscalable data pipelines while collaborating with cross-functional teams.

KeyResponsibilities

• Design, develop, andmaintain scalable and reliable data ingestion, transformation, and integrationpipelines using Python and SQL.
• Build and managecloud-native data solutions within the AWS ecosystem, leveragingservices such as S3, EC2, IAM, and other relevant services.
• Develop, enhance, andmaintain database migration frameworks using Alembic, ensuring seamlessschema evolution with minimal downtime.
• Orchestrate, monitor,and optimize complex data workflows using Apache Airflow and Astronomer.
• Collaborate withproduct owners, data engineers, analysts, and business stakeholders tounderstand requirements and deliver production-grade solutions.
• Lead and supportmigration initiatives to Databricks, improving performance, scalability,and analytics capabilities.
• Create automatedvalidation and testing frameworks using Python and AI-assisted testingtools/frameworks (e.g., Grok, AI-enabled testing platforms).
• Identify process gaps,recommend improvements, and independently design solutions to enhance systemreliability and efficiency.
• Implement containerizedapplications using Docker and deploy workloads on Kubernetes toensure scalability and high availability.
• Drive CI/CDimplementation, code quality standards, release management, and infrastructureautomation.
• Monitor systemperformance, troubleshoot production issues, and optimize cloud resources forcost and operational efficiency.
• Ensure adherence tosecurity, governance, and best practices for cloud and data engineeringplatforms.

RequiredQualifications

• Bachelor's or Master'sdegree in Computer Science, Information Technology, Engineering, or a relatedfield.
• 7-15 years of hands-onexperience in Data Engineering, Cloud Engineering, or Integration Engineeringroles.
• Proven experiencedesigning and supporting enterprise-scale data platforms and integrationsolutions.
• Strong analytical,problem-solving, and troubleshooting skills.
• Experience working inAgile development environments and collaborating with cross-functional teams.
• Excellent communicationand stakeholder management skills.

MandatorySkills

Cloud& Infrastructure

• AWS (S3, EC2, IAM,Lambda, CloudWatch preferred)
• Docker
• Python
• Advanced SQL
• ETL/ELT Processes
• Databricks

Workflow Orchestration

• Astronomer

Database &Migration

• Database Design andOptimization
• Alembic
• Schema MigrationManagement

DevOps

• Git/GitHub/GitLab
• Code Quality &Release Management

Testing &Automation

• Python-based TestAutomation
• AI-assisted TestingFrameworks (Grok or equivalent AI-powered testing platforms)

Goodto Have Skills

• PySpark and SparkOptimization
• AWS Glue
• Terraform orInfrastructure as Code (IaC)
• Kafka or Event-DrivenArchitectures
• Snowflake or ModernData Warehouses
• REST API Developmentand Integration
• Machine Learning and AIIntegration Exposure
• Experience with LargeLanguage Models (LLMs) and AI-enabled automation frameworks

ABOUT SONATA SOFTWARE

Sonata Software is anAI-first modernization engineering company that helps enterprises transformlegacy systems into intelligent, scalable business platforms. Powered by itsPlatformation framework and Harmoni.AI platform, Sonata delivers AI-led modernizationacross cloud, data, AI, Dynamics, test automation, and managed services.Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenueand 6,400+ AI engineers supporting global delivery across regions including theUS, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics. With deeppartnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helpsFortune 500 enterprises accelerate innovation, improve efficiency, and drivesustainable growth.

SonataSoftware is an Equal Opportunity Employer encouraging diversity in theworkplace. All qualified applicants will receive consideration for employmentwithout regard to race, national origin, gender identity, age, religion,disability, sexual orientation, veteran status, marital status, or any othercharacteristics protected by law