BI/ SQL Developer w/ Hadoop-Charlotte, NC - Georgia IT Inc.
Charlotte, NC
About the Job
Title : BI/ SQL Developer w/ Hadoop
Location : Charlotte, NC
Duration : Contract (18-24 months)
Rate : DOE
US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp.
Skills Required:
Role/Responsibilities:
Location : Charlotte, NC
Duration : Contract (18-24 months)
Rate : DOE
US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp.
Skills Required:
- SQL
- SSIS to Hadoop transfer
- Great communication
- BI development
Role/Responsibilities:
- Creating complex SSIS packages to pull the data from different sources as required (Access, XML, CSV, Sparc, Splunk, etc)
- Assist other teams with SQL development
- Develop queries, stored procedures, views, triggers, and other database objects to support internally hosted applications
- Monitor and fix system issues (blocking, deadlocks, bad plans)
- Work with DBA's to help troubleshoot system issues and assist in DB deployment
- Assist with migration of SQL Server 2012 to SQL Server 2016
- Assist with migration of SQL Server 2012 to Hadoop
- Look for ways to leverage technologies to alleviate SQL dependencies (FULL TEXT search, Elastic search, etc.)
- Recommend, test, and prototype new version control methods
- Assist with data import and exports
- Review code from the team and provide expert assistance when needed
- Good DB design skills
Source : Georgia IT Inc.