Sr. Data Warehouse Developer – Albany NY #12058 64 views

Sr. Data Warehouse Developer – Albany NY #12058

Stellargy Services a company offering over 20 years of IT Recruiting experience is currently seeking a Sr. Data Warehouse Developer for a client of ours in Albany, NY.  This is a contract to hire position.

Job Description:

Involved in design and development of repository (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration with the client.

  • Creation/ maintenance of the STAR schema which forms the framework of the OBIEE front end reporting platform.
  • Work with client to perform and validate OBIEE installations/upgrades.
  • Design build and test new OBIEE reports including BI Publisher, Dashboards, Answers, etc.
  • Researches and resolves technical problems associated with the reporting applications.
  • Create/ Update ETL Informatica jobs to load data from internal and external systems to the data warehouse.
  • Create warehouse tables and extend warehouse columns to bring in new source system changes.
  • Validate the data in the warehouse against the source systems.
  • Work with client to perform and validate Informatica PowerCenter 9.x installations/upgrades.
  • Participate in defining and provide guidance on best practices for developers.

 Background & Experience Required:

  • Bachelor’s degree from an accredited college or university or equivalent experience.
  • 7 years of experience in ETL development, data warehousing and data modeling.
  • Working knowledge in all phases of ETL development life cycle.
  • Has experience developing and maintaining Extraction, Transformation and Loading scripts using Informatica tool.
  • Has experience converting Business Information into Data Models.
  • Has knowledge in Data Flow Diagrams and ability to articulate Data flows in both business and IT terms from upstream application to downstream application.
  • Proven analytical skills.
  • Report development using OBIEE Analytics/Dashboard
  • Experience with Informatica.
  • Technical Skills / Knowledge Preferred: Oracle 11G; SQL; Knowledge of OBIEE.
  • Subject Matter Expertise/Experience Required.
  • Experience in performance tuning and loading optimization.
  • Ability to create technical documents and requirements.

Stellargy Services, LLC is an equal opportunity employer and affords equal opportunity to all applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identify, sex, marital status, sexual orientation, mental disability, use of a guide dog or service animal, military/veteran status, citizenship status, the basis of genetic information or any other group protected by Federal or State law or local ordinance.

Apply for this job
Share this job

Stellargy Services, LLC.

Certified Texas HUB and Woman-owned WBENC certified company, Stellargy Services brings extensive experience within governmental and Fortune 500 entities, supporting their project and staffing needs.

Contact Us

Austin, TX 78735
(512) 394-3444

Home Job 2

Find Your Dream Job Now!