Data Warehouse Architect / Developer Ssis Ssrs And Power Bi Pan India Job in Teamplus Staffing Solution Pvt Ltd.

Job Role &Responsibilities:

Be part of the Digital transformation driving organization into a metric-driven company.
Design and Develop enterprise data warehouse system and data analyticssolution.
Architect overall data flow / data supply chain for both external applicationand reporting systems.
Design and work with developers to implement best practices and do processperformance improvements.
Develop ETL layer including SSIS processes / Stored Procedures / SQL tosupport the data warehouse system.
Perform Database administration activities to manage our internal SQLservers
Perform Business analysis of the requirement working closely with themanager and transform them into technical specification.
Perform project management activities including agile methodologies
Migrate databases on older version to new version. Leverage latesttechnology stack.
Create Source- Target mapping documents and work closely with theArchitect
Create Data flow diagrams / ERD diagrams and help develop optimal Datamodelling solution
Support daily /weekly and monthly ETL jobs and resolve/ fix any issues
Maintain an incident log and research areas that can improve performance..
Requirements At least 7-8 years experience with data hosted in Microsoft SQL serverenvironments and related technologies
At least 4-5 years experience in Data architecture and Data modellingbuilding data warehouse
At least 2 years experience handling master data management
At least 2 year experience with Database administration (e.g. Seversmanagement, permissions, recovery, security and monitoring)
At least 1 year experience working with Microsoft dynamic data structures
At least 1 year experience working with reporting tools ( Cognos/ Tableau)
At least 4-5 years experience with SSIS / SSRS and preferred experiencewith MDM Master data management components
Strong experience with ODS layer and Kimball or Randolf Data warehousedevelopment approaches
Experience with SQL performance tuning and code optimization.
Knowledge on Data cleansing / Data profiling and Data governance
Knowledge on Data science / Statistical analysis / SPSS is a plus

Joining : Immediate