This position offers the chance to contribute to the design, development, and maintenance of ETL processes while providing support for data-related issues. The successful candidate will play a key role in optimizing data workflows and collaborating with cross-functional teams to resolve technical challenges., We are seeking a skilled and experienced Senior SSIS Developer to join our team. This role requires a deep understanding of SQL Server Integration Services (SSIS), database management, and data integration best practices. While the primary focus is on development, the role also involves some support responsibilities to ensure smooth operational workflows.
* Development Responsibilities:
- Designing, developing, and maintaining SSIS packages for ETL processes. - Collaborating with stakeholders to gather requirements and provide technical solutions. - Monitoring and optimizing ETL workflows to ensure efficiency and reliability. - Maintaining and updating technical documentation for developed processes. - Performing regular data integrity checks and troubleshooting.
* Support Responsibilities:
- Investigating and resolving missing file and connectivity issues. - Assisting in queries about production interface statuses. - Monitoring and resolving failed jobs and batch processes. - Making minor configuration updates, such as schedule changes. - Reviewing and deploying new interfaces in production. - Conducting routine system health checks and monitoring. - Logging and maintaining support tickets to track resolution progress., We offer a range of tailored benefits that support your physical, emotional, and financial wellbeing. Our Learning and Development team ensure that there are continuous growth and development opportunities for our people. We also offer the opportunity to have flexible work options.
* Extensive experience with Microsoft SQL Server Integration Services (SSIS).
* Strong SQL/PLSQL skills, including query optimization and troubleshooting.
* Proficiency in designing and implementing ETL workflows.
* Knowledge of database design, indexing, and performance tuning.
* Solid understanding of batch processing and job scheduling.
* Experience with protocol standards such as SFTP, and FTPS.
* Familiarity with Windows Command Prompt and PowerShell scripting.
* Experience with debugging and logging in SSIS.
* Experience with scripting or programming languages (e.g., C#, Python, Java, or VBA)., Knowledge of cloud-based ETL platforms like Azure Data Factory.
* Familiarity with API development and integration.
* Advanced Excel skills, including macros and automation.
* Experience with data visualization tools such as Power BI or Tableau.
* Understanding of data warehousing concepts and methodologies.
We're a business with a global reach that empowers local teams, and we undertake hugely exciting work that is genuinely changing the world. Our advanced portfolio of consulting, applications, business process, cloud, and infrastructure services will allow you to achieve great things by working with brilliant colleagues, and clients, on exciting projects.
Our inclusive work environment prioritises mutual respect, accountability, and continuous learning for all our people. This approach fosters collaboration, well-being, growth, and agility, leading to a more diverse, innovative, and competitive organisation. We are also proud to share that we have a range of Inclusion Networks such as: the Women's Business Network, Cultural and Ethnicity Network, LGBTQ+ & Allies Network, Neurodiversity Network and the Parent Network., Head of Managed Service As the Head of our Managed Services Practice for UK&I, I am responsible for the delivery of our full range of Managed Services covering; Service Desk, Digital Workplace, Cloud/Infra, Applications and Data Platforms. My Team and I are also responsible for continually developing our capabilities, services and market offerings which are delivered through a blend of on/near/offshore delivery locations. View LinkedInLocation The Skypark 5, Level 4B, 45 Finnieston Street, Glasgow, G3 8JU "Upon joining the NTT DATA UK family, you will experience a culturally diverse organisation living our values of Clients First, Teamwork and Foresight as we partner with our customers every day. At NTT DATA UK, we are proud to support and invest in our people. We offer a variety of rewarding career paths and opportunities to develop professionally - with access to cutting edge innovation."