The Role
Lead the design, development, validation, and support of Romanian SAF-T D406 extracts from Oracle E-Business Suite. Responsibilities include schema and data gap analysis, staging and mapping architecture, advanced SQL and PL/SQL development, XML generation, BI Publisher configuration, performance tuning, validator troubleshooting, reconciliation to financial records, SIT/UAT support, documentation, and monthly production support.
Summary Generated by Built In
Resumes can be directly shared with [email protected]
Role: Functional Consultant - Oracle EBS Apps Technical Lead
Years of Exp: 7 - 10 Years
Location: Hyderabad || Chennai || Bangalore
Work Mode: Hybrid
Availability: Immediate Role summary
Senior Oracle EBS technical developer to build, test and support the Romanian SAF-T (D406) extract from Oracle E-Business Suite, covering the monthly/quarterly General file, the annual Assets file, and the on-request Stocks file, through to a file that passes ANAF's DUK Integrator validator.
Essential technical skillsOracle SQL (advanced)
- Analytic functions, complex joins across GL/AP/AR/FA/INV
- Native XML generation:
- Query tuning against high-volume transactional tables; explain plans, indexing strategy, partitioning awareness. SAF-T files routinely run to hundreds of MB, so performance is not a nice-to-have
PL/SQL (advanced)
- Packaged procedures registered as concurrent programs
- Bulk Collect, FORALL, ref cursors, pipelined functions
- Staging-table architecture (extract → stage → validate → generate), restartability, error logging
- utl_file and large CLOB/file handling
BI Publisher / XML Publisher in EBS
- Data templates (SQL-driven XML data definitions, group hierarchies, lexical parameters) — this matters more than RTF layout skills here
- eText and XSL-FO templates; understanding when BIP is the wrong tool for a very large XML and a PL/SQL generator is better
- Scalable mode, XML output size limits, bursting, template registration via XML Publisher Administrator
EBS applications technical (AOL/FND)
- Concurrent programs, executables, value sets, request sets, profile options
- Multi-org / MOAC handling, ledger and legal entity setup
- Custom top / CEMLI standards, patching and instance refresh implications
EBS data model knowledge — must be able to navigate without hand-holding:
- GL
- AP
- AR:
- FA:
- INV:
- E-Business Tax:
XML and schema work
- Reading and working directly against the ANAF XSD (SAF-T schema 2.0): namespaces, strict element sequencing, data types, cardinality
- Validating generated XML against the XSD outside EBS; interpreting validator errors
- XSLT useful for post-transformation
- Gap analysis between the ANAF schema and available EBS data; identifying where data simply isn't captured today
- Designing and building the extract: staging model, mapping tables, generation, validation
- Building maintainable mapping tables so finance can update account and tax code mappings without a code change
- Getting files through DUKIntegrator cleanly and resolving validator errors
- Performance tuning to fit the extract inside the month-end window
- SIT/UAT support, reconciliation to TB and VAT returns, documentation and handover
- Ongoing support against a hard monthly deadline (last calendar day of the month following the period)
Skills Required
- 7–10 years of professional experience
- Advanced Oracle SQL, including analytic functions, complex joins, query tuning, explain plans, indexing, and partitioning awareness
- Advanced PL/SQL, including packaged procedures, concurrent programs, BULK COLLECT, FORALL, ref cursors, pipelined functions, staging architectures, error logging, UTL_FILE, and large CLOB handling
- Hands-on Oracle E-Business Suite technical experience with AOL/FND, concurrent programs, executables, value sets, request sets, profile options, MOAC, ledgers, legal entities, custom tops, CEMLI standards, patching, and instance refreshes
- Strong Oracle EBS data model knowledge across GL, AP, AR, FA, INV, and E-Business Tax
- BI Publisher/XML Publisher experience with data templates, SQL-driven XML definitions, group hierarchies, lexical parameters, eText, XSL-FO, scalable mode, bursting, output limits, and template registration
- Experience working directly with XML schemas and XSDs, including namespaces, element sequencing, data types, cardinality, and external XML validation
- Experience with XSLT for XML post-transformation
- Experience building Romanian SAF-T D406 extracts and passing ANAF DUK Integrator validation
- Experience with gap analysis, mapping tables, financial reconciliation, performance tuning, SIT/UAT support, documentation, and production handover
- Immediate availability
- Ability to work in a hybrid model in Hyderabad, Chennai, or Bangalore
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Winfo Solutions is an AI innovation-led digital transformation company that helps organizations modernize operations, accelerate growth, and unlock value from data, automation, cloud, and enterprise technologies. It delivers Oracle transformation, AI-powered innovation, intelligent automation, data engineering, analytics, business intelligence, cloud modernization, managed services, and custom application development for global enterprises across industries seeking stronger business outcomes and modernized technology environments.
