Job summary:
Title:
MS BI Developer with Foxpro
Location:
Raleigh, NC, United States
Length and terms:
Long term - W2 or C2C
Position created on 01/22/2020 03:01 am
Job description:
Interview Type: Skype *** Very long term project; initial PO for 1 year, expect to go for 4+ years *** Onsite - No Remote ***
The candidate is expected to be hands-on in writing T-SQL scripts at an expert level; performing ETL with legacy data including FoxPro, MS Access and MS Excel; processing and storing JSON strings in SQL server; re-mapping legacy data into new table structure in MS SQL; understanding complex business logic and data relationship that are embedded in the legacy data.
Required Skills:
- 8 years of experience
- Experience with data analysis and database management, maintenance, and enhancement.
- Experience designing data dictionaries, physical and logical database models; ability to interpret and migrate existing legacy database structures.
- Experience with performance tuning and logical administration of application objects within the database.
- Experience developing business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
- Experience performing database application tuning and providing business and data requirements, and data for capacity planning.
- Able to work without assistance and able to manage high complexity work efforts.
- SQL Server experience, version 2014 or newer
- 5 years of experience FoxPro, MS Excel and MS Access experience for converting to SQL Server
- Advanced understanding of ETL tools and techniques with focus on SQL Server tools
- 5 years of experience Microsoft SQL Server Integration Services (SSIS)
- 5 years of experience Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS)
- 3 years of experience Hands-on experience with JSON technology for SQL Server
- 5 years of experience Visual Studio 2015/2017
- 2 years of experience Subversion / SVN
Nice to have Skills:
- 2 years of experience
- JIRA
- State Government experience
- ElasticSearch (as an enterprise search engine)
- Experience with Agile/SCRUM development methodology
- Visio Diagrams
- Microsoft .NET Technology (C#, Entity Framework etc.)
Contact the recruiter working on this position:
The recruiter working on this position is Ajay Chappidi(Shaji Team)
His/her contact number is +(1) (202) 6290353
His/her contact email is ajayc@msysinc.com
Our recruiters will be more than happy to help you to get this contract.