Job Opportunity for Senior Enterprise Data Specialist

JOB DESCRIPTION
Position- Senior Enterprise Data Specialist Location- Remote India Employment- Full time Business Unit- Digital Data & Technology About Patona Enterprise Patona Enterprise is an IT services and consulting company specializing in Cloud, Data, Networking and Infrastructure solutions, with operations across Australia and India. About the Client Treasury Wine Estates (TWE) is one of the worlds leading premium wine companies. Its dedicated Global Capability Centre (GCC), operated by Patona Enterprise, works with teams across Australia, the United States, EMEA and APAC on enterprise technology and digital transformation initiatives. Role Overview The Senior Enterprise Data Specialist will work closely with TWEs enterprise data and business application teams to manage the movement, transformation and quality of data between JD Edwards (JDE), TWEs ERP platform, and connected third-party and downstream applications. This is a hands-on, business-facing role combining SQL/database development with business analysis and data process understanding. The role requires the ability to develop and optimise SQL queries, stored procedures and data integration processes, while also understanding how data is used across business applications, identifying downstream impacts and working directly with business stakeholders. The role is expected to have a balanced focus across technical delivery and business-facing analysis.

Key Responsibilities
SQL Development, Database Management & Performance
- Develop, maintain and troubleshoot complex SQL queries, stored procedures, functions and database processes using Oracle SQL/PLSQL and Microsoft SQL Server/T-SQL.
- Write and optimise SQL used for extracting, transforming, validating and loading data across enterprise applications.
- Analyse query execution plans and diagnose performance issues, including full table scans, inefficient joins and indexing opportunities.
- Improve database and query performance through appropriate tuning techniques, indexing, statistics and query refactoring.
- Maintain reliable, reusable and well-documented SQL code and data processes. Enterprise Data Integration & ERP Data Flows
- Build, maintain and support data extraction and integration processes that move data into and out of JDE and connected applications.
- Develop and support ETL scripts, stored procedures and workflows to transform ERP data into formats required by downstream systems.
- Understand source-to-target mappings, data dependencies and end-to-end data flows across applications.
- Support data migration, cleansing, transformation, loading and integration activities using appropriate tools and technologies.
- Work with application and technical teams to investigate integration failures and resolve data-related production issues. Business Analysis, Data Quality & Stakeholder Engagement
- Engage directly with business users and application owners to understand business processes, data requirements and the intended use of information.




- Translate business requirements into data mappings, SQL logic, technical specifications and practical implementation solutions.
- Understand how users interact with data and how information moves between business applications, including planning and finance-related processes.
- Assess proposed additions or changes to data attributes and identify their impact on JDE, downstream applications, reports and business processes.
- Establish and perform data validation, reconciliation and quality controls to protect data accuracy, completeness and integrity.
- Act as a point of coordination between business stakeholders and technical teams on data-related changes, issues and enhancements. Testing, Change & Production Support
- Plan and execute unit testing and support system and user acceptance testing (UAT), including investigation and resolution of defects.
- Coordinate changes through appropriate development, testing, approval and production deployment processes.
- Assess deployment risks and dependencies to minimise disruption to existing integrations and downstream applications.
- Troubleshoot production issues independently, communicate progress and coordinate with relevant teams where escalation is required.
- Maintain clear technical documentation, data mappings, process flows, test evidence and operational procedures. Required Skills & Experience
- At least 7 years of relevant IT experience in SQL/database development, enterprise data integration, data engineering or a closely related role.
- Strong hands-on experience in both Oracle SQL/PLSQL and Microsoft SQL Server/T-SQL.
- Demonstrated ability to independently develop complex SQL queries, stored procedures and database processes.
- Strong understanding of relational databases, joins, data structures, query execution plans and SQL performance tuning.
- Practical experience with ETL, data integration, data migration and data transformation.
- Experience in data validation, reconciliation, troubleshooting and implementing data quality controls.
- Ability to understand end-to-end data flows, source-to-target mappings and dependencies between enterprise applications.
- Strong analytical and problem-solving skills, with the ability to investigate unfamiliar data or application issues.
- Good communication skills and confidence engaging directly with business users, application owners and technical teams.
- Ability to work independently, manage competing priorities and take ownership of assigned deliverables. Preferred / Advantageous Experience
- Experience with JD Edwards (JDE)



ERP is highly desirable; experience with SAP or another large enterprise ERP platform is also relevant.
- Experience with ETL/integration tools such as SSIS, Talend, IBM DataStage, Azure Data Factory or similar.
- Exposure to enterprise applications supporting finance, procurement, sales planning, inventory planning or demand planning.
- Experience in enterprise data management, master data management (MDM) or data governance.
- Strong Microsoft Excel skills; Microsoft Access experience is an advantage.
- Experience in Supply Chain, FMCG/CPG, manufacturing, retail, finance, insurance or the wine industry.
- Familiarity with AI-assisted tools for SQL development, analysis or troubleshooting is an advantage. What Success Looks Like
- Reliable and efficient SQL and data integration processes supporting the flow of information between JDE and connected applications.
- Accurate, complete and reconciled data with appropriate quality controls.
- Clear understanding of business data flows and the downstream impact of data changes.
- Effective collaboration with business and technical stakeholders, from requirement clarification through testing and production release.
- Timely, independent resolution of data and integration issues, with improvements to process efficiency and performance. Role Profile We are looking for a senior SQL and enterprise data professional who combines robust hands-on database development skills with business process understanding. The successful candidate will be comfortable writing and tuning SQL, supporting ERP data integrations, investigating data issues and working directly with business stakeholders. This role is suited to someone who can take ownership, connect technical data work to business outcomes and operate effectively across multiple applications. If you are interested in exploring this opportunity, please share your updated CV along with the following details to my email ID
- [email protected] (Mandate to Reply below Questions in detail) 1. Total IT experience and relevant database development experience? 2. Years of hands-on experience in Oracle SQL/PLSQL and MS SQL Server/T-SQL? 3. Experience developing complex SQL queries, stored procedures, functions and packages? 4. Experience in SQL performance tuning and query optimization? 5. Which ETL tools have you worked with (SSIS, Informatica, ADF, Talend or others)? 6. Have you worked with ERP systems such as JDE, SAP or other enterprise applications? 7. Experience in data integration, migration, source-to-target mapping and reconciliation? 8. Have you worked directly with business stakeholders to gather requirements and understand data processes? 9. Have you assessed the impact of data changes on downstream applications and handled testing, UAT and production deployment? 10. Current CTC: 11. Expected CTC: 12. Notice period: 13. Earliest joining date: 14. Reason for job change: 15. Current

location:
Looking forward to hearing from you. Regards Ishita Majumder
- Senior HR Consultant Patona Enterprise (Formerly Known as Doryo Technologies Pvt Ltd.)

📌 Senior Enterprise Data Specialist | Patona Enterprise- Remote (Pune)
🏢 Doryo Technologies India
📍 Pune