Home

Job opening || SSIS Develoepr || Remote || Contract at Remote, Remote, USA
Email: [email protected]
From:

iyyappan,

Smartitframe

[email protected]

Reply to:   [email protected]

Dear,

Greetings from Smart IT Frame, Hope you are doing well!!!

Smart IT Frame specializes in enabling you with your most critical line of resources. Whether its for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide.

Role:

SSIS Developer

Location:

Remote

Duration:

Contract

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.

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

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.

Keywords: information technology microsoft
[email protected]
View all
Thu Jan 11 02:11:00 UTC 2024

To remove this job post send "job_kill 1003913" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 0

Location: ,