What are the responsibilities and job description for the Oracle PL/SQL Developer (Local to IL only) position at Sidmans?
Job Description:
Core Responsibilities:
- Data Ingestion & Data Migration: Design, Develop and Test data migration scripts
- Transformation Rules: Identify and Implement data mapping, data cleansing, and data masking rules
- Data Quality Assurance: Code and execute validation rules for data accuracy
- Collaboration: Participate in team collaboration and Support QA and End user testing
- Documentation: Develop and maintain documentation
Technical Skills:
- Oracle Database & SQL: Strong knowledge of database architecture and SQL, writing queries, joins, subqueries, and views
- PL/SQL Development: Experience with stored procedures, functions, packages, and triggers
- Performance Tuning: Understanding of indexes and query tuning techniques
- Data Migration: Experience with ETL (Extract, Transform, Load) and data cleansing techniques