Job Description

Job Title:

Data Architect - Hybrid (3 Days Work from Office)

Location:

Brookfield, Bangalore###

Job Summary

We are seeking a highly experienced

Data Architect

with a strong background in

IBM DataStage, Power BI

, and

SAP BOBI 4.3

tools. The ideal candidate should have

10+ years of experience

in data architecture, data modeling, ETL processes, and business intelligence reporting, with a focus on designing and optimizing data-driven solutions.###

Key Responsibilities

Design, develop, and maintain data architecture solutions supporting business requirements.
Work extensively with

IBM DataStage 11.7

for ETL design, development, and optimization.
Develop, enhance, and maintain reports and dashboards using

Power BI

(Desktop, Server, and Cloud).
Utilize

SAP BOBI 4.3

tools (UDT, IDT, Web Intelligence, CMC, Promotion Management) for reporting and analytics.
Write and optimize complex

SQL

queries; manage data across

Oracle

and

PostgreSQL

databases.
Develop and maintain

Unix shell scripts

for automation and data management tasks.
Design and implement

data models

, ensuring accuracy, performance, and scalability.
Analyze business requirements and translate them into efficient data solutions and visual insights.
Conduct performance optimization for queries, data pipelines, and reports.
Troubleshoot data and reporting issues independently.
Ensure adherence to

data security principles

and

data governance

standards.###

Required Skills & Experience

10+ years

of experience in Data Architecture, ETL, and BI reporting.
Expertise in

IBM DataStage 11.7

,

Power BI

, and

SAP BOBI 4.3

tools.
Proficiency in

SQL/PLSQL

and experience with

Oracle

and

PostgreSQL

databases.
Strong understanding of

Data Warehousing

concepts and

Data Modeling

(Star/Snowflake schema).
Hands-on experience with

Unix Shell Scripting

.
Excellent analytical, problem-solving, and troubleshooting skills.
Strong knowledge of

RDBMS principles

(normalization, de-normalization, relationships, ER diagrams, etc.).
Familiarity with

ETL algorithms

,

data extraction/transformation techniques

, and

performance optimization

.
Good understanding of

data security

and

operating system fundamentals

.###

Preferred Attributes

Ability to work independently and manage multiple priorities.
Strong communication and collaboration skills.
Analytical mindset with attention to detail.