Senior SSIS Developer and Administrator

Job description

Data Engineer - Cognos - MS SSIS Developer and Admin Who We Are At Kyndryl, we run and reimagine the mission-critical technology systems that drive advantage for the world's leading businesses. We are at the heart of progress; with proven expertise and a continuous flow of AI-powered insight, enabling smarter decisions, faster innovation, and a lasting competitive edge. For our people---Kyndryls---that means doing purposeful work that powers human progress. Join us and experience a flexible, supportive environment where your well-being is prioritized and your potential can thrive. The Role Required Skills and Experience •Expertise in data mining, data storage and Extract-Transform-Load (ETL) processes •Experience in data pipelines development and tooling, e.g., Glue, Databricks, Synapse, or Dataproc •Experience with both relational and NoSQL databases, PostgreSQL, DB2, MongoDB •Excellent problem-solving, analytical, and critical thinking skills •Ability to manage multiple projects simultaneously, while maintaining a high level of attention to detail •Communication Skills: Must be able to communicate with both technical and non-technical colleagues, to derive technical requirements from business needs and problems Preferred Skills and Experience •Experience working as a Data Engineer and/or in cloud modernization •Experience in Data Modelling, to create conceptual model of how data is connected and how it will be used in business processes •Professional certification, e.g., Open Certified Technical Specialist with Data Engineering Specialization •Cloud platform certification, e.g., AWS Certified Data Analytics -- Specialty, Elastic Certified Engineer, Google Cloud Professional Data Engineer, or Microsoft Certified: Azure Data Engineer Associate •Understanding of social coding and Integrated Development Environments, e.g., GitHub and Visual Studio •Degree in a scientific discipline, such as Computer Science, Software Engineering, or Information Technology Your future at Kyndryl Every position at Kyndryl offers a way forward to grow your career, from Junior System Administrator to Architect. We have opportunities for Cloud Hyperscale's that you won't find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with clients in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here. Who You Are Who You Are You're good at what you do and possess the required experience to prove it. However, equally as important -- you have a growth mindset; keen to drive your own personal and professional development. You are customer-focused -- someone who prioritizes customer success in their work. And finally, you're open and borderless -- naturally inclusive in how you work with others. Role Overview We are seeking an experienced Senior SSIS Developer \& Administrator to design, develop, deploy, and manage enterprise-grade ETL solutions using Microsoft SQL Server Integration Services (SSIS). The role will also be responsible for administration, performance optimization, and ensuring data integration reliability across systems. Key Responsibilities SSIS Development Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL) Build scalable data integration workflows across multiple sources (SQL Server, Oracle, flat files, APIs, etc.) Implement complex transformations, data cleansing, and business rules Develop reusable SSIS components and frameworks Database \& Data Engineering Write optimized T-SQL queries, stored procedures, views, and functions Design and support data warehouse and dimensional models (Star/Snowflake schemas) Work closely with BI teams (Power BI / SSRS) SSIS Administration Deploy, configure, and manage SSIS packages using SSIS Catalog (SSISDB) Monitor package execution and troubleshoot failures Manage SQL Server Agent jobs and scheduling Perform environment migrations (Dev → QA → Prod) Performance \& Optimization Tune SSIS packages for performance (parallelism, memory, buffering) Identify bottlenecks in ETL pipelines and implement improvements Optimize SQL queries and data loads Data Governance \& Quality Ensure data quality, integrity, and consistency across systems Implement logging, auditing, and error-handling frameworks Support data validation and reconciliation processes Support \& Maintenance Provide L2/L3 production support for ETL processes Troubleshoot data issues and performance degradation Maintain documentation for ETL processes and pipelines Required Skills \& Experience Technical Skills 6--10 years of experience in SSIS development and administration Strong expertise in Microsoft SQL Server (2012/2016/2019/2022) Proficiency in SSIS, SSMS, SQL Server Agent Advanced T-SQL programming skills Experience with Data Warehousing concepts (ETL, OLAP, dimensional modeling) Hands-on with SSIS performance tuning and troubleshooting Experience with Data Migration and Integration projects Additional Skills (Preferred) Experience with Azure Data Factory (ADF) / Azure Data Integration tools Knowledge of Power BI / SSRS reporting Exposure to DevOps / CI-CD pipelines for SSIS deployments Experience using Git or version control systems Familiarity with Python / scripting for automation Soft Skills Strong analytical and problem-solving skills Ability to work independently and lead ETL initiatives Excellent communication and stakeholder management Ability to mentor junior developers Qualifications Bachelor's degree in Computer Science / IT or related field Microsoft certifications (preferred): Azure Data Engineer / SQL Server certifications Nice to Have Experience in large-scale enterprise data environments Exposure to cloud migration projects Knowledge of data governance tools Key Deliverables Reliable, high-p