ETL DeveloperHunters Hub Inc.

Description * Key Job Functions and Duties:
 Establish and enforce data warehousing standards to meet requirements and business needs
 Evaluate existing subject areas stored in the data warehouse and determines where data should
be stored
 Review ETL programs for compliance with best practices, standards, enterprise architecture and
documentation requirements, ETL process, programs and scripts
 Perform quality assurance testing of data integration and report development and monitor data
load operations to ensure accuracy
 Analyze data and processes to create automated solution using ETL.
 Develop ETL packages that will read data from different sources which will then be processed
General skills:
 SQL Oracle development experience
 Hands-on experience with NoSQL databases
 Experience pulling data from a variety of data source types
 Dimensional modeling experience
 Experience interfacing with business users and understanding their requirements
 Strong Project Management skills
Desired Experience & Qualities
 Five years' ETL development, preferably for large, complex data sets
 Experience with MS SQL Server Integrations Services (SSIS), MS SQL Server Reporting Services, MS
Visual Studio (BIDS) and MS SQL Server Management Studio (SSMS)
 Solid experience in analyzing query performance issues and modifying data structures or
application code to remedy performance problems
 Knowledge of logical and physical data modeling concepts (relational and dimensional)
 Highly skilled in SQL development and capable of writing complex and efficient query and stored
procedures.
 Experience of Cloudera Hadoop, Apache HIVE or Spark
Qualifications and Accreditations:
 Experience with Hadoop Components - HDFS, Spark, Hbase, Hive, Sqoop is highly desired.
 Experience with OLAP, SSAS and MDX
 Experience of Informatica PowerCenter or competitor platforms is a plus
Requirements * Minimum education level: Bachelor ́s Degree
Years of experience: 3
Availability for travel: No
Availability for change of residence: No
BestJobs