Responsibility of / Expectations from the Role
Design and develop the respective platform codes, configurations and unit testing
Ensure deliverables meet business requirements
Document and communicate technical designs.
Ensure all support or project activities are in compliance to the quality assurance, audit
specification, internal controls and standards.
Provide up- to- date and accurate relevant documentation of changes, fixes, upgrades,
enhancements of supported applications and implementation procedures in accordance
to established standards
Required Technical Skillset
MSBI stack developer(SQL, T-SQL, SSIS, SSAS, SSRS):
Power BI Developer
Good work exposure to Agile Methodology
Strong expertise in SSAS Multidimensional Cube development with MDX language
Strong understanding of DSVs, dimension-measure group relationship set up, attribute
key processing, partition processing
Performance improvement experience through MDX
SQL Profiler usage and leveraging for optimizations
TFS (Team Foundation Server), GitHub, Azure Dev Ops.
Build end-end ETL flows for DWH application
Analyze data models
Data quality analysis
Perform complex database programming by writing SQL procedures on large-scale
databases
Proven ability to perform technical troubleshooting to diagnose, isolate and correct data
and database issues