ApTask · 2 months ago
Junior Oracle Pl/SQL Developer
ApTask is a leading global provider of workforce solutions and talent acquisition services. They are seeking a Junior Oracle PL/SQL Developer to develop, test, and maintain PL/SQL procedures while assisting in the design and optimization of SQL queries and supporting ETL workflows.
Human ResourcesInformation TechnologySmall and Medium BusinessesStaffing Agency
Responsibilities
Develop, test, and maintain PL/SQL procedures, functions, packages, and triggers
Assist in the design and optimization of complex SQL queries for data extraction and reporting
Support ETL workflows using tools like Oracle Data Integrator (ODI), Informatica, or custom PL/SQL scripts
Participate in data migration, cleansing, and validation activities across different systems
Analyze and troubleshoot performance issues in Oracle queries and code
Work with business analysts, QA teams, and senior developers to meet data and reporting requirements
Create and maintain technical documentation related to database objects and ETL jobs
Ensure adherence to data governance and security best practices
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or related field
5 – 8 years of hands-on experience with Oracle PL/SQL
Good understanding of relational databases, data modeling, and normalization
Basic knowledge of ETL processes and tools (e.g., ODI, Informatica, Talend, SSIS, etc.)
Familiarity with data warehousing concepts is a plus
Proficient in writing, debugging, and optimizing SQL queries
Experience working with large datasets and understanding of performance tuning
Strong problem-solving skills and attention to detail
Good communication skills and ability to work in a collaborative team environment
Preferred
Exposure to Oracle 12c/19c or later versions
Experience with version control systems (e.g., Git)
Familiarity with Agile/Scrum development practices
Basic knowledge of Unix/Linux shell scripting
Understanding of data quality and data integration challenges
Company
ApTask
ApTask is a staffing and recruiting company offering staffing, project, and workforce solutions.
H1B Sponsorship
ApTask has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2020 (1)
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase