Senior SSIS Engineer
EPAM Systems
This job is no longer accepting applications
See open jobs at EPAM Systems.See open jobs similar to "Senior SSIS Engineer" FinTech Australia.Remote
Posted 6+ months ago
Senior SSIS Engineer Description
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.
#LI-TG3Responsibilities
- 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
We offer
- We connect like-minded people:
- Delivering innovative solutions to industry leaders, making a global impact
- Enjoyable working environment, whether it is the vibrant office or the comfort of your own home
- Opportunity to work abroad for up to two months per year
- Relocation opportunities within our offices in 50+ countries
- Corporate and social events
- We invest in your growth:
- Leadership development, career advising, soft skills and well-being programs
- Certifications, including GCP, Azure and AWS
- Unlimited access to LinkedIn Learning, Get Abstract, O'Reilly, Cloud Guru
- Free English classes with certified teachers
- We cover it all:
- Participation in the Employee Stock Purchase Plan
- Monetary bonuses for engaging in the referral program
- Comprehensive medical & family care package
- Five trust days per year (sick leave without a medical certificate)
- Benefits package (sports activities, a variety of stores and services)
This job is no longer accepting applications
See open jobs at EPAM Systems.See open jobs similar to "Senior SSIS Engineer" FinTech Australia.