Title: SQL/SSIS Developer
Location: Des Moines, IA
Interview Type: In Person Only
Experience Required:
· Solid experience with Microsoft SQL Server 2008 R2 and above
· Developing packages with SSIS
· Strong knowledge of XML, schemas
· T-SQL language (queries, views, procedures)
· SQL Reporting Services
· Strong analytical/mathematical and reasoning skills.
· Ability to work in a team environment
· Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision
· Strong written and verbal communication skills
· Large-scale data migration experience
· Data warehousing concepts
Experience Preferred:
· Agile Methodology
· Understanding of RDBMS and Data Warehouse designs
· SQL Server database troubleshooting and query optimization
· SQL Server Database Design
· SQL Server Stored Procedure Design and implementation
Job Description:
Seeking an ETL Developer with extensive experience with SQL and SSIS. The ideal candidate will have the ability to troubleshoot and problem-solve with a strong sense of urgency. This person should be a self-starter, able to work both independently and cooperatively as required. The successful developer must be able to understand business requirements, data and concepts. State government experience is a definite plus.
Responsibilities:
• Refine business requirements into technical requirements and specifications
• Design and develop SSIS packages, database objects, tables, stored procedures and views
• Performance tuning the stored procedures and T-SQL.
• Communicate accurate and useful status updates
• Manage and report time spent on all work activities
Skill Matrix:
|
Required / Desired |
|
|
|
Candidate of Experience |
Last Used |
|||
|
Solid experience with Microsoft SQL Server 2008 R2 and above |
Required |
8 |
Years |
|
|
|||
|
Developing packages with SSIS |
Required |
8 |
Years |
|
|
|||
|
Strong knowledge of XML, schemas |
Required |
8 |
Years |
|
|
|||
|
T-SQL language (queries, views, procedures) |
Required |
8 |
Years |
|
|
|||
|
SQL Reporting Services |
Required |
8 |
Years |
|
|
|||
|
Strong analytical/mathematical and reasoning skills. |
Required |
8 |
Years |
|
|
|||
|
Ability to work in a team environment |
Required |
8 |
Years |
|
|
|||
|
Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision |
Required |
8 |
Years |
|
|
|||
|
Strong written and verbal communication skills |
Required |
8 |
Years |
|
|
|||
|
Large-scale data migration experience |
Required |
8 |
Years |
|
|
|||
|
Data warehousing concepts |
Required |
5 |
Years |
|
|
|||
|
Agile Methodology |
Desired |
|
|
|||||
|
Understanding of RDBMS and Data Warehouse designs |
Desired |
|
|
|||||
|
SQL Server database troubleshooting and query optimization |
Desired |
|
|
|||||
|
SQL Server Database Design |
Desired |
|
|
|||||
|
SQL Server Stored Procedure Design and implementation |
Desired |
|
|
Thanks & Regards,
Mohammad Sazid
Email: saz...@r2techcorp.com
D:470-242-7345 ex 303| O:248-522-7855
R2 Technologies | www.r2techcorp.com
6515 Shiloh Rd, Unit 110, Alpharetta GA, 30005