Data Warehouse Related Responsibilities
- Collaborate with cross-functional teams, including data engineers, business analysts, and data scientists, to understand data requirements and design optimal data warehouse solutions that align with business objectives.
- Develop and implement end-to-end ETL (Extract, Transform, Load) processes to ingest, transform, and load data from various sources into the data warehouse. Utilize industry-leading ETL tools to automate and streamline these processes.
- Collaborate with database administrators to optimize query performance, identifying and resolving bottlenecks through query optimization, indexing strategies, and data partitioning.
- Work closely with business analysts, data scientists, and other stakeholders to understand data consumption patterns and provide support for their analytical initiatives. Translate business requirements into effective data solutions.
- Create and maintain comprehensive documentation for data warehouse processes, including data lineage, transformations, business rules, and metadata. Ensure knowledge sharing and continuity within the team.
- Stay up-to-date with industry best practices, emerging technologies, and trends in data warehousing and analytics. Continuously evaluate and recommend new tools, techniques, and methodologies to enhance the data warehouse infrastructure.
- Collaborate with IT security and compliance teams to ensure data security, privacy, and compliance with relevant regulations.
Minimum Qualifications:
- Minimum 3 years of experience.
- Experience in banking/ bank applications is a plus.
- Prior Experience in ETL tools such as Informatica, Talend, or Apache NiFi, and data integration techniques for handling structured and unstructured data
- Bachelor's degree in Computer Science, Information Technology, or a related field; Master's degree is a plus.
- Prior experience with SAP Business Objects (BO) is a plus.
- Proficiency in ETL tools such as Informatica, Talend, or Apache NiFi, and data integration techniques for handling structured and unstructured data.
- Strong experience with SQL and database systems such as SQL Server, Oracle, or PostgreSQL. Familiarity with NoSQL databases is advantageous.
- In-depth understanding of data modelling, dimensional modelling, and data normalization techniques.
Job specific Skills:
- Fair knowledge of building system interfaces and systems integration
- Fair knowledge of Banking systems
- Fair understanding of business cycles
- Enthusiastic and fast learner
- Ability to execute multiple projects and initiatives balancing department and organizational demands and resources.
- Delivery of timely and accurate information for decision making.
- Good presentation skills.
- Highly organized and detail oriented.
- Self-motivated and independent.
