Pl/SQL Lead
hace 3 semanas
We are looking for a technical lead with 5+ 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.
**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) & 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.
- Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to migrate data from one database (SQL Server) to Oracle platform
Pay: From $40,000.00 per month
Ability to commute/relocate:
- 44610, Guadalajara, Jal.: Reliably commute or planning to relocate before starting work (required)
**Language**:
- English (required)
Work Location: Hybrid remote in 44610, Guadalajara, Jal.
-
Pl/SQL Developer
hace 4 días
Guadalajara, México BONbLOC A tiempo completoWe are looking for a PL/SQL developer with 4+ Yrs exp. **Roles and Responsibilities**: - 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...
-
Talend-data Integration Lead
hace 5 días
Guadalajara, México U hi A tiempo completo**Talend - Data Integration Lead** SQL Knowledge, with have databricks and PySpark : Offshore. - Minimum of 8+ Years experience as Data Integration Lead. - 4+ Years of experience of hands on in Talend. - Good Knowledge in SQL. - Should be able to work with customer directly/individual contributor. - Should be flexible to work in overlapping US...
-
Tech Lead
hace 2 días
Guadalajara, México Manpower Mexico A tiempo completoÚnete a Experis IT, una empresa líder en tecnologías de la información que conecta de manera efectiva al talento más competitivo con grandes empresas en México, Norteamérica y Europa. Puesto Vacante**:Tech Lead** **Requisitos**: Experiência comprobada de 5 años en Java 8, Sping boot, AWS, SQL o en arquitectura. Nível de inglés...
-
Outdefine Tech Lead Híbrido Confidential 29/Feb/2024
Encontrado en: Jooble MX O C2 - hace 3 semanas
Guadalajara, Jal., México Lapieza.io A tiempo completoAcerca de Outdefine Outdefine es una comunidad de talento web3 que conecta a los mejores talentos con empresas y corporaciones de vanguardia a nivel global. Las empresas eligen contratar a Miembros Confiables de Outdefine porque sus habilidades y preparación han sido demostradas. Cuando aceptas un trabajo como Miembro Confiable, conservarás todo tu...
-
Oracle Adf
hace 4 días
Guadalajara, México Consultora TI A tiempo completo**Vacante para la empresa Consultora TI en Remoto -Guadalajara, Jalisco**: Empresa Líder en Tecnologías de la Información con con presencia en México, está en la búsqueda de talento TI como: Oracle BPM **Zona: Remoto desde méxico** **ESCOLARIDAD**:Ingeniería en sistemas o afín, titulado o pasante **Experiência: 3**años como mínimo Oracle SOA...
-
Etl Developer
hace 2 días
Guadalajara, México Praxis A tiempo completo**PRAXIS **is a leading company that seeks to strengthen companies through the use of specialized methodologies and tools and with a focus on consulting, integration, outsourcing, and systems development. We're looking for a **ETL DEVELOPER** for our financial client. LOCATION: Mexico (Remote) **QUALIFICATIONS** - 5-8 Year of Informatica PowerCenter...
-
L2/L3 Support Engineer
Encontrado en: Talent MX C2 - hace 3 semanas
Guadalajara, México Capgemini A tiempo completoL2/L3 Support Engineer (L2/L3 Support Engineer, MEXICO) At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts...
-
Aws-redshift - Big Data Lead
hace 3 días
Guadalajara, México Valce Talent Solutions A tiempo completoHexaware, an international company is searching for an experience AWS - Big Data Lead with a great english and the motivation to keep growing. **Requirements**: - Depth knowledge and extensive experience to build batch based woekloads on AWS using AWS EMR, AWS GLUE, AWS Athena, AWS Dynamo DB, AWS REDSHIFT, AWS RIDS, AWS Aurora. - Experience building S3...
-
Lead Generation Specialist
hace 4 días
Guadalajara, México Intersog A tiempo completo**ABOUT THIS ROLE** The **Lead Generation Specialist** is responsible for the delivery of a comprehensive suite of multitouch campaigns and programs that leverage both inbound and outbound tactics. You will orchestrate integrated campaigns that support Intersog’s lead generation efforts to fuel our business development pipeline, helping to achieve our...
-
Lead Netsuite Developer
hace 5 días
Guadalajara, México Sourceability A tiempo completoSourceability® is a global digital distributor of electronic components transforming how modern businesses bring products to market. With innovation, quality and logistics as the backbone of the company, Sourceability's cutting-edge products and services expedite the procurement process across a wide range of industries, including communications/cellular,...
-
L2/L3 Support Engineer
Encontrado en: Jooble MX O C2 - hace 3 semanas
Guadalajara, Jal., México Capgemini A tiempo completoAt Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and...
-
Databricks Service Lead
hace 2 días
Guadalajara, México AstraZeneca A tiempo completoAt AstraZeneca, we put patients first and strive to meet their unmet needs worldwide. Working here means being daring, thinking big and working together to make the impossible a reality. If you are swift to action, confident to lead, willing to collaborate, and curious about what science can do, then you’re our kind of person. We are looking for a...
-
Especialista ERP
hace 4 días
Guadalajara, México AIRREF PROYECTOS A tiempo completoSomos una empresa 100% mexicana comercializadora de Aires Acondicioandos Actualmente nos encontramos en búsqueda de talento como: CONSULTOR DE IMPLEMENTACIÓN ERP **Requisitos**: - Licenciatura en Informática Administrativa, Ingeniería en Sistemas Computacionales, Ingeniería en Desarrollo de Software, afín (pasante o titulado) - Experiência mínima...
-
Oracle WMS Developer
hace 3 días
Guadalajara, México Integrass A tiempo completoJob Title : Oracle WMS Developer Job Location : Remote Job Type : Long Term Contract Position Summary **Qualifications**: - 4 Year degree in an IT related field. - Strong skills in SQL, PL/SQL, SQL Tuning, Oracle Forms, JSON, and Unix commands. - Experience with database concepts and ability to read data models. - Strong problem solving, analysis,...
-
Technical Lead Uk Tech Company Guadalajara
hace 4 días
Guadalajara, México Prometeo Talent A tiempo completo**Tech Lead** **About Us**: **Prometeo Talent** is a leading HR agency known for excellence in talent acquisition services. With a proven track record, we collaborate with diverse companies to propel them toward strategic goals. **Prometeo Talent** is currently engaged in a strategic collaboration with a** UK-based company** that is embarking on a new...
-
Lead Administrator
hace 5 días
Guadalajara, México Wipro Limited A tiempo completoOverview: **_ Role Purpose_** - The purpose of this role is to provide significant technicalexpertise in architecture planning and design of the concerned tower(platform, database, middleware, backup etc) as well as managing itsday-to-day operations_ **Responsibilities & Minimum Qualifications**: **B.S/M.S in Computer Science or a related technical field 8+...
-
DBA Oracle
hace 4 días
Guadalajara, México Daksha Group A tiempo completo**IMPORTANTE EMPRESA DE TECNOLOGIAS DE LA INFORMACION CON PRESENCIA EN LATINOAMERICA, INDIA Y E.U. TE ESTA BUSCANDO COMO** **DBA ORACLE (SHARPEX)** - **REQUISITOS**:_ - Experiência: 5 años - Escolaridad: Ingeniería en sistemas o a fín - Idioma: Inglés conversacional - **CONOCIMIENTOS**:_ - Soporte de producción 24x7 - Base de datos Oracle (Oracle 10g...
-
Lead .NET Full Stack Developer
hace 1 día
Guadalajara, México Estrada Consulting Incorporated A tiempo completoEstrada Consulting, Inc. is currently accepting consultant resumes for **Lead.NET Full Stack Developer that are currently available for the Hybrid model in Guadalajara, MX.** - The position will require work Hybrid model in Guadalajara, Jalisco MX. Position is a direct hire for our company Estrada Consulting, Inc. - Education: Prefer Bachelor's degree in...
-
Tech Lead
hace 4 días
Guadalajara, México Prometeo Talent A tiempo completo**Prometeo Talent** is currently engaged in a strategic collaboration with a **UK-based company with 5 offices globally and 350+ employees, that is embarking on a new chapter in Mexico.** As part of this exciting partnership, we are actively seeking a dynamic and skilled **Tech Lead** to join the team. This pivotal role will be integral in overseeing...
-
IT Technical Lead
hace 3 días
Guadalajara, México Jabil Circuit A tiempo completoAt Jabil we strive to make ANYTHING POSSIBLE and EVERYTHING BETTER. With over 260,000 diverse, talented and dedicated employees across 100 locations in 30 countries, our vision is to be the most technologically advanced and trusted manufacturing solutions provider. We combine an unmatched breadth and depth of end-market experience, technical and design...