ID
#49573732
Job type
Permanent
Salary
TBD
Source
Maddisoft
Date
2023-03-28
Deadline
2023-05-27

Oracle PL/SQL Developer with ETL

Texas, Houston, 77001

Permanent

Vacancy expired!

Maddisoft has the following immediate opportunity, let us know if you or someone you know would be interested. Send in your resume ASAP. - U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. Looking for W2 CONTRACT, Send in resume along with LinkedIn profile without which applications will not be considered. Call us NOW!

Visa sponsorship is available for this position.

Job Title: Data Warehouse Analyst III
Location: Houston Texas- Hybrid(2 day/week onsite)

Job Description

Our Client is currently executing a project to migrate Business customers in East region from its existing billing platform to long term billing platform in SAP CCS/CRM. 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.

Essential Duties/Responsibilities:

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 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:

Bachelor's degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.

Experience: IT experience including

- 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 interact with the business team, SME, production support lead, and other team members.

Flexibility, dedication, and team-spirit is a must

Vacancy expired!

Report job