What are the responsibilities and job description for the SQL Server DBA/Data Warehouse position at Vector Talent Resources?
Job Description
Location: Client: Contract Duration : Benefits: Pay:
SQL Server ETL Developer
Qualifications -- Knowledge, Skills and Abilities:
• Extensive experience designing and deploying data integration (ETL) solutions in a data warehousing, BI environment involving complex data transformations, change, data capture, and error handling.
• Advanced experience with SQL Server ETL Development and its related tools (SSIS, SSRS, SSMS, Visual Studio), including extracting, transforming, and loading data from various data sources and APIs.
Advanced experience with production SSIS packages troubleshooting and development.
• Solid hands-on experience and knowledge of ETL technology in use in projects.
• Strong coding expertise with extensive knowledge and understanding of the systems development life cycle (SDLC).
• Excellent SQL programming is required as well (SQL, PowerShell, JavaScript, HTML, etc)
• Solid hands-on experience and knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, master data, and metadata.
• Advanced knowledge in applying appropriate test methodologies and QA processes which includes writing test plans and test cases
• Experience with source code controls such as GIT or ADO
Desired Qualifications:
• Experience in Python or other programming languages
Vector Talent Resources is an Equal Opportunity/Affirmative Action employer. All qualified candidates will receive consideration for employment without regard to disability, protected veteran status, race, color, religious creed, national origin, citizenship, marital status, sex, sexual orientation/gender identity, age or genetic information.
Recommended Skills
- Database Design
- Performance Tuning
- Sql Server Integration Services
- Stored Procedure
- Database Development
- Sql Server Analysis Services
