Required Skills: PL/SQL, Unix, ETL, Prior Bank experience, Performance tuning
Job Description
Job Details
MUST-HAVE:
Strong Oracle PL/SQL Development experience
Unix (Operating systems & scripting)
Data Methodology & Analysis: Understanding data structure, data design, and improving the Oracle DB with a focus on an API type environment rather than pushing files
Performance tuning
ETL (Extract, Transform, Load) work
Datawarehouse experience: NEED to have primarily what they do
Informatica
Prior Bank experience would give candidates a better advantage
REQUIREMENTS:
Computer Science/Software Engineering (or related technical) degree or equivalent experience in field
HR Data Domain experience.
Finance Data Domain experience (RDR Finance space).
6+ year Data Warehousing experience, including manipulation/ transformation of millions of rows with optimal methods
6+ year experience with traditional relational database management systems (Oracle) and SQL skills, including developing stored procedures, functions, and triggers in a Big Data environment
6+ year SQL PL/SQL development experience with Oracle DBMS and VPD Security.
6+ year using TOAD, Unix Shell Scripting, Autosys, Jira, and Microsoft Office Suite (Outlook, Excel, Word, Access)
Experience in Master Data Management (MDM) concept, tools, and best practices
Demonstrable risk identification skills
Working knowledge of Java/ Mulesoft/ APIs
Enterprise HR (or other highly sensitive) Data Domain experience
Technology Development experience in Financial Services/Banking Industry
Experience in Agile Scrum, DevOps, SAFe or Disciplined Agile ways of working CI/CD Release Processes
Expert in data regulation and exercises best practices in data management and governance
Advanced experience in Unix Shell Scripts, Autosys, and TOAD for Oracle
Advanced-level analytical, debugging, and critical thinking skills.