IBM Solution Architect

o Batch and near real time ingestion o Data pipelines and orchestration Roles & Responsibilities

• Design and maintain enterprise data architecture and data models (conceptual, logical, physical).

• Create conceptual, logical, and physical data models and data marts (e.g., PTS Datamart, Jira Datamart, GDW/Employee Datamart, Application/CSI).

• Build and optimize data marts supporting analytics and BI tools (Tableau, Qlik).

• Design and support ETL pipelines using IBM DataStage to load curated data into Oracle databases.

• Enable API-based data sourcing and secure file transfers (e.g., batch files, feeds) for data procurement from internal and external systems.

• Collaborate with Java/Spring Boot teams for application and API-driven data integration.

• Define data structures, relationships, and standards ensuring data quality and consistency.

• Implement data governance, security, and compliance standards.

• 12+ years of experience in data architecture and data modeling.

• Strong hands-on experience with Oracle DB, IBM DataStage, API/file-based data integration, and Java/Spring Boot integration.

• Expertise in SQL, data normalization, performance tuning, and data integration.

• Solid understanding of data governance, security, and enterprise data standards.

• Strong collaboration and communication skills.

Data Architecture & Modeling

• Strong experience in:

o Conceptual, Logical, Physical data models o Dimensional modeling (Facts, Dimensions, SCDs) o Normalization & denormalization

• Experience with ER modeling tools (ERwin, PowerDesigner, or similar)

Databases & SQL

• Advanced SQL (E2/E3 level)

o Complex joins, window functions o Performance tuning and indexing strategies

• Hands on with:

o RDBMS: Oracle / SQL Server / PostgreSQL / MySQL o NoSQL: MongoDB / Cassandra / DynamoDB (preferred) Data Engineering & Integration

• Strong understanding of ETL / ELT architectures, Qualifications : BACHELOR OF COMPUTER SCIENCE