Job ID: VA-621697 (98290219)
Azure Datalake Developer with PL/SQL, SQL Tuning, Oracle/SQL Server, Toad, SQL PLUS, SQL Developer, TFS, Databricks, Devops, .net, Web API and SSIS/SSRS/SSAS experience
Location: Richmond VA (VDOT)
Duration: 12 months
Interview: In-person
SkillRequired / DesiredAmountof ExperienceExpertise Rating
Write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production,Required3Years
Strong development experience and/or equivalent development skills, knowledge and work historyRequired3Years
SQL Statement Tuning and AnalysisRequired3Years
Oracle 11g/ 12C PL/SQL, Toad, SQL PLUS , SQL Developer and any other Development ToolsRequired3Years
SQL Server 2014 Development SkillsRequired6Years
Source Code and Team Management software (TFS preferred)Desired2Years
Azure Datalakes and Data AnalysisRequired2Years
Datalake tools, Databricks and DevopsDesired2Years
Bachelor’s Degree in Computer Science or Information SystemsNice to have
.net Development, Web API Developer, & Web ServicesDesired3Years
SQL Server Integration Service (SSIS)Required3Years
SSRS and SSASDesired3Years
VDOT is looking for a Mid Level VDOT Azure Datalake Developer, who will be working with the following responsibilities.
implement end-to-end data solutions in Azure.
implement ETL and data movement solutions using Azure Data Factory and SSIS
help business users analyze data as well as providing data insight to upper management
Design, build and deploy effective SSIS packages, Azure Data Factory
Implement stored procedures and effectively query a SQL Server database
Translate requirements from the business and analyst into technical code
Identify and test for bugs and bottlenecks in the ETL solution
Ensure the best possible performance and quality in the packages
Provide support and fix issues in the packages ETL/ELT Developer
Development Skills in Oracle PL/SQL, .Net
Design relational models for small and large scale applications
Provide data analysis and validation
Identification of performance issues on production and testing systems
PL/SQL and SQL Tuning and Optimization of newly develop and existing applications
They will work with the Teams which are working on Agile Development, Devops and TFS. We will consider, if the candidate have any working knowledge/experience in those areas.