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

PRN Healthcare

Nursing - Travel MedSurg/PCU RN Job at PRN Healthcare

 ...Description PRN Healthcare is seeking a travel nurse RN PCU - Progressive Care Unit for a...  ...named Pete Hietpas. Pete was diligently working in eastern Wisconsin with a variety of...  ...Hours ~ Continuing Education ~401k retirement plan ~ Referral bonus ~ Employee... 

Vietranslate

Remote interpreter - Need Chinese Job at Vietranslate

Vietranslate is recruiting interpreters for Over the phone interpretation job (on laptop) working online (remote)Company informationVietranslate(3 Song Thuong St, Ward 2, Tan Binh Dist, Ho Chi Minh City):Language pair:- English Chinese (Mandarin/Cantonese)- English Korean... 

Beihai Haicao Decoration Co., Ltd

ESL English teachers Job at Beihai Haicao Decoration Co., Ltd

 ...degree at least2.Certifications 3.Mother tongue is the best.4.If you have more than two years experience as an ESL teacher,that will help you a lot on teaching kids.5.Everyone in our group will be treated so well.PLEASE notice hereWe can provide 1.45 class at... 

Workoo Technologies

Work From Home Data Entry Jobs No Experience Remote - Part-Time Job at Workoo Technologies

About the job Data Entry Jobs No Experience (Remote)Entry-level job - Remote Work From Home. Full or part-time placements readily available from home. With or without experience we encourage all applicants to apply. We are seeking candidates curious about collaborating... 

PerformYard

Manual QA Tester Job at PerformYard

 ...where you come in! As a key member, the Manual QA Tester will work closely with product managers, developers, and QA engineers to test new features, identify bugs, and help ensure a smooth experience across our platform. You'll play a key role in validating product changes...