Title: SQL Server Database Developer [BizID#6782]
Location: Bellevue, WA (Remote)
Experience: 8+ years
Job Description:
The candidate should have hands on ETL experience to develop data interfaces for extracting, cleaning, transforming and loading data into data warehouse/SQL Server destination using SQL Server functions and procedures to read data from Multi formatted Flat files, Excel etc.,.
- Strong experience with performance tuning of SSIS jobs, T-SQL and database custom scripting
- Good understanding of joining and querying data from SCD Type 2 tables
- Experience in writing complex T-SQL queries, functions, stored procedures, common table expressions (CTE), etc.,
- Should have strong experience in reverse engineering ETL logic from already implemented code
- Strong experience with implementing SQL Server Procedures, functions, and DB triggers
- Peer review the code, design, test automation, etc.,
- Experience in working in onsite and offshore model
- Ability to monitor SQL Server jobs, debug and resolve any production issues on a daily basis
- Strong experience in using SSIS to load data from flat files to SQL Server destination
- Must have experience in using SSIS package configurations, variables and parameters
- Strong experience with performance tuning and daily monitoring of SSIS jobs
Primary Skills / Responsibilities:
- Understanding of business and project requirements
- Ability to communicate with client effectively and directly when needed
- Follow industry best practices while coding and unit testing.
- Excellent problem solving and analytical skills
- Stay updated with current technologies and coding methodologies.
- Should be able to implement as per provided solution
- Should appreciate the Agile methodology
- Should be competent to manage working in tight schedules
Desired Skills:
- 6+ years of industry experience in SQL Server DWBI technologies including SQL Server backend scripting and SSIS
- Experience working with Cloud technologies like Microsoft Azure is a plus
- Should have experience working with Agile methodology
- Should be self-motivated and Smart working
- Candidate should have excellent communication skills both oral and written
- Should be willing to learn.
- Should be B.E, B.Tech, MCA, M.Sc. qualified
Technical Skills :
- SQL Server (T-SQL)
- SSIS
- SQL Server backend scripting
- Performance tuning
- Data warehouse application design and Data Modelling
- SQL Server jobs monitoring and troubleshooting
Secondary Skills :