Job Description

Solution Architect / Senior Solution Architect - IBM IIS Datastage

Powai, Mumbai Or Airoli, Navi Mumbai
Current Work Experience
10-15 years
Skills (Mandatory)
  • Understanding of database concepts and experience with design
  • Good understanding of ETL concepts
  • IBM Datastage development experience
  • Basic SQL querying skills
  • Unit test plan creation and unit testing
Skills (Desired)
  • Hands on experience with IIS Datastage
  • Hands on experience with relational DBS like MS SQL Server, Oracle etc
  • Proficiency in DB design, performance optimization (tuning) using zone, grooming of table
  • Thorough of ETL tools like data stage or any other tool
  • Thorough in Data Warehouse/BI design and architecture patterns
  • Proficiency in relational and dimensional data modelin
  • Proficiency in ROLAP/MOLAP/HOLAP concepts
  • Must have designed Deployment strategy, history load, incremental load strategies
  • Experience with requirement gathering
  • Good written and verbal communication skills.
  • Knowledge of one or two reporting tools like SSRS, Cognos, QlikView, Tableau etc.
  • Very strong client facing skills. Experience of leading and delivering complex BI projects
  • Strong Experience with 1 or more BI tools like MS BI Stack, Oracle, SAP BO, Cognos etc.
  • Travel ready - frequent travels (B1 preferred)


  • Lead, manage and own  multiple BI projects in the capacity of project lead
  • Interact extensively with clients to understand their requirement, design and development of solution
  • Interact with client engineering team, conceptualize, develop and  implement BI projects and solutions
  • Lead development of solutions - end to end
  • Ensure team output meets time and quality commitment
  • Lead onsite visits to client locations e.g., for requirements, UAT
  • Proactively learn healthcare standards, workflows and technologies – work towards a healthcare technology consultant
  • Build internal knowledge base / healthcare technology expertise e.g.White papers,CitiusTech Practice Documents (CPDs)