SSIS Developer (SQL and Actimize)
SSIS Developer (SQL and Actimize)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 organizations 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 Synechrons 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
- Bachelors 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
SYNECHRONS 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 applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.
Employment Type
Full-Time
