Pay Range: $ 60 - $ 65

Job Description:

• Design, develop, and maintain Oracle PL/SQL procedures, functions, packages, and database objects to support application solutions in an agile environment.

• Create, modify, and optimize database schemas, tables, views (including materialized views), and indexes based on business requirements.

• Perform performance tuning using tools like Explain Plan and apply best practices for normalization, denormalization, and star schema design in data warehousing.

• Develop and maintain ETL solutions using Informatica, ensuring robust and scalable data pipelines.

• Collaborate with cross-functional and distributed teams to gather requirements, perform unit testing, and ensure timely and defect-free delivery.

• Support data modeling and BI/reporting initiatives, with exposure to tools such as Tableau, Cognos, or MicroStrategy (MSTR).

Must-Haves

• Strong hands-on experience with Oracle SQL/PLSQL (v11.x and above)

• Proficiency in Informatica development and data warehousing concepts

• Solid background in data modeling (including star schema)

• Experience with BI reporting tools (e.g., Tableau, Cognos, MSTR)

• Familiarity with version control tools (SVN, Bitbucket)

• Excellent communication and self-management skills in an agile environment

Plusses

• Exposure to Unix scripting and Autosys for job scheduling

• Familiarity with SDM adoption or CI/CD tools such as Datical, Jenkins

• Experience with ETL/database testing methodologies