About the Role
In this role, you will design highly scalable and high performing technology solutions in an Agile work environment and produce and deliver code and/or test cases using wide-ranging experience, professional concepts, company objectives and Agile practices. You will collaborate closely with key business support teams, product managers, architecture to assist in resolving complex critical cross-team and cross-domain production issues to help simplify and improve business processes through the latest in technology and automation. You are a technical expert and will lead through the requirements gathering, design, development, deployment, and support phases of a product. You will leverage your comprehensive knowledge of domain and core programming technologies or packages to mentor and advise team members.
What You'll Do
- Must have Strong knowledge on Power BI, SQL, SSIS, ADF, Cubes and Azure Data Bricks.
- Should have Strong knowledge on Designing technical solutions
- Should have good experience on planning, analyzing, designing, implementing, testing, and maintaining software
- Understands the Current or future systems landscape, Business Requirements and provides technical advice and contribute to technical decision-making
- Must have strong knowledge on Stored procedures, designing data models and ETL processes using ADF or Azure Data Bricks
- Should have real time work experience on MSBI (SSIS), Azure Data Factory Service (ADF), Data bricks.
- Will be responsible for hands-on design and development on ADF, ADB and SQL server database.
- Should have expert knowledge in writing SQL commands, queries and stored procedures. Ability to improve SQL performance: analyzing SQL joins and table structures.
- Analyze and benchmark reporting and ETL performance; Evaluate and improve existing BI systems.
- Having knowledge on Azure cloud with experience on Azure SQL DB and Azure analysis server is preferred.
- BI development background and coding experience in Azure stack - Migrate to Azure / Work with Azure services
- Understand Agile Best practices and creates tech backlog, story grooming and estimation
- Test programs and systems for bugs and errors, and perform maintenance and troubleshooting tasks
- Candidate should be able to design, build and deploy BI Solutions
- Understand software security best practices, common vulnerabilities, and methods to mitigate them
- Good Communication skills & Capability to work in a distributed team environment with minimal supervision is required
Who You Are
- 8 – 12 years of experience with ETL Processes, Power BI and Cloud technologies in software industry
- CS degree or equivalent experience