Oracle PL/SQL Technical Specialist

Job description: HCLTech is looking for a highly talented and self‑motivated to Oracle PL/SQL Technical support data modernization, migration, and analytics enablement initiatives. This role focuses on building scalable ETL pipelines, migrating legacy data to cloud platforms, and ensuring data quality and reliability. Job Details Req ID / Demand ID: 108375Job Title: Sr. Data Engineer (Informatica / Oracle)Experience Level: 10+ YearsPosition Type: Full‑time Key Responsibilities 10+ years of hands-on experience in Data engineering, data warehousing and analytics technologiesExpert-level knowledge of writing complex SQL queries using Oracle.Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers)Strong working experience in ETL tools like Informatica (Power Center)Working experience in scripting and automation using Unix, Python in a Data Engineering environment.Extensive experience with Relational Databases like Oracle including being able to implement performance tuning techniquesStrong working knowledge of Datawarehousing patterns and Dimensional Modelling techniques using Oracle.Experience building scalable patterns for data integration in a cloud-based as well as on-prem environmentsWorking knowledge of Batch scheduling tools like Control-M, Autosys.Experience with business intelligence and analytics tools such as OBIEE/OASWorking experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice.Working experience using GenAI tools like GitHUB Co-PilotExperience working on projects in an Agile environment Skill Requirements Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) requiredOracle SQL (Advanced / Complex Queries)Oracle PL/SQLInformatica PowerCenter (ETL)Data WarehousingRelational Databases – Oracle SecondaryUnix Shell ScriptingPython (Data Engineering / Automation)Batch Scheduling ToolsCloud & Hybrid Data Integration PatternSource Code ManagementAgile Methodologies Other Requirements OBIEE/OAS, GitHub Copilot, GenAI exposure   Pay and Benefits   Pay Range Minimum: 109000 Pay Range Maximum: 168000   HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@hcltech.com for investigation.       Compensation and Benefits   A candidate’s pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.