ETL Developer Job in Pittsburgh 15222, Pennsylvania US
***PLEASE SEND RESUMES TO BRIA.MURRAY@MODIS.COM TO APPLY***
Our client has a need for an ETL Developer for a full-time, direct hire opportunity in Pittsburgh, PA. The client is looking for someone with heavy SSIS and Informatica experience, with a minimum of 5 years supporting data warehouse infrastructure. Qualified candidates will meet the following requirements detailed below:
Description:
Individual will be responsible for assisting in the design, maintenance and scalability of the Enterprise Data Warehouse Infrastructure solutions for the EDMC enterprise. This would include but not be limited to: data architecture, development and system process standards, logical data modeling, identification and development of and warehouse system infrastructure. Position reports to Supervisor. Data Warehouse Foundation.
Responsibilities Include, but are not limited to:
· Works closely with business and technical teams to understand, document, and design and model Business Subject Areas.
· Works closely with business teams to understand, document, design and code ETL and Reporting needs utilizing dimensional models.
· Translate source mapping documents and report requirements into Dimensional Data Models.
· Design, Develop, Test and Optimize ETL routines utilizing SQL, Bash, SSIS and/ Informatica PowerCenter.
· Assist with converting clients legacy SQL Server DW to Teradata platform.
Required Skills:
· 5+ years experience supporting data warehouse infrastructure
· 3+ years experience working with and/or creating Logical Data Models
· 2+ years experience supporting data warehouse expansion or migration
· 5+ years experience working with and/or creating dimensional models
· Physical data architecture, design, modeling, integration, and reporting experience
· 5+ years developing Business Intelligence solutions. Understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of data warehouses and data marts.
· Demonstrated best practice experience for Data Integration and Data Movement
· 3+ years experience with one or more of the following: Microsoft Business Intelligence, Oracle or Teradata.
· Must demonstrate strong verbal and written communication skills and be able to interface with all levels of business and IT organizations.
· Work well in a team-oriented environment managing multiple priorities, following a project plan and meeting project delivery dates.
· Highly organized individual with excellent decision making, analytical, problem solving and presentation skills.
· Experience working as an implementation team member with critical individual contributor responsibilities.
· Strong Problem Solving skills
· Experience with Performance Tuning
· Experience with various SDLC methodologies
· BS degree in Computer Science or MIS.
Preferred Skills:
· Education Industry experience
· Database migration experience
· Database infrastructure scaling experience
· SQL Server Integration Services
· Unix/Linux/Bash scripting
· Teradata
***PLEASE SEND RESUMES TO BRIA.MURRAY@MODIS.COM TO APPLY***