ETL Developer

CCS Global Tech   •  

Poway, CA

Industry: Data Storage

  •  

5 - 7 years

Posted 377 days ago

Job Description:

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.