• Find preferred job with Jobstinger
  • ID
    #49551212
  • Job type
    Permanent
  • Salary
    USD60 - USD70 per hour
  • Source
    Matlen Silver
  • Date
    2023-03-25
  • Deadline
    2023-05-24
 
Permanent

Vacancy expired!

Design and build to include the customers that are migrating into the existing Business customer data mart in the data warehouse (IRW) which has been implemented using Oracle PL/SQL and Unix. Design a data model for housing historical usage data and other data used in load forecasting from legacy system into IRW and include in existing interfaces to load forecasting system. Maintenance and support of existing data mart and other database applications in the data warehouse as needed.

Job Description:
  • Get knowledge transfer of current implementation of business data market. Review code to understand existing implementation.
  • Make necessary changes to existing design to bring in customers for the new East region.
  • Build to implement the change to design to include customers in East.
  • Design a data model for housing historical data from legacy system for feeding load forecasting system and other use as well.
  • Build programs to extract data from legacy system and load these tables. Learning of ETL tool (SAP data services) would be needed. Knowledge transfer would be provided to work with the tool if needed.
  • Assist with providing production support of existing data mart and database applications if needed.
  • Assist with additional PL/SQL development.
  • Willingness and cooperation in working in a fast-paced environment.
  • Work effectively in a team environment. Develop strong working relationship with the business team and individuals at all levels of the company, such as other IT groups, Operations, and Project Management team.
  • Communicate status and escalate issues as early in the process as possible.
  • Use analytics skills to troubleshoot and resolve problems quickly.
  • Ability to switch between multiple tasks and work them in parallel.
  • Willingness to take responsibility for the tasks that are assigned

Education:Bachelors degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.

Experience:- 12+ years of experience in Software development- 10+ years of experience in Oracle 11g or higher- 10+ years of experience in Oracle PL/SQL development- 5+ years of experience in Unix/Linux shell script development- 5+ years of experience in a Data Warehouse environment- 2+ years of development work in a de-regulated utilities business in Texas is a plus- 2+ years of experience with SAP data services ETL or other ETL tool.

Additional skills:
  • Excellent verbal and written communication skills are required in order to interact with the business team, SME, production support lead, and other team members.
  • Flexibility, dedication, and team-spirit is a must

About Matlen Silver

Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.

Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.

If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: //

Vacancy expired!

Report job

Related Jobs

Jobstinger