ETL Developer Job at Mindlance, Albany, NY

U2QyWDF3TzVxdXNxakhkMm9Xd1cwcHErREE9PQ==
  • Mindlance
  • Albany, NY

Job Description

Provide a short description of the Position: These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and analytics. Additionally, these positions respond to all data warehouse and BI related ad hoc inquiry requests, development of dashboard features, and development of BI technical solutions for continued reporting requirements. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: 1. Gather and validate of BI and reporting requirements 2 .Document requirements & solutions 3. Perform Data profiling on the source systems 4. Design and review star schema dimensional model to support data warehouse and data marts 5. Perform Source to Target Mapping between source system database and data warehouse target database 6. Develop ETL transformations using the ETL tools like Pentaho Data Integration (PDI), or SQL Server Integration Services (SSIS) 7. Develop reports and analytics using the tools like SQL Server Reporting Services (Pentaho or Tableau, Power BI) 8. Develop complex queries using Transact-SQL leveraging analytic functions 9. Perform necessary Testing 10.Complete Documentation Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans. Mindlance

Job Tags

Similar Jobs

Neiman Marcus Group Careers

Selling Assistant, Personal Shopping Job at Neiman Marcus Group Careers

 ...the iconic store at 5th Avenue and 58th Street-the crossroads of fashion-is a singular destination for discerning customers around the...  .... Bergdorf Goodman is part of Neiman Marcus Group.Your RoleAssist the Personal Stylist in preparing and executing selling appointments... 

Insight Global

Entry Level CAD Designer Job at Insight Global

Our client is looking for an Engineering Technologist to join their Major Projects team. This role will be in the office creating a variety of work order for clients in the power utilities space. This company provides full training, room for growth and exposure to different...

24HRPO

Rigger Job at 24HRPO

 ...seeking a skilled and experienced Rigger to join our team in Newport News, VA. The ideal candidate will have a solid background in rigging operations, ensuring the safe and efficient movement of heavy materials. This role requires expertise in various rigging techniques... 

Holland America Line

Sommelier Job at Holland America Line

 ...o Maintains visible presence throughout the department at all times and encourage meaningful and strong guest interaction by the Sommelier and the Beverage team.; Promotes efficiencies in time management and resources through holding structured, documented and concise... 

Fancy Apartments LLC

Apartment Locator (ATX) Job at Fancy Apartments LLC

 ...Job description Fancy Apartments is keen on hiring a skilled Real Estate Agent Apartment Locator to contribute to our sales team's growth. As an Apartment Locator, you'll focus on expanding the Fancy Apartments brand by assisting clients in finding apartments throughout...