IT Data Intergration Engineer (SAP BO Experience - Office Based)

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.