EXPLORE PREMIER
OPPORTUNITIES
As a skilled professional seeking career growth, you deserve access to the best job opportunities available. Join Outdefine's Trusted community today and apply to premier job openings with leading enterprises globally. Set your own rate, keep all your pay, and enjoy the benefits of a fee-free experience.
About the job
Overview:
We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in understanding the business requirements and delivering the deliverables to the business users. Design, develop, and support PL/SQL, ETL processes for loading data from external as well as internal systems using SQL Loader and External tables.
Job Overview
Location: Onsite - Guadalajara, MX Long term Contract - Full Time Mandatory: 8+ years of experience Experience with: PLSQL, Postman, Linux/Unix, WinSCP/Putty Hiring Process: 3 rounds (Video intro, HR interview, Technical Interview)
Roles and Responsibilities:
Should have hands on experience and be able to guide the team of developers.
Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
Extensively worked on creating database objects including tables, indexes, views, sequences, packages. Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.
Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.
Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language) .
Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements.
Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.
Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.
Handled a project where it involved building a process for BEx Team.
Required Skills:
Should have sound experience with calling API thru PLSQL procedures and able to debug API code & test API utilizing Postman
Should have good exposure to Linux/Unix, Shell Scripting & XML
Good experience in using WinSCP & Putty
Knowledge or experience with scheduling tools like Control-M
Good understanding on Ansible script (YAML creation) &a Monitoring jobs
Flexible working hours (able to work in shifts, if needed)
Must have hands on experience in coding and be able to guide the team of developers.
Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.
Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.
In order to apply for this position, first complete your profile on www.outdefine.com.
We want to learn more about you, so we encourage you to provide us with a brief summary of yourself and your past experience as part of the process. As soon as this is completed, you'll take a technical assessment based on your skill set, and if you pass, you'll earn 500 Outdefine tokens. We will review your application, and if you are qualified, we will invite you to a 1:1 video interview.
Already a Trusted Member of Outdefine? Then go ahead and apply directly for the job of your dreams.
Become a trusted member, apply to jobs, and earn token rewards
Create and customize your member profile.
Earn 500 Outdefine tokens for becoming trusted member and completing your assessment.
Once you are a Trusted Member you can start applying to jobs.