|
• Provide programming support using SAS/BASE, SAS/ACCESS, SAS/SQL & SAS/Macros.
• Use knowledge in banking industry to understand and resolve business problems (nice to have).
• Deliver custom data to answer specific business questions.
• Develop, review, test and document SAS programs/macros.
• Convert raw files into SAS datasets with required formats and labels.
• Train and mentor new resources to the team.
• Develop specifications for programming.
Cerinte • Experience and knowledge of how DWH and BI processes work.
• Understanding of data warehousing and data modeling concepts and best practices.
• Understanding of relational and multi- dimensional data design and development techniques.
• Experience with data warehouse lifecycles and a strong understanding of the role of methodology / frameworks.
• Programming – SAS Base, SQL, experience in PL/SQL programming, stored procedures code.
• DWH & BI Development Tools – SAS/AF, SAS Data Integration (SAS ETL Studio), Knowledge of Oracle Database 10g/11g, Oracle Data Integrator (ODI), TOAD, Business Objects, Hyperion.
• Experience with other reporting and analytic presentation tools and technologies such as SAS Reporting Tools, Business Objects XI, Cognos, ProClarity, Microstrategy, PowerAnalyzer.
• Operating Systems - Knowledge of Windows, Solaris incl. Shell Scripting. |