SSIS Developer (SQL and Actimize)

Job Summary

Synechron is seeking a proficient SSIS Developer to craft, implement, and sustain reliable data integration solutions. The role is central to supporting our data-driven initiatives by designing ETL workflows, ensuring data quality, and managing complex data environments. This position contributes to the organization’s strategic goal of leveraging data assets effectively to enhance decision-making processes and operational efficiencies. The ideal candidate will bring experience in SSIS, SQL, and Actimize, working collaboratively across teams.

By delivering robust data pipelines and ensuring high-quality data management, this role supports Synechron’s growth in analytics and business intelligence capabilities.

Software Requirements

Required:

• SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT) for development and management of SSIS packages
• Microsoft SQL Server (version 2016 or later)
• Actimize (preferably Actimize AML or related modules) — hands-on experience in deployment and integration
• Data warehousing and ETL tools aligned with SQL Server environment

Preferred:

• Experience with Azure Data Factory or other cloud-based ETL tools
• Knowledge of Power BI or SSRS for reporting purposes
• Familiarity with scripting languages such as T-SQL, Python, or PowerShell for automation

Overall Responsibilities

• Design, develop, and optimize ETL workflows using SQL Server Integration Services (SSIS) to facilitate data migration, transformation, and loading
• Collaborate with business analysts, data architects, and operations teams to understand data sources, quality standards, and business needs
• Troubleshoot and maintain existing SSIS packages, enhancing performance and reliability
• Perform data validation and analysis to verify data accuracy, consistency, and completeness across systems
• Document technical specifications, data flow diagrams, and operational procedures
• Conduct performance tuning of SSIS packages, stored procedures, and database queries
• Stay informed of emerging data integration tools, best practices, and industry standards to enhance solutions

Technical Skills (By Category)

Programming Languages:

• Required: T-SQL for data querying and management
• Preferred: scripting languages like Python or PowerShell for automation and data manipulation

Databases/Data Management:

• Required: SQL Server (2016+) experience, relational database design, and data warehousing concepts
• Preferred: Knowledge of data modeling, data lakes, and cloud data stores (Azure, AWS)

Frameworks and Libraries:

• Required: SSIS package development, data transformation processes, and related tools
• Preferred: Integration with Actimize APIs and modules

Development Tools and Methodologies:

• Required: SQL Server Data Tools (SSDT), SQL Management Studio, version control systems (Git) or TFS, Agile practices
• Preferred: DevOps tools for CI/CD and deployment automation

Data Validation & Quality:

• Ensuring data accuracy, implementing quality checks, and handling data integrity issues

Experience Requirements

• Minimum of 5+ years of experience in data analysis, ETL development, or data warehousing projects
• Proven experience in designing and managing SSIS packages in enterprise environments
• Hands-on experience with Actimize platform, especially around financial services or compliance data
• Industry experience in finance, healthcare, or technology sectors preferred but not mandatory
• Alternative pathways include related roles in data integration, BI development, or platform-specific ETL solutions

Day-to-Day Activities

• Develop, test, and deploy SSIS packages for data ingestion, transformation, and loading
• Monitor ETL jobs, troubleshoot issues, and optimize workflow performance
• Collaborate with stakeholders to understand data requirements and document processes
• Conduct data validation and integrity checks across multiple systems
• Maintain and update technical documentation for data workflows and operational procedures
• Perform performance tuning of packages, SQL queries, and database objects
• Join daily stand-ups, sprint planning, and review sessions within Agile frameworks
• Support data governance and compliance initiatives by maintaining data quality standards

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Science, or related field
• Certification or hands-on experience with SQL Server and Actimize modules preferred
• Continuous learning mindset to stay updated on data integration and BI tools

Professional Competencies

• Critical thinking and analytical skills for troubleshooting complex data issues
• Capable of managing multiple tasks independently and responsibly
• Strong communication skills for cross-team collaboration and documentation
• Agile mindset with adaptability to evolving project needs
• Problem-solving orientation and meticulous attention to detail
• Ability to drive improvements in data quality and system performance

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice