Data Technical Architect Standard

Roles & Responsibilities

Technical Skills:

• Good experience in 5+ SQL and NoSQL database development and optimization.
• Strong hands-on experience with Amazon Redshift, MySQL, MongoDB, and Flyway.
• In-depth understanding of data warehousing principles and performance tuning techniques.
• 3+ years of experience working with AWS-managed database services.
• 3+ years of experience with Power BI or similar BI/reporting platforms.
• Strong hands-on experience in building complex aggregation pipelines in NoSQL databases such as MongoDB.
• 3+ years Proficiency in Python or Scala for data processing and automation.
  
  

Roles And Responsibilities

• Design, develop, and optimize SQL and NoSQL queries, stored procedure for high-performance data retrieval across datasets exceeding 100 million records.
• Implement and manage database replication, partitioning, fragmentation, indexing strategies, and performance tuning.
• Collaborate with reporting teams to support data visualization and dashboarding needs using Power BI or equivalent tools.
  
  

Experience

• 12-14 Years
  
  

Skills

• Primary Skill: Data Architecture
• Sub Skill(s): Data Architecture
• Additional Skill(s): MongoDB SQL Development, MongoDB DBA, BI & Visualization Architecture, Data Architecture, Redshift
  
  

About The Company

Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune 500 companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).

Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Kraków, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.

---