Axiom developer

Axiom DeveloperONSITE - Pittsburg, PA ( this role can now be remote (preferably candidate located in Pittsburg or Cleveland)Vaccine Required

PLEASE SUBMIT THE BELOW PRE-SCREEN QUESTIONS with your candidates. Also, please include their LINKEDIN profile on their resume. Thank you!1.What is SQL and describe Types of SQL Statements ?2.What is Join and Explain different types of Join?3.What is Exception Handling ? Give some examples.4.What is Cursor why is it required?5.What is Function explain different types of Functions, Also explain difference between Function and Procedures.Difference between SQL and PL/SQL.6.What all will be considered when fine tuning the query in order to handle performance improvement of long running PL/SQL blocks?7.Explain one of the axiom report you have worked on.

Must Have's:Very good Oracle and PLSQL skillsAxiom reporting (candidate should be able to explain experience with these reports) - resume should show specific Axiom reports they have worked on - ie. Axiom Controller View for the FFIEC 031, FFIEC 041, FRY 14M/Q, FRY-14, FRY-9C, FRY 14M, FRY 14Q, FRY-9C, FFIEC 031 & 041 are regulatory Reports.

See below for JD and responses from HM on supplier questions:1. Would your team be willing to accept profiles that are Sr. Analysts & Business Analysts with Axiom reporting experience? the role is of a developer , so as long as he / she is good at SQL and can develop / create Axiom reports we should be good. As far as I understand Business Analysts , Sr. Analysts are not hands- on ( as in writing code )2. Would you look at Axiom Developers that have 3 years experience with other development experience? If so, what would be a similar tool that would suffice? The client is looking primarily for Axiom skill & SQL skill , so with past experience , the candidates submitted should be really good and know what they are doing3. What is the interview process and how quickly is the client looking to hire? Per the last time , it would be one round with Cognizant and 2 rounds with client4. Could you provide some guidance on the level of flexibility regarding the years of experience required for this position?

JD:General• Knowledge of Banking, Financial and US regulatory environment• Aligns business strategy with software solutions.• Must possess strong communication skills, both written and verbal. Looking for a highly motivated individual that likes to be challenged.• Candidate must actively and independently strive to broaden technology and business knowledge.• Displays an innovative approach to apply modern software development principles, methodologies and tools to advance business initiatives and capabilities.• Experience working in projects using waterfall or agile

Technical:• 5-8 years of Hands on configuration experience using Axiom for very large data sets.• Familiarity with OAS or Tableau is a plus.• Expertise in database design and programming skills – SQL/PLSQL• Intermediate level skills in data analysis and data modeling• Experience with using R or Python would be an advantage.• Knowledge and experience of data modeling and data warehouse concepts.• Working knowledge of software design patterns and architecture• Leads complex problem solving and provides technical guidance and support to colleagues and solution development.• Proposes, designs & codes software solutions to address complex business needs.• Oversees technical and procedural documentation as required.Years of Experience: 6.00 Years of Experience

Key Skills

• Python
• SQL