Job TITLE: Application Architect V-Oracle with ETL
Location: Plano TX/Pennington or Jersey City NJ/Charlotte NC
Duration: Long period
10+ years’ experience in design and creation of Oracle PL SQL and ETL based frameworks applying strong data modeling skills. Be able to design the conceptual, logical and physical data models necessary to support the analytic data requirements for various department reporting needs. Should be comfortable working with upstream SOR systems and downstream systems data models.
Primary Skill
Oracle SQL / PLSQL
Secondary Skill
Data modelling and architecture
Tertiary Skill
Data Stage
Required Skills
***10+ years’ experience in design and creation of Oracle SQL and ETL based frameworks applying good/strong data modeling skills. ***
Be able to design the conceptual, logical, and physical data models necessary to support the analytic data requirements for various department reporting needs.
Should be comfortable working with both systems and data.
***Expertise in creating and maintaining data models and high performing ETL routines (i.e. DataStage, Informatic, Alteryx) ***
Strong PL/SQL and data analysis experience
Leads efforts in development of new models, analytic processes, or system approaches. Creates documentation for all activities and may work with technology staff in design of any system to run models developed.
Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability, and value.
Challenges data and information integrity.
Conducts special studies to analyze complex financial actions and prepares recommendations for policy, procedure, control, or action.
Develops models and provides input and feedback to improve the ability to plan and control financial and business drivers.
Participate in the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation.
Operational Data Store modeling, design, and development
Design and prototype new analyses, reports, applications, and systems
Enhancing old processes and defining new ones
Data mining and producing novel reports for management.
Works closely with Line of Business Client to develop and enhance SQL data base solution Strong Excel Skills with pivots and graphs.
Candidate must have strong analytical, problem solving, and communication skills.
***Bachelor’s degree or equivalent in a quantitative field such as computer science, mathematics, engineering, finance, etc. ***
Must be comfortable conducting process reengineering "Solve" sessions.
Program in an agile, fast paced, accelerated development environment.
Solid Team player member on a development team, Problem solver, Technical intrigue Works under minimal supervision, with general guidance from management
May assist and help train lower-level developers.
Conversant with all phases of Software Development Life Cycle (SDLC), including requirement gathering, analysis, design, development, implementation, integration and testing
Desired Skills
Knowledge of Unix and any job scheduling tools ( i.e. Autosys, Shell scripts, etc.)
2+ years’ experience in developing Tableau and any other BI Tools.
Knowledge of Hadoop and Python
Experience working with large amounts of data, conducting analysis, and presenting findings Knowledge of banking experience •Finance/System and or Operations experience.
Strong working knowledge in Build process and release co-ordination
Have excellent customer communication and interpersonal skills with high level of adaptability.