SSIS Developer

Job Description

Role: SSIS Developer

Location: Palm Beach Gardens, FL

Duration: Contract

Note: Project requirement is to work in shift – 2:30pm to 11:30pm IST (for Offshore Position)

Job Description:

· Experience should be 7-10 years.

· Strong hands-on experience in MS SQL Server and SSIS along with ADF.

· Designing and building complex SSIS ETL packages in a large-scale data environment.

· Sound knowledge of performance tuning techniques in both SQL server, SSIS, and ADF.

· Must be familiar with indexes, execution plan and partitioning.

· Must have hands-on experience in writing complex stored procedures, queries, functions.

· SQL concepts should be strong – joins, constraints, merge, temp tables etc.

· bMust be aware of best practices in both SQL Server, SSIS and ADF

· Must have good communication skills, be able to work with client directly.

· Must be aware of concepts like incremental loading, parameters, variables, scripts.

· Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

· bStrong data modelling skills with solid knowledge of various industry standards such as dimensional modelling, star schemas etc

· Processing, cleansing, and verifying the integrity of data used for analysis

· Should be ready to work in the late shifts to get more timing overlap with client.

Must have Skills:

· SSIS b Expert

· T-SQL b Expert

· ADF – Intermediate level

· Communication b Good

· Tools – TFS, DevOps (ADO)

· Experience b 7-10 years

Good To Have Skills:

· Snowflake Good to have

· Git Repository Good to have

· Agile Good to have.