Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 10th Nov 2020
Position: Senior SSIS developer
Location: Oaks, PA
The position is for a Senior SSIS developer with a strong SQL Server (TSQL) development background.
• Must have 8+ years of experience in T-SQL and high proficiency in SQL scripting, queries, and coding best practice.
• Must have a minimum of 8 years of experience with SSIS development. Including C# scripting for SSIS.
• Proven Optimization skills. Good understanding of SQL Server Profiler, Indexes, etc.
• Expert in MS SQL 2014/2016/2017, SSMS.
• Expert in reading query execution plan and recommend optimization.
• Proven debugging skills in TSQL code and SSIS.
• Experience in analyzing the business requirements for data file requests, designing, developing and deploying fully automated SSIS jobs to produce data files.
• Design, create, and implement database systems based on the end users requirements.
• Experience with end-to-end solution for file creation and distribution, as well as supporting ETL production processes and operations.
• Create complex functions, scripts, stored procedures and triggers to support application/SSIS development.
• Knowledge of SSAS & SSRS is an added advantage.
• Identify and analyze code, performance issues and suggest resolutions.
• Good knowledge on Data warehousing concepts and implementation.
• Experience on handling volume of data.
• Participate on special initiatives and teams when required.
• Team player and ready to help when the help is required, with in team or another team. Collaborate with developers and DBAs on database design.
• Must have ability to collaborate with developers and work with minimal supervision.