Job Description :
Role:: PL/SQL Developer.
Location:: Westerville, OH.
Skill Sets::
Acquire knowledge and develop deep expertise of the Anti-Money Laundering (AML) Risk Assessment data platform, requirements, and roadmap (will include reviewing 100+ data sources and data transformations that occur across sources)
Ø Lead the effort with documenting additional design details of this past year’s program (may include reverse engineering complex Oracle PL/SQL code and having discussions with current system subject matter experts)
Ø Actively participate in data requirements sessions for the next release and prepare a detailed technical design, leveraging prior year design concepts
Ø Assess the current architecture and look for opportunities to streamline the architecture for the future in alignment with the Risk Assessment Roadmap
Ø Develop clear and easy to understand documentation. Contribute to Functional Requirements Documents (FRDs) and Technical Data Interface Specifications and own Design Documents and System Operations / Maintenance manuals
Ø Develop PL/SQL data processing/transformation code for future releases (will involve loading data files from a large number of sources, pulling data from databases for some select sources, and writing data transformation/data aggregation code logic)
Ø Prepare required documentation for code change management and work with job scheduling tools to load data files and for initiating code / data processing (coordinate with the Operate team while in Production)
Ø Conduct data analysis and data defect research, communicating with the business as part of the troubleshooting process. Also fix and deploy defect fixes.
Ø Maintain the application, including troubleshooting (break fix) and maintaining security