Job Description:
- Experience with and deep knowledge of Visual Studio 2012 and later, SQL Server Integrations Services (SSIS), SQL Server Data Tools (SSDT), and SQL Server Management Studio (SSMS).
- Experience with performance profiling and optimization of SSIS, SQL Server queries, stored procedures, triggers, and functions.
- Perform data cleansing/scrubbing and transformation of data to ensure data quality.
- Develop SSIS packages to extract, transform and load data to enterprise-level data warehouses and data mart databases.
- Use various containers, tasks, transformations, connection managers, script task to develop SSIS packages.
- Gather requirements working with business analyst, developers, database architect and business users.
- Developed complex and extended stored procedures and user defined functions in SQL Server.
- Optimize existing SSIS packages with options like delay validations, buffer sizes, parallel processing and maximum concurrent executions etc.
- Experience deploying SSIS packages into various environments (development, test, and production).
- Experience with the import and export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
- Experience with Sybase ODBC connectivity, queries, stored procedures, and triggers desired but not required.
- Experience with all areas of .NET development including server-side, client-side, data retrieval, and management.
- Good communication skills.
- Analytical and problem-solving skills.
- Develop technical changes / enhancements based on specifications provided.
- Research, test, and recommend how to properly adopt new technologies.
- Ensure that all development projects adhere to strict development guidelines including testing, acceptance and rollout by implementing change management controls.
- Design conceptual, logical, and physical databases for use with SSIS.
- Participated in designing and implementing logical data models for data warehouse.
- Experience with Azure DevOps desired.
- Bachelor of Science degree in Computer Science preferred. A comparable degree and/or experience is acceptable.
- Minimum three years of development using .NET (C# and SQL), Microsoft SQL Server, TSQL, SSIS, Stored Procedures, database functions required.
Sign-Up for your account with PROHIRES POWERHOUSE Recruiting Portal to broadcast requirements & hotlists.
ReplyForward