Our client is one of the largest banks in terms of assets and loan portfolio. The Bank is actively developing online services and is working on a Mobile first strategy. The bank's mission is to help people and companies improve their lives by offering simple and convenient solutions.
Tasks:
• Performing functional duties within the framework of the Data Platform Migration project (Arenadata Greenplum DB)
• Interaction with business owners of systems in order to clarify the semantics of data, features of business processes and used objects
• Development of the architecture of the pipeline for loading data (DataOps) from external sources to the Central Data Warehouse and their further delivery to the data marts
• Development of standards for loading, storing and accessing data in Greenplum, architectural oversight of the implementation of the Data pipeline
• Interaction with teams of common platform services developing the Data pipeline, developers of the Unified Detail Layer Model and Data Showcases
• Participation in the processes of work planning, resource determination and assessment of labor costs, project risks
• Participation in testing and acceptance tests of the developed functionality
Requirements:
• Experience in analyzing and describing the sources of bank data for loading into the storage / data lake / reporting from 2 years
• Experience in identifying customer requirements; experience in assessing the feasibility of requirements, their formalization and coordination with customers; experience in monitoring the fulfillment of agreed requirements and presenting the results to customers
• Ability to collect, analyze and organize requirements, bring together requirements from various sources
• Experience in the development and approval of technical specifications, mapping, test cases
• Preparation of project documentation (functional requirements, technical tasks and solutions, specifications, instructions, etc.) and setting tasks for development
• Experience in designing models of a detailed storage layer and data marts
• Confident knowledge of key banking entities: loans, deposits, accounting
• Participation in testing data warehouse improvements
• Experience in data modeling and familiarity with industrial domain models
• Skills in planning and assessing the labor intensity of work
• Strong knowledge of SQL of any industrial DBMS
• Excellent BI / Data Discovery tools (BusinessObjects, Tableau, PowerBI)
• Experience with project / task management systems (TFS / Jira, etc.)
• Experience with agile project methodologies (agile, scrum, kanban)
• Experience in testing and acceptance tests, development of testing methods (formation of acceptance criteria, test cases)
• Possession of ETL tools (SAS DI, Informatica PC, ODI, IBM DataStage) as an advantage