Specialist Software Engineer - BI Developer

Allegis Global Solutions (AGS); Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Allegis Global Solutions (AGS) in Bengaluru is seeking a software engineer with 4–8 years of Banking domain experience to translate requirements into working code. You will influence stakeholders, design robust architectures, and mentor teammates while collaborating with onshore and offshore groups.

The role emphasizes SQL Server based data warehousing, SSIS/SSAS/SSRS, Power BI, and awareness of MDX queries and RLS, guided by agile practices.

Qualifications

• Must have knowledge of software design principles.
• 4-8 years experience across Banking domain.

Responsibilities

• Understand software requirements and translate into working source code.
• Mentor/groom team on best practices.
• Lead and influence stakeholders to drive technical decisions.
• Collaborate with internal and external interfaces to deliver banking projects.

Skills

Technical architecture design

SQL/SSIS/SSAS/SSRS

Banking domain experience

Agile methodologies

Communication

Team collaboration

Cloud technologies

Tools

SQL Server 2016

SSIS

SSAS

SSRS

Power BI

MDX

RLS

Job description

Role & responsibilities

• Responsible for understanding the software requirements and developing it into a working source code accordingly.
• Able to technically lead and influence the stakeholders
• Possess strong Design skills Opportunity to work with some of the best minds in a team and learn a lot on the technical front.
• Get mentored/groomed on the best practices followed in the software industry.\"Internal Interfaces:
  - Team members, Technical leader, Business Analyst
  External Interfaces:
  - Onshore team, Developers, Technical Lead, Business Analyst, End Users\" Responsible for understanding the software requirements and developing it into a working source code accordingly. Get mentored/groomed on the best practices followed in the software industry. Must have knowledge of software Design principles.
• Profile : 4-8 years experience across Banking domain.
• Functional background: Banking Projects
• Methodology: Agile

Preferred candidate profile

• Good knowledge and experience in designing and implementing technical architecture based on SQL/SSIS/SSAS/SSRS technologies
• Good communication and Good interpersonal skillsStrong Autonomy / Proactive and FlexibleComfortable to work as a team and share information with the teammates
• Must have Knowledge on SQL Server 2016Strong understanding of Kimball Data warehousing and Data Modeling concepts
• Must have Good knowledge on SQL Server Integration service (SSIS)
• Must have Good Knowledge on T-SQLGood knowledge on SQL Server Analysis service (SSAS)Good knowledge and experience in power BI / Data Warehouse.
• Good to know MDX queries in SSAS
• Able to develop SSIS package Independently using data flow and control flows
• Able to Design SSAS Model and should have knowledge on RLS Implementation
• understanding of cloud technologies