Data warehouse developer

Location: Chicago, Illinois
Posted On: 3/20/2017
Job Code: 3994_etl
Job Description
Its a fulltime role where Data Warehouse Developer is responsible for data integration from internal and external source systems into the Enterprise Data Warehouse (EDW) of client.
Essential Responsibilities:
• In collaboration with other team members, this position will specify, analyze, design, implement and test integration packages to meet business needs.
• Analyze the business requirements and evaluate data available and needed by data profiling and source-target mappings for business requirements
• Design the data collection, data staging, data movement, analytics delivery, data quality and archiving strategies
• Develop, test, and implement ETL processes to transform the data.
• Develop detailed technical specifications and ETL documentation
• Comply to internal standards and guidelines
• Performance tune new and existing packages
• Diagnose and fix bugs, performance, and security issues
• Maintain systems in accordance with best practices to improve security, reliability and resilience of the systems in production.
Category:IT  code:new
Job Requirements
Required Skills
• Visual Studio
• SQL Server
• T-SQL Queries, Stored Procedures, Views
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS) 2012, MDX. DAX
• SAS Data Integrator, BASE SAS
• Modeling for Analytics and Databases
• Utilizing tools for automation of data warehouse development and maintenance
• Using tools that allow for continuous testing and automated delivery
• Working knowledge of Business Intelligence warehouse modeling utilizing Kimball Methodology

Not Ready to Apply?
Contact Details
Purvi Mehta
E-mail Address