Position: SQL ETL developer
Company: EPAM
Experience required: 2y
Category: SQL
English level: intermediate
Published: 2021-09-01T00:00:00+03:00

Our US based customer has different sources of data. Data about buildings, residential and commercial. The purpose of project is ETL implementation. Extract data from different sources and using SQL Server Integration Services, transform and load to MS SQL server. Target database is data source for highly loaded service, which provides building property information for many applications. Agile environment. Team: 1 onsite ETL team lead and 2 ETL developers in Kyiv.

Responsibilities
design new and redesign already existing tables
ETL transformation implementation
stored procedures and function creation
tuning queries performance
possible business trip to Milwaukee, US

Required
SQL Server (most likely 2012), SSIS, T-SQL querying
SQL Server Scripting, data analysis and testing
SQL Server code troubleshooting, debugging
Good collaboration and communication including English

Nice-to-Have
SQL Server SSRS and MDS are plus
T-SQL query performance tuning is plus
Informatica (PowerCenter, Data Quality etc.) is plus
Agile SDLC, Microsoft TFS is plus