Evaluate data requirements and design logical data models using Erwin and implement physical datamodel using SQL Server. Work with Business Analysts and Senior SSIS Developers to understand the application requirements.
Create documents like data dictionaries for tables and design documents for T-SQL codes for future references. Designing and implementing database objectsviz. tables, views, sequences, SP and UDFs, Triggers and Indexes. Write complex procedures, functions and triggers to implement business logics and calculations.
Scheduled jobs in the SQL Server Agent to carry out the database maintenance activities such as database backups and consistency checks. Work with Version Control and Change management using TFS. Troubleshoot, monitor and optimize SQL codes by analyzing execution plans, SQL Profiler, Database tuning advisor, etc. Work with DW designing approaches (Ralph Kimball and Inmon), schema structures (Star and Snow flake) and Dimensional Modeling concepts is a plus.
Create SSIS packages to migrate data from heterogeneous sources to destination is a plus. Work with Agile/Scrum Design Methodology, SQL Server 2014/2012/2008R2, T-SQL programming (Stored Procedures, Triggers, UDFs, Indexes, Query Optimization, etc.), SQL Profiler and DTA, Excel, Erwin or any other data modeling tool Requirements:Master’s degree in CS, MIS, Engnrg or related ORBachelor’s degree in same fields + 5 yrs of progressive exp. as ETL Developer or related. Foreign equivalent degree ok.