Datawarehouse Analyst III

For over 15 years Trilyon has been at the forefront of providing comprehensive global workforce solutions and staffing services. Leveraging our extensive expertise across multiple domains such as Cloud technology Salesforce AI Machine Learning and Technical Writing we consistently exceed expectations in catering to a wide range of requirements.

Currently we are seeking a Datawarehouse Analyst III for one of our clients that is a leading multination corporation.

Job Title: Datawarehouse Analyst III

Location: Houston TX (Monday Tuesday and Thursday)

Duration: 6 months contract with high possibility of extension.

Design develop test maintain and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.

Essential Duties/Responsibilities:

• Develop Oracle PL/SQL applications.
• Create Oracle PL/SQL packages stored procedures and functions. Create database objects like tables views triggers types synonyms based on requirements. Create new applications or enhance existing applications to produce commissions reports.
• Work with Manager/IT Lead to understand requirements create technical design analyze source tables and relationships adhere to consistent coding/SVN standards and provide daily status updates.
• Work with the Commissions analyst to understand the existing calculations process for each workstream and build test and UAT according to their expectations.
• Use Oracle Analytical functions MERGE statements WITH clause Partitioning Job logging File handling External tables and Exception handling in the Oracle PL/SQL code.
• Optimize code by following performance tuning techniques and coding standards established within the team.
• Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server
• Perform Unit testing and end to end System testing of the Oracle PL/SQL application. Prior to UAT submission test and compare the reports to Production calc. reports and identify and fix discrepancies.
• Use analytics skills to troubleshoot and resolve problems quickly
• Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
• Have code reviewed with IT lead prior to moving the code to QA environment
• Create ControlM/Redwood job documents create Change requests and work with ControlM/Redwood to get them created and scheduled.
• Use ServiceNow ticketing system for opening handling and closing tickets and change requests.
• Follow SOX procedures for code deployment.
• Perform production support.
• Monitor batch processes daily/weekly/monthly and resolve job failures as soon as possible to meet established SLAs.
• Work with ControlM/Redwood group on rerun/restart instructions.
• Be willing to perform this off hours during weekdays and weekends.
• Fulfill adhoc requests for data pull table updates or minor enhancements.
• Work effectively in a team environment.
• Develop strong working relationship with team members Manager Commissions team analysts DBA team Project Manager and other IT groups.
• Independently work on tasks without the need for step by step Supervision
• Communicate progress or issues clearly either verbally or through email.
• Escalate issues or delays that would impact deadline as early in the process as possible.
• Must be local to Houston or TX and be willing to come into the downtown office Monday Tuesday and Thursday of every week

Education:

Bachelors degree in computer science software engineering or relevant business discipline from an accredited fouryear college or university.

Experience:

• 15 years of experience in Software development
• 12 years of strong development experience using Oracle PL/SQL including experience using features like Analytical functions merge statements WITH clause oracle partitioning job logging exception handling performance tuning
• 12 years of experience in Oracle 12c or 19c
• 5 years of experience in a Data Warehouse environment
• Strong Analytical skills
• Troubleshooting skills
• Strong Team Player

Additional skills:

Flexibility Dedication Consistency Integrity and Enthusiasm a must.

Equal Employment Opportunity

Trilyon is an Equal Opportunity Employer committed to fairness and respect for all individuals. We value diversity in age disability ethnicity gender gender identity religion and sexual orientation believing it drives innovation and better service. Employment decisions are made impartially without regard to any protected characteristic under federal state or local law. Our diverse team drives innovation competitiveness and creativity enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.

Name: Vikranth Yadavalli

Email: