Senior Data Integration Engineer

We are seeking a Senior Data Integration Engineer to lead a SQL Server to Aurora PostgreSQL migration and modernization engagement powered by AWS Transform for .NET / SQL Server. This role involves porting database schemas, code objects and application data access layers from Microsoft SQL Server to Amazon Aurora PostgreSQL while validating and refining AI-generated outputs from AWS Transform alongside DMS, SCT and Kiro.

Responsibilities

• Port SQL Server database schemas to Amazon Aurora PostgreSQL to ensure structural integrity, data type mapping and constraint parity
• Convert T-SQL stored procedures, functions, triggers and views to PL/pgSQL equivalents and resolve syntax, data type and behavioral differences
• Update T-SQL queries embedded in C#/.NET application code to PL/pgSQL-compatible syntax and refine the data access layer using Npgsql and Entity Framework Core
• Operate AWS Transform for .NET / SQL Server as the primary AI agentic accelerator to submit workloads and review agent-generated artifacts
• Apply AWS DMS for data migration and replication, AWS SCT for supplementary schema conversion and Kiro for GenAI-assisted code analysis
• Deploy converted schemas, code and data to a non-production Aurora PostgreSQL environment
• Configure instances, parameter groups, security settings and connectivity to mirror production patterns
• Validate compile and execution of migrated SQL code objects and confirm communication between the updated application and Aurora PostgreSQL
• Design test plans that cover functional correctness, data integrity, performance benchmarking and regression testing

Requirements

• 5+ years of experience in database development and migration
• English proficiency at B2+ level
• Expertise in Microsoft SQL Server (T-SQL) and Proficiency in PostgreSQL (PL/pgSQL) including Amazon Aurora PostgreSQL
• Skills in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)
• Proficiency in C#/.NET data access layers including Npgsql Entity Framework Core and ADO.NET
• Background in database schema migration across SQL Server and PostgreSQL platforms
• Expertise in database modernization testing including compile validation functional testing and performance benchmarking

Nice to have

• Familiarity with AWS Transform for .NET / SQL Server and GenAI-assisted migration tools
• Knowledge of AWS Aurora configuration including parameter groups replication and Performance Insights
• Familiarity with Amazon CloudWatch for database monitoring and alerting
• Skills in Python for scripting and automation and CI/CD for database deployments
• Familiarity with Kiro for AI-assisted code refinement workflows

Benefits

With us you can:

• Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
• Receive the necessary equipment to perform your work tasks
• Change projects and technology stacks within EPAM
• Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
• Relocation opportunities may be available for eligible candidates, depending on the role and openings at other EPAM locations
• Participate in volunteer, charity programs and communities (both technical and interest-based)

We focus on your professional growth:

• You can plan your individual career path together with your manager
• Receive regular feedback from colleagues
• Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
• Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
• Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
• Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
• Study at EPAM Solution Architecture School with the instructors who are practicing architects
• Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
• Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)

What we offer:

• Vacation and sick leave (including a sick leave without a medical certificate)
• A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
• Medical insurance for family members at corporate rates
• Company support during significant life events (childbirth or adoption, marriage, etc.)
• Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
• E-kids program - a free programming language training program for EPAMers' children