Essential Duties and Responsibilities:
- Support all Oracle EBS database administration including installation, configuration, capacity planning, and maintenance.
- Contribute to upgrading/migration of Oracle E-Business suite R12 on various platforms.
- Support all environments with high availability using various Oracle 19C features: Grid control, Data guard, OEM, Diagnostics, tuning, provisioning, RAC, and Automatic Storage management (ASM).
- Manage schemas, objects, partitioning tables, and indexes.
- Optimize and tune SQL queries using TXPROF and EXPLAIN PLAN, as well as PL/SQL tuning.
- Configure and administrate backup and recovery in Oracle Database.
- Improve and maintain customer SLAs on requests/tickets etc.
- Utilize shell scripting to engineer enhancements to monitoring.
- Develop and write computer programs to store, locate, and retrieve information, create, modify, and test the code, forms, and script that allow computer programs to run.
2. Skilled in implementing complex ETL transformations including joins, lookups, filters, conditional logic, and aggregations.
3. Proficient with Talend Hierarchical Mapper (tHMap) for handling hierarchical formats like EDI, XML, and JSON.
4. Skilled in HIPAA EDI transactions and experienced with X12 standards covering segment ,elements, qualifiers, codes, loop , and companion guide interpretations.
5. Skilled in debugging and resolving X12‑related tHMap mapping errors with a strong understanding of EDI structure and validation rules.
6 .Skilled in building high‑performance Talend Jobs to process large‑volume datasets with accuracy.
7. Proficient in developing reusable Talend Jobs that enhance standardization, reduce redundancy, and improve overall maintainability.
8. Skilled in developing efficient SQL queries to support ETL data extraction, transformation, validation, and performance tuning.
9. Experienced in integrating REST and SOAP APIs for data exchange.
10. Skilled in working with XML and JSON datasets within ETL pipelines.
11 .Experienced in implementing robust error‑handling mechanisms including exception capture, rejection flows, and logging.
12. Strong in performing data validation, data quality checks, and ensuring end‑to‑end data integrity.
- Bachelor's degree in relevant field of study and 3+ years of relevant professional experience required, or equivalent combination of education and experience.