ETL Developer
Life Extension 10 reviews - Fort Lauderdale, FL

This job posting is no longer available on Life Extension. Find similar jobs:ETL Developer jobs - Life Extension jobs

This role is responsible for designing and developing the Central Data Repository for aggregation of RDBMS and File Data Repositories. Additionally, this role monitors and evaluates database performance and utilization, initiating corrective and improvement action as needed.

Core Duties and Responsibilities:
• Designs and develops Staging Database loaded from Central Data Repositories to staging and from staging to the Destination tables applying different transformations
• Ongoing activity to help eliminate duplicate data from systems
• Designs SSIS Packages using several transformations to perform Data Profiling, Data Cleansing and Data Transformation
• Creates jobs and schedules packages using SQL Server Management Studio for national change of address updates, customer batch uploads, data warehouse ETL packages, etc.
• Monitors ETL jobs and provides performance metrics to Database Administrator and IT Management
• Works with the Database Administrator to proactively monitor the database systems to ensure secure services with minimum downtime
• Participates in customer support and data integrity issues when escalated
• Reviews project requests describing database warehousing and ETL functions needed, appropriately estimating time and cost required to accomplish project
• Assists with development, testing and implementation of disaster recovery plan
• Responsible for maintaining service logs, incident logs, support documentation, Visio’s of all ETL packages and Data Warehouse Environments
• Configuration of comprehensive event monitoring solution for incident notification in support of ETL packages and Data Warehouse environments
• Works closely with corporate development teams; responsible for physical ETL design, query tuning, troubleshooting and problem solving
• Works with DBA to develop, design, test and implement effective backup and restore techniques
• Maintains up to date knowledge on latest technology trends
Position Requirements:
• Bachelor’s degree in computer science and/or equivalent experience in data processing and analytics, computer information systems, RDBMS systems, SQL Server, systems analysis or computer programing
• 5+ years of experience in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources to load into various business entities
• Proven ability in designing and translating Data Models and Data Flow Diagrams
• Experience documenting ETL environment procedures and policies
• Working knowledge of SSRS and BI concepts and methodologies
• Working knowledge of Executive Information Systems, Decision Support Systems and Data Mining iterations as specified by BI
• Proven ability to code and implement complex business rules in MS SQL, Triggers and Stored Procedures
• Expertise in OLTP/OLAP System Study, developing Database Schemas (i.e. Star Schema, Snowflake Schema) used in relational, dimensional and multidimensional modeling
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Knowledge of Slow Changing Data (SCD) principles (Levels 1-6) to maintain historical data
• Ability to work on multiple projects simultaneously
• Excellent communication skills; both verbal and written; ability to effectively communicate complex technical matters to individuals possessing varying levels of computer literacy
• Ability to work with limited supervision (with reasonable latitude for decision making)
• Ability to work as a contributing participant on a cross-functional team
• Intermediate knowledge of Windows system administration; basic LAN/WAN networking knowledge
• MCITP: Database Developer certification a plus
• Experience managing the backend database for JD Edwards Oneworld 9.x/8.x ERP a plus
Technical Requirements:
• DBMS/DBMS (SQL Server 2008/2005/2000, MS Access and MSDE)
• Database Tools (SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2008/2012, SQL Enterprise Manager, T-SQL, Data Transformation Services, ODBC, OLAP, MOLAP, ROLAP, OLTP, BCP)
• Data Modeling (Visio Professional 2010/2013)
• Reporting Tools (Crystal Reports, SQL Server Reporting Services, MS Excel)
• Operating System/Server (Windows XP/Windows &, Windows Server 2003/2008, IIS 5/6)
• Analysis Services (MS SQL Server Analysis Services 2005/2010, DashBoard for BI)
• ETL Tools (Data Transformation Services – DTS, SQL Server Integration Services – SSIS)
• .NET Frameworks (.NET Frameworks 3.5/4.0)

About this company
10 reviews
Life Extension Retail - Home