Ms Visio: 4 years (Preferred)
SQL,SSIS: 4 years (Preferred)
Gratiture Solutions is looking for SQL & SSIS Developer with 6+ Years of experience. It is an incredibly unique and challenging role and provides immense opportunity to implement a variety of available data transformations.
Required skills:
· Over 6+ years of technical experience in Information Technology Arena and specializing in Data warehousing/Business Intelligence. Well versed in customer facing roles, client interaction, and communication and managing client expectations in accordance with scope, time, and effort.
· Possess strong knowledge of ETL and Reporting design/development activities with knowledge and experience in working on:
o MS SQL Server Business Intelligence Tools - SSIS, SSRS
o Tools - MS Visio, TFS, Excel
o Databases - Microsoft SQL Server 2005, 2008, 2012
· Certification in Microsoft Certified Technology Specialist and Microsoft Certified IT Professional: Business Intelligence Developer
· Experience with database design applications, including Visio and Erwin.
· Strong ability to analyze user requirements into technical solutions according to specifications.
· Strong understanding of relational database structures, theories, principles, and practices.
Responsibilities:
· Analyze user specifications for workability, completeness, and business flow
· Participate in defining System Design, Architecture and Specifications Responsible for writing SSIS packages in SQL server 2012.
· Gather requirements and design of data warehouse and data mart entities.
· Index creation and performance tuning.
· Design and implement tables, functions, stored procedures, views, and triggers in SQL Server 2008.
· Create database structure in Visio
· Analyze and create data dictionary
· Works with business process experts to help identify functional requirements
· Supports Data Mapping Phases with proper technical analysis
· Designs and plans testing and reporting for the impact assessment of additional functionality
· Analyzes impact of future topology changes in the environment
Job Types: Full-time, Contract
Pay: $100,000.00 - $120,000.00 per year
Benefits:
Schedule:
Supplemental Pay:
COVID-19 considerations:
Associates will be enabled with an option to work remote owing to the COVID -19 Pandemic.
Experience:
License/Certification:
Work Location:
Company's website: