Middle Data Integration Engineer

We are seeking a Middle Data Integration Engineer to support the modernization of database infrastructure for various consumer-facing API workloads.Your work will focus on improving data ingestion, synchronization with Snowflake, and enhancing API performance. This role offers the opportunity to contribute to a project aimed at replacing the current Postgres setup with a more scalable and efficient solution. If you are motivated by solving complex data challenges and have experience with AWS and Python, we encourage you to apply. ResponsibilitiesEvaluate current database infrastructure to identify performance and scalability improvementsDesign and implement data ingestion and synchronization processes with SnowflakeDevelop and maintain AWS Lambda functions to support data workflowsManage data streaming using Amazon KinesisOptimize database performance on Amazon RDS Aurora for PostgresAutomate deployments and infrastructure management using Terraform and GitHub ActionsCollaborate with cross-functional teams to ensure data integrity and API reliabilityMonitor and troubleshoot data pipeline issues to minimize impact on API performanceImplement security best practices with AWS IAM roles and policiesMaintain documentation related to data integration processes and infrastructure Requirements3+ years of experience in data engineeringProficiency in AWS services including S3, Lambda, Kinesis, IAM, CDK, and CloudFormationBackground in managing PostgreSQL databases, specifically RDS AuroraSkills in Python programming, preferably version 3.13Competency in infrastructure as code using Terraform and CI/CD pipelines with GitHub ActionsAbility to analyze and optimize data pipelines for performance and scalabilityEnglish language proficiency at intermediate level or higher (B2+) TechnologiesAWS Aurora PostgreSQL is primarily used for consumer-facing APIsPython and Scala for ingestion orchestrationEmploying both batch (S3) and streaming (Kafka) ingestion methodsLeveraging DMS (and legacy Debezium) for CDC to Kafka and SnowflakePre-calculating insights in the database to meet API latency requirementsOffloading analytical queries to SnowflakeMonitoring performance and setting alerts using NewRelic We offerWith us you can:Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in UkraineReceive the necessary equipment to perform your work tasksChange projects and technology stacks within EPAMGain 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 locationsParticipate 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 managerReceive regular feedback from colleaguesImprove 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 CloudsUse the internal E-learn training program (18,200+ specialized training and mentoring programs)Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resourcesStudy at EPAM Solution Architecture School with the instructors who are practicing architectsDevelop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and moreParticipate 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 ratesCompany support during significant life events (childbirth or adoption, marriage, etc.)Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic trainingE-kids program - a free programming language training program for EPAMers' children Kindly note that this role supports remote work, but only from within Ukraine. Kindly be advised that the set of benefits, including learning, certification, and other opportunities, may vary depending on the role you apply for. Our recruiter will be able to share more details about the specific opportunity during your general interview. EPAM strives to provide its global team of over 61,700 professionals in more than 55 countries with opportunities for professional growth from day one of collaboration. Our colleagues are the source of EPAM's success, so we value cooperation, strive to always understand our clients' business and aim for the highest quality standards. No matter where you are, you will join a dedicated, diverse community that will help you realize your potential to the fullest.