16 Apr
Data Warehouse Developer
Rhode Island, Lincoln , 02865 Lincoln USA

Vacancy expired!

Title: Data Warehouse Developer

Description: Design, develop, implement, and support corporate data analytics initiatives and solutions using existing and emerging technologies. Develop scalable and comprehensive enterprise analytics solutions including extraction of data from multiple sources, transforming data according to business rules, and loading data into operational and presentation model under general supervision. Design, implement and support data warehouse and data mart structures including the verification of the integrity, accuracy and quality of warehouse data, map data between source systems, data warehouse repositories and data marts. Support daily operations, monitor performance, debug issues and fine-tune data processes to optimize performance on an on-going basis. Utilize and maintain technical and applications expertise, including the use of technologies, tools, programming standards, established processes, and concepts necessary to develop quality IT solutions for the section's primary areas of responsibility. Provide coverage and support of production application systems.

Requirements:Master's degree in Computer Science, Computer Engineering, Information Technology, Information Systems or a closely related field, and three years of experience performing database development and data management; or, in the alternative a Bachelor's degree in Computer Science, Computer Engineering, Information Technology, Information Systems or a closely related field, and five years of experience performing database development and data managementExperience, which may be gained concurrently, to include each of the following:
  • 3 years of data warehouse / ETL development experience in a BI/Data Warehouse environment with involvement in design and architecture.
  • 3 years of experience developing scalable and comprehensive enterprise analytics solutions including extraction of data from multiple sources, transforming data according to the business rules, and loading data into the operational and presentation model.
  • 3 years of experience mapping data between source system and Data Warehouse repositories, including identifying the data elements in source systems and creating a mapping document for extracts to be loaded in data warehouse.
  • 3 years of experience developing ETL solutions utilizing tools such as IBM Infosphere Datastage and SSIS, including requirements gathering, analysis, design, development, implementation, support, maintenance, and technical recommendations for enterprise solutions.
  • 3 years of experience writing complex and advanced SQL, optimizing large and complicated SQL queries for performance tuning to analyze and resolve performance issues within variety of operational environments.
  • 3 years of experience working with Teradata database and its architecture including different types of indexes (PI, SI, JI), partitioning, statistics, explain plan and Teradata load utilities (TPT, FastLoad, FastExport, MLoad, TPump).
  • 3 years of experience working with other databases like Sql server, Oracle, MongoDB, IBM DB2.
  • 3 years of experience performing Unix shell scripting to provide automation solutions for new and existing processes to achieve high ETL performance and reduce errors.
  • 3 years of experience maintaining and monitoring the team's incidents, problems, defects, and all work requests using the BMC Remedy & JIRA tools.
  • 3 years of experience working with batch job schedulers such as ZEKE, Control-m.
This position is eligible for Employee Referral Program award bonus.

Job site: 25 Amica Way, Lincoln, RI 02865.

Vacancy expired!


Report job