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.