We are seeking a skilled Senior SSIS Engineer to join our team for an enterprise data warehouse project. In this role, you will be responsible for developing and supporting ETL code in SSIS, ensuring robust and maintainable solutions that meet project requirements.

If you have a proven track record of working with SQL Server 2014, 2016, or 2017, and possess a strong understanding of best practices for data integration, we encourage you to apply.

Join our dynamic team and contribute to exciting projects that shape the future of data engineering.

Responsibilities

• Develop queries and stored procedures using T-SQL
• Understand and analyze requirements to develop, test, configure and deploy SSIS packages
• Use the SQL Server 2014, 2016 or 2017 experience to implement robust, maintainable solutions that meet requirements
• Evaluate large and complex data sets
• Troubleshoot SSIS packages to address critical production issues
• Create tables, assign permissions, import data and perform app configurations
• Manage source code versioning and deployment
• Write and maintain technical documentation

Requirements

• 5+ years of SSIS / SSRS experience
• Proven 5+ years of expertise writing T-SQL’s, Stored Procedure, and Complex Queries using the Microsoft SQL Server
• 8+ years of SSIS proficiency in developing ETL applications
• Data warehouse development competency using SSIS/SQL best practices including the development of reconciliation and validation frameworks
• Ability to utilize of best practice SSIS design patterns
• Knowledge of best practices for loading a data into normalized and/or Star schemas
• Skills in interfacing programmatically with a variety of enterprise systems
• Familiarity with source code management systems (TFS)
• Self-sufficiency in completing high-quality work, without significant guidance
• B2+ English level, both verbal and written

Nice to have

• Knowledge within the insurance business space

EPAM Georgia is a team of innovators united by a passion for technology. The dynamic and inclusive culture we embrace helps positively impact our communities, clients, and employees. Here you will collaborate with multi-national teams, contribute to numerous cutting-edge projects, deliver the most creative solutions, and have an opportunity to learn. Our people are at the heart of our success, and we are proud to provide talents with a solid ground to develop and grow.