SQL Server Developer-w2 Apply
Job Title: SQL Server
Developer
Location: Charlotte, NC
Type of Position: Contract
Required Skills:
·
Understand the requirements to convert the
technical document part of SDLS process
·
SSIS on SQL Server 2014 and 2017 and SQL Server
2017 is must.
·
Large volume of data extractions from different
sources such as SQL Server , oracle, flat files and data lake
·
Good knowledge of SSIS performance
·
He/she need to take care end to end SSIS ETL
process ( Create, debugge SSIS packages, Error handling and deployment to the
server)
·
strong experience in T-SQL and
Dynamic SQL , stored procedures ( large SP inside all dynamic code able to
debug it)
·
Good experience in Oracle Database – 2 year
·
Experience in developing Enterprise Data Marts
on deploying and delivering
·
Hands on development/ unit / integration
testing on ETL
·
Attention to detail on delivery, code reviews,
onsite offshore
·
Good knowledge of understanding Large and
complex SQL queries and do the SQL performance and optimization
·
Understand the very good experience in
relational model and data warehouse models
·
Knowledge of agile process
·
Banking domain knowledge is plus.
Roles/Responsibilities:
·
Understand the requirements to convert the
technical document part of SDLS process
·
Work with SSIS packages
·
Work on large volume of data extractions from
different sources such as SQL Server , oracle, flat files and data lake
·
Take care of end to end SSIS ETL process (
Create, debugg SSIS packages, Error handling and deployment to the server)
·
Work with the Oracle Database
·
Work with Enterprise Data Marts on deploying and
delivering
·
Attention to detail on delivery, code reviews,
onsite offshore
·
Understanding Large and complex SQL queries and
do the SQL performance and optimization
·
Understand the relational model and data
warehouse models
·
Work with agile process.