IDEALFORCE has a CONTRACT position available immediately for Sr SSIS/SQL Developer to join our customer in Phoenix Arizona. This is an ONSITE position. Only LOCAL CANDIDATES are considered. Please find below additional details about this job.
Job Description-Work with developers and business users to prepare or refine requirements for data system components and implement robust, maintainable solutions that meet requirements.
-Participate in reviews and quality assurance processes to ensure that the procedures are enforced with team members.
-Create SSIS projects and packages to perform ETL related tasks and prepare SSIS projects for deployment.
-Write documentation of designs, structures and processes for internal use.
-Develop and enhance stored procedures.
-Optimize or tune performance of T-SQL queries.
-Write ad-hoc SQL queries and scripts to support various job functions and requests for reports.
-Create and maintain conceptual, logical, and physical database models.
-Design and develop meaningful business reports (BI) using SSRS of Business Objects.
-Create and support SQL Agent jobs. Occasionally troubleshoot and repair SQL Agent job issues.
QualificationsTechnology Requirements
-3yrs advanced experience with SSIS/BIDS
-3-5yrs advanced experience with MS SQL Server 2008-1014
-3yrs intermediate experience with using Windows OS
-1yr beginner experience using Powershell
-3yrs intermediate experience with Visual Studio/C#/VB
-1yr beginner experience with Non-Relational (So-SQL) DBs
Frameworks/SDLs/Methodologies
-Beginner with Event Sourcing Pattern, Event Store
-Intermediate with ETL Processing, Repository Pattern, Factory Pattern, Unit Testing
-Intermediate with .Net Framework, WCF, C#
Misc. Applications
-Beginner with MQ Series.
Additional InformationAdditional Information :
- "All your information will be kept confidential according to EEO guidelines".
- All candidates who are authorized to work in US are encouraged to apply.
- Candidates must clear the Background check prior to commencing the assignment.
THIRD PARTY CANDIDATES:
Email your candidate/s resume to joseph dot shelton at idealforce.com along with the following details: Rate, Current location and Availability.
Disclaimer :
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
Skills Required
- 3 years advanced experience with SSIS/BIDS
- 3-5 years advanced experience with Microsoft SQL Server (2008-2014)
- 3 years intermediate experience with Windows OS
- 1 year beginner experience with PowerShell
- 3 years intermediate experience with Visual Studio, C#, VB.NET
- 1 year beginner experience with Non-Relational (NoSQL) databases
- Beginner familiarity with Event Sourcing Pattern and Event Store
- Intermediate experience with ETL processing, Repository and Factory patterns, and unit testing
- Intermediate experience with .NET Framework and WCF
- Beginner experience with MQ Series
- Experience developing and enhancing stored procedures and tuning T-SQL queries
- Experience designing and developing BI reports using SSRS or BusinessObjects
- Experience creating and supporting SQL Server Agent jobs
- Authorized to work in the US and able to pass a background check
What We Do
Idealforce is a premier talent acquisition solutions provider that helps corporations find top-performing talent through innovative ways and technologies. The company offers unparalleled talent acquisition and management services, helping businesses find quality talent cost-effectively while assisting talented individuals in finding the best employers where their skills are recognized and rewarded.
