About your role Key Responsibilities Work with Technical leads Business Analysts and other subject matter experts Understand the data model design and develop the ETL jobs Sound technical knowledge on Informatica to take ownership of allocated development activities in terms of working independently Working knowledge on Oracle database to take ownership of the underlying SQLs for the ETL jobs under guidance of the technical leads Providing the development estimates Implement standards procedures and best practices for data maintenance reconciliation and exception management Interact with cross functional teams for coordinating dependencies and deliverablesEssential Skills Technical Deep knowledge and experience of using the Informatica Power Centre tool set minimum 3 years Experience in Snowflake Experience of source control tools Experience of using job scheduling tools such as Control M Experience in UNIX scripting Strong SQL or PL SQL experience with a minimum of 2 years experience Experience in data warehouse datamart and ODS concepts Knowledge of data normalisation OLAP and Oracle performance optimisation techniques 3 plus years experience of either Oracle or SQL Server and its utilities coupled with experience of UNIX or Windows Functional 3 plus years experience of working within financial organisations and broad base business process application and technology architecture experience Experience with data distribution and access concepts with ability to utilise these concepts in realising a proper physical model from a conceptual one Business facing and ability to work alongside data stewards in systems and the business Strong interpersonal communication and client facing skills Ability to work closely with cross functional teams
ETL Informatica both cloud and on premises Oracle database and PL SQL queries basic Python understanding AWS cloud certification and query optimization capabilities The role was confirmed as a development position not maintenance or production support Agile Com.
