Job Information
Beacon Hill Staffing Group, LLC Oracle PL/SQL Developer in Saint Paul, Minnesota
Job Description (for distribution): Required Technical Skills:
- Excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages.
- Extensive proficiency in the modern RDBMS products - Oracle (latest version). PostgreSQL is a plus
- Experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter, Data Transformation and Informatica B2B Data Exchange products. Strong in Informatica design concepts using its products
- Strong ETL and data modeling experience. Proficient in creating mappings, workflows and implementing ETL concepts
- Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL
- Experience of using Standard Oracle Packages (UTL_FILE etc.), Dynamic SQL, Records, Arrays, PL/SQL tables, File handling
- Experience in SQL and PL/SQL Performance Tuning, query rewriting, use of Explain Plan and Hints
- Expertise in Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, External tables
- Solid experience and comfortable with UNIX/ Linux platform and sufficient commands
- Agile working experience with Scrum and SDLC methodologies and the best practices. Experience with Atlassian products such as JIRA, Confluences, BitBucket
- Thorough working experience of DevOps, UC4, Maven, Jenkins and CI/CD
- Experience of the best practices utilizing object oriented analysis and design principles
- Good knowledge of the programming language and framework, such as Java, Angular or React, JPA, Spring Boot, XML and JSON. Knowledge and experience with API gateway (such as Gravitee) is a plus
- Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications
Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply. If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/ Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records. Company Profile: Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs. Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles. Learn more about Beacon Hill Staffing Group and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.beaconhillstaffing.com . We look forward to working with you. Beacon Hill. Employing the Futureā¢