Data warehouse/BI solutions

Kiya.ai

Bengaluru

Hybrid

INR 1,200,000 - 1,800,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Kiya.ai in Bengaluru is seeking a senior DW/BI implementation expert with 5–9 years of hands-on experience to drive data integration and analytics initiatives. The role requires strong skills in SSIS, SQL, and data modeling, along with knowledge of scheduling tools and project management.

You will design robust data warehouse solutions, validate architectures with thorough testing, and optimize ETL processes and performance across RDBMS environments.

Qualifications

  • 5–9 years of experience in DW/BI implementations.
  • Strong expertise in SSIS, DW/BI concepts and SQL.
  • Knowledge of scheduling tools (Tivoli, Autosys), data modeling and project management.
  • Solid understanding of data warehousing concepts (SCDs, star schema, hierarchies).
  • Experience with ETL testing, test planning, UAT support, and deployments.
  • Performance tuning in SSIS and RDBMS.

Responsibilities

  • Implement DW/BI solutions for business needs.
  • Design data models and star schemas.
  • Coordinate testing (system/integration/performance) and UAT sign-off.
  • Optimize ETL processes and tune SSIS and databases.

Skills

Data warehousing concepts
Data modeling
Project management
Testing practices
ETL concepts

Tools

SSIS
Tivoli
Autosys
Oracle
Teradata
SQL Server
DB2

Job description

Description:
  • 5-9 years of experience in implementation of Data warehouse/BI solutions
  • Expertise in SSIS, DW / BI and SQL
  • Knowledge of Scheduling Tools (Tivoli , Autosys etc.), Data Modeling, Project Management
  • Well versed with knowledge of Data warehousing concepts including: SCDs, star schema, hierarchy, aggregation
  • Should have expertise in ETL tools like SSIS, RDBMS (at least one) like Oracle, Teradata, SQL Server, DB2 and considerable experience in Testing which activities like creating system / integration / performance test plan, performing system / integration / performance testing, defect tracking, root cause analysis of defects, support user acceptance testing (UAT) and facilitate UAT sign off, Deployments / Migrations across Environments.
  • Should be well versed with Performance Tuning Techniques in SSIS and RDBMS.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DWH Consultant
DWH Consultant

NTT Data FA insurance Systems India Pvt ltd • Bengaluru

On-site
INR 3,000,000 - 5,000,000
Bi Developer
Bi Developer

TESCRA • Bengaluru

On-site
INR 800,000 - 1,100,000
SSIS and Azure Data Engineer
SSIS and Azure Data Engineer

Weekday • Maharashtra

On-site
INR 1,200,000 - 2,000,000
Data Warehouse Engineer (SSIS)
Data Warehouse Engineer (SSIS)

Everty • Gurugram District

On-site
INR 700,000 - 1,500,000
SSIS, SSAS, SSRS, MSBI
SSIS, SSAS, SSRS, MSBI

Infosys • Maharashtra

On-site
INR 1,200,000 - 1,800,000
ETL Developer
ETL Developer

Shashwath Solution • Dadri

On-site
INR 800,000 - 1,500,000
Database / ETL / Power BI Developer
Database / ETL / Power BI Developer

PradeepIt Global Consulting Pvt Ltd. • Bengaluru

On-site
INR 800,000 - 1,200,000
ETL Developer
ETL Developer

Shashwath Solution • Pune District

On-site
INR 1,200,000 - 2,000,000
Database / ETL / Power BI Developer
Database / ETL / Power BI Developer

Pradeepit Global Consulting Private Limited • Bengaluru

On-site
INR 800,000 - 1,200,000
MSBI + PowerBI Developer
MSBI + PowerBI Developer

PradeepIt Global Consulting Pvt Ltd. • Bengaluru

On-site
INR 800,000 - 1,200,000