Required skillset

• A resource 10 years of experience in Database Development and Data warehousing with the following skills
• Writing complex SQL queries to extract data from multiple sources, and capture change.
• Experience in Oracle PL/SQL (including advanced SQL, functions, procedures, packages)
• Testing and debugging Oracle functions, procedures, packages, and jobs to ensure they meet quality standards
• Documenting the source to target mappings
• Designing and developing reports, dashboards, and data visualizations using Tableau/PowerBI
• Experience in Linux-based shell scripting
• Experience in Oracle ODI is desirable, but is not a must
• Proficiency in data modeling for data warehousing using tools like E/R Studio or Erwin.
• Proficiency in designing conceptual, logical and physical data models.
• Strong communication and problem-solving skills

Please submit the skill matrix for all requirements along with the resume.

• Database Development:
• Data warehousing:
• Oracle PL/SQL (including advanced SQL, functions, procedures, packages):
• Writing complex SQL queries:
• Testing and debugging Oracle functions:
• Proficiency in data modeling for data warehousing using tools like E/R Studio or Erwin:
• Proficiency in designing conceptual, logical and physical data models:

Job Types: Full-time, Contract

Pay: $60.00 - $63.00 per hour

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Experience level:

• 10 years

Schedule:

• 8 hour shift

Work Location: In person