IBM Solution Architect
Tata Consultancy Services
•
Tampa, FL
0
0
0
0
Not Applicable
Posted April 17, 2026
Job link
Thinking about this job
Responsibilities
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.
- Optimize SQL, indexing, and performance for scalable data solutions.
- Document data models and manage metadata repositories.
Not Met Priorities
What still needs stronger evidence
Requirements
- 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:
- Conceptual, Logical, Physical data models
- Dimensional modeling (Facts, Dimensions, SCDs)
- Normalization & denormalization
- Experience with ER modeling tools (ERwin, PowerDesigner, or similar)
- Databases & SQL
- Advanced SQL (E2/E3 level)
- Complex joins, window functions
- Performance tuning and indexing strategies
- Hands on with:
- RDBMS: Oracle / SQL Server / PostgreSQL / MySQL
- NoSQL: MongoDB / Cassandra / DynamoDB (preferred)
- Data Engineering & Integration
- Strong understanding of ETL / ELT architectures
- Experience with:
- Batch and near real time ingestion
- Data pipelines and orchestration
Preferred Skills
- NoSQL: MongoDB / Cassandra / DynamoDB (preferred)
- Experience with:
- Batch and near real time ingestion
- Data pipelines and orchestration
Education
- (Not required) – Qualifications: BACHELOR OF COMPUTER SCIENCE
Job Description
Must Have Technical/Functional Skills
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:
Conceptual, Logical, Physical data models
Dimensional modeling (Facts, Dimensions, SCDs)
Normalization & denormalization
Experience with ER modeling tools (ERwin, PowerDesigner, or similar)
Databases & SQL
Advanced SQL (E2/E3 level)
Complex joins, window functions
Performance tuning and indexing strategies
Hands on with:
RDBMS: Oracle / SQL Server / PostgreSQL / MySQL
NoSQL: MongoDB / Cassandra / DynamoDB (preferred)
Data Engineering & Integration
Strong understanding of ETL / ELT architectures
Experience with:
Batch and near real time ingestion
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.
Optimize SQL, indexing, and performance for scalable data solutions.
Document data models and manage metadata repositories.
Salary Range: $110,000 to $130,000 per year
Qualifications: BACHELOR OF COMPUTER SCIENCE
Must Have Technical/Functional Skills
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:
Conceptual, Logical, Physical data models
Dimensional modeling (Facts, Dimensions, SCDs)
Normalization & denormalization
Experience with ER modeling tools (ERwin, PowerDesigner, or similar)
Databases & SQL
Advanced SQL (E2/E3 level)
Complex joins, window functions
Performance tuning and indexing strategies
Hands on with:
RDBMS: Oracle / SQL Server / PostgreSQL / MySQL
NoSQL: MongoDB / Cassandra / DynamoDB (preferred)
Data Engineering & Integration
Strong understanding of ETL / ELT architectures
Experience with:
Batch and near real time ingestion
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.
Optimize SQL, indexing, and performance for scalable data solutions.
Document data models and manage metadata repositories.
Salary Range: $110,000 to $130,000 per year
Qualifications: BACHELOR OF COMPUTER SCIENCE