SSIS Developer

Good to have Snowflake

Good knowledge of T-SQL, including the ability to write stored procedures, views, functions etc..

Good experience in designing ,developing, unit testing and implementation of data integration solutions using ETL in SSIS and SSRS reporting platform

Experience with data warehousing concepts and enterprise data modeling techniques

Good knowledge of relational and dimensional database structures, theories, principles and best practices

Conduct thorough analysis of existing MSBI (Microsoft Business Intelligence) legacy applications and Informatica PC

Identify and document the functionalities, workflows, and dependencies of legacy systems

Create detailed mapping specifications for data integration and transformation processes

Collaborate with business stakeholders/architects and data modelers to understand their needs and translate into technical documentation

Ensure accurate documentation of data sources, targets, and transformation rules

Perform data validation, cleansing, and analysis to ensure data accuracy and integrity

Update the Design documents after successful code changes and testing

Provide Deployment support

Possess good knowledge of Agile and Waterfall methodologies

Requirements

Bachelors degree in computer science, Engineering, or a related field

Highly skilled at handling complex technical situations and have exceptional verbal and written communication skills

5+ years experience with understanding of data lifecycle, governance, and migration processes

5+ years experience with SSIS, SSRS (or Informatica PC) and MS SQL Server, TSQL

5+ years experience with Data Warehouse technologies

3+ years experience with Agile methodologies (Scrum, Kanban, JIRA)

Nice to have experience in wealth management domain