Data Warehouse Developer/Analyst

Posted: 2 months ago

Job Title: Data Warehouse Developer
Job Location: Somerset, NJ
Duration: 6+ months

Description:
The Data Warehouse Developer (Senior ETL Programmer) will be responsible for the development and implementation of the data warehouse that supports the enterprise s BI initiatives. This person will be expected to have a solid understanding of the company's data model and the ability to design solutions and processes which combine disparate data into meaningful reporting and analysis that can be easily understood by customers and internal audiences. This person must have the ability to understand complex data relationships and business requirements and formulate efficient and reliable solutions to difficult problems. This person should have experience in end to end design, development, and implementation of Data Warehouse starting from requirements to the end user reports and analytics. This position must have very strong communication and analytical skills and also the ability to work with developers, DBAs, Business, and Architect. Very strong in design and implementation of star schema modeling.

Major Responsibilities:
Work side by side with business owners to define and understand business requirements related to changes and enhancements of existing enterprise data warehouse.
Understand the company s transactional system, data sources and identify the gaps in business processes and data accuracy in early life cycle of the project.
Should be able to involve in data modeling based on Dimensional Fact Model (DFM) principle Involved in managing the design of the company s data extraction, staging and loading to data warehouse processes to ensure that data is as consistent, clean and accurate as possible Involved in the technical aspects of customer requirements analysis, understand technical specification for completeness, and should be able involve in any phase of the project.
Develop technical documentation, including requirements documents, process overviews, data models, data flow. Should be involved in Cloud, ETL, PL/SQL, UNIX development and implementation wherever required Other projects as assigned by the supervisor

Qualifications:
Bachelor's degree in Computer Science or related field 8 years of industry experience with the development and implementation of enterprise-level data warehousing and supporting business intelligence initiatives, particularly focused Star Schema Data Modelling Broad expertise spanning various technologies, business process integration, enterprise data warehousing, and advanced analytics.

Preferred experience in moving data between S3, and other traditional databases.:
7 years of experience designing, developing and implementing large scale data warehousing initiatives.
7 years of experience understanding complex data warehousing performance management.
7 years of experience with database programming and design, including mastery of complex report queries and SQL optimization.
7 years of experience with enterprise-class RDBMS, grasp of advanced SQL writing and query tuning/optimization