Senior Architect

About Us

Established in the year 2000 in the US, we have global offices in the US, India, UK, Australia, Mexico, Vietnam, and Canada, with best-in-class infrastructure and development facilities spread across the globe. We are an end-to-end solution provider in Banking & Financial Services, Telecom, Healthcare, Manufacturing & Energy verticals and have successfully delivered $1 billion worth of projects for more than 20 Fortune 500 companies.

Position Name

Key Responsibilities:

• Design and develop scalable data warehouse solutions using Snowflake


• Build and maintain star schema data models to support analytical workloads


• Develop and optimize ETL pipelines in Azure environment


• Implement data transformation logic using dbt (Data Build Tool)


• Work with Medallion Architecture (Bronze, Silver, Gold layers) for data processing


• Write and optimize complex SQL queries for performance and scalability


• Collaborate with business stakeholders to understand data requirements


• Ensure data quality, integrity, and performance tuning


• Support data integration and migration activities


•  


• Required Skills:

• Strong hands-on experience with Snowflake Data Warehouse


• Expertise in data modeling (Star Schema)


• Experience with Azure ETL tools (ADF, Synapse, etc.)


• Proficiency in dbt for data transformations


• Deep understanding of Medallion Architecture


• Advanced knowledge of SQL


• Good understanding of data warehousing concepts

Experience

    
13 - 16 yrs

Location

Bangalore/Hyderabad

Shift Timings

    
Custom

Job Description

Key Responsibilities

1. 
   Team Leadership & Management
   Lead and mentor a team of 10 production support engineers across multiple applications.


2. Manage work assignments, shift coverage, ticket prioritization, and SLA adherence.


3. Conduct regular team reviews, coaching, and capability development.


4. Act as the primary escalation point for critical incidents and production issues.


5. Production Support & Incident Management
   Manage day-to-day production support activities for applications built on Microsoft technologies (.NET, C#, VB).


6. Handle L2/L3 support, troubleshooting, bug fixes, and minor enhancements.


7. Drive RCA (Root Cause Analysis), preventive actions, and permanent fixes for recurring issues.


8. Ensure timely communication with stakeholders during major incidents.


9. Maintain and enhance monitoring, logging, and alerting mechanisms.


10. Technical Expertise
    Troubleshoot and support applications built on .NET Framework/Core, C#, VB.


11. Strong experience with MS SQL Server, including performance tuning and debugging.
    Hands-on expertise in SSIS/SSRS/MSBI for data


12. pipelines, reporting, and ETL workloads.
    Ability to analyze, optimize, and maintain Power BI reports and dashboards.


13. Collaborate with Development, QA, and DevOps teams to ensure smooth deployments and transitions.
    Process & Governance


14. Implement ITIL best practices in Incident, Problem, and Change Management.
    Create and maintain runbooks, knowledge base articles, support documentation.


15. Ensure compliance with organizational security and governance standards.


16. Drive continuous improvement in support processes and automation.

Competencies

Key Skills

Soft Skills

Qualification

Certifications