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 |