Back to list

Vacancy description

Solution Architect - Informatica/Google BigQuery in Chennai, भारत

Coders Brain Technology & Private Limited

Chennai, भारत

Position Summary:We are seeking an experienced Data Analyst/Enterprise Data Warehouse (EDW) Solution Architect to design, build, and optimize scalable enterprise data, analytics, and AI solutions. This blended role will translate business needs into trusted data products, engineer reliable ingestion and transformation pipelines, and define the architecture for a modern data warehouse and data lake https://jobeax.com/link/iI6orKaMryo0dJI7 Responsibilities:- Solution architecture: Define the target-state EDW, data lake, and analytics architecture, including logical and physical data models, integration patterns, security controls, metadata, lineage, and nonfunctional requirements.- Data ingestion and integration: Design and develop batch and near-real-time pipelines using Informatica to ingest data from enterprise applications, databases, APIs, files, and third-party platforms.- BigQuery engineering: Build and optimize curated data layers, dimensional models, data marts, and lakehouse-style datasets in Google BigQuery, with attention to partitioning, clustering, performance, scalability, and cost.- Data transformation: Implement reusable transformation logic, data standardization, reconciliation, and orchestration processes across raw, trusted, and consumption layers.- Analytics and visualization: Partner with business stakeholders to define KPIs and create governed Tableau dashboards, reports, and self-service analytics experiences.- Business analysis: Elicit and document requirements, profile source data, perform exploratory analysis, identify trends and anomalies, and translate findings into actionable recommendations.- Data quality and governance: Establish data quality rules, monitoring, exception handling, lineage, reference data, business definitions, stewardship processes, and auditability.- Security and compliance: Apply role-based access, least-privilege principles, sensitive-data protections, retention requirements, and applicable privacy and regulatory controls.- AI solutions on the EDW: Design and build AI-enabled solutions that securely use governed EDW and data lake assets, implementing Role-Based Access Control (RBAC) and Row-Level Access (RLA) controls to ensure users, applications, and AI services can access only authorized data.- Business-facing IT leadership: Act as the primary IT partner and trusted advisor for business stakeholders, maintaining frequent interaction to understand needs, facilitate decisions, manage expectations, present solution options, and coordinate delivery across technical teams.- Operational excellence: Monitor pipelines and dashboards, troubleshoot production issues, conduct root-cause analysis, and improve reliability through automation, testing, and observability.- Technical leadership: Lead design reviews, create architecture standards and technical documentation, mentor team members, and collaborate with application, cloud, security, and business https://jobeax.com/link/oq8ejQTdCrDGJkvA Qualifications:- Bachelor's degree in Computer Science, Information Systems, Data Engineering, Analytics, or a related field, or equivalent practical experience.- 8+ years of experience across data engineering, business intelligence, data analysis, data warehousing, or solution architecture.- Hands-on experience with Informatica products and enterprise ETL/ELT design, development, deployment, and support.- Strong experience with Google BigQuery, SQL, cloud data warehousing, data lake concepts, data modeling, and query optimization.- Demonstrated experience developing Tableau dashboards, semantic layers, calculated fields, data sources, row-level security, and performance-optimized visualizations.- Experience building AI-enabled solutions on enterprise data warehouse or data lake platforms, including secure access to governed data for AI models, agents, or applications.- Hands-on experience designing and implementing Role-Based Access Control (RBAC) and Row-Level Access (RLA) security controls across BigQuery, Tableau, and enterprise data products.- Strong knowledge of dimensional modeling, star and snowflake schemas, slowly changing dimensions, master and reference data, and data lifecycle management.- Experience integrating structured and semi-structured data from SaaS applications, relational databases, APIs, and files.- Proficiency in SQL and at least one scripting or programming language such as Python.- Experience with data quality frameworks, metadata management, data lineage, testing, CI/CD, and production support.- Strong communication skills with the ability to explain technical concepts to business audiences and convert business requirements into scalable solutions.- Proven ability to serve as the face of IT for business teams, build trusted stakeholder relationships, lead recurring working sessions, and communicate solution strategy, trade-offs, risks, and delivery status clearly. (ref:hirist.tech)

Similar vacancies

More like this role

  • Remote
  • Hybrid
... developing, and maintaining scalable data engineering solutions on Google Cloud Platform (GCP). The ideal candidate should have strong hands-on experience in BigQuery, PySpark, SQL, and ETL/ELT https://jobeax.com/link/AtRBdjzDZvZmLq7q Responsibilities :- Design, develop, and maintain scalable data pipelines using Google Cloud ...

Gurgaon, भारत

  • Cloud
... Responsibilities : - Design and architect enterprise-scale cloud and AI solutions on Google Cloud Platform.- Leverage GCP services, including Compute Engine, Google Kubernetes Engine (GKE), Cloud Run, BigQuery, Cloud Storage, Pub/Sub, and Dataflow.- Architect and implement AI/ML solutions using Vertex AI, Gemini, Generative ...

Bangalore, भारत

... looking for a Senior Power BI Architect to lead the design and modernization of enterprise BI solutions. The role involves migrating analytics workloads to GCP/BigQuery, building governed semantic models using LookML/Looker, and delivering scalable Power BI reporting solutions. This is a hands-on architecture role requiring ...

Bangalore, भारत

  • Full-time
Join our Team About this opportunity: Own the architecture, technical planning, and delivery of IMS LCM scopes for telecom operators. Lead end-to-end lifecycle activities—from upgrades and patches to expansions, migrations, hardware replacements, maintenance, and decommissioning—while protecting service continuity and providing ...

Noida, भारत

  • Full-time
  • Contract
... optimization of cloud-based data ingestion and transformation pipelines, ensuring seamless business continuity and data fidelity. Key Responsibilities Pipeline Architecture & Design (CDI) ● Architect, design, develop, and deploy robust, scalable ELT/ETL pipelines using Informatica Cloud Data Integration (CDI). ● Design modular ...

Raipur, भारत

  • Hybrid
  • Contract
... enterprise architecture and a proven portfolio of successfully leading multi-million-dollar digital commerce transformations. What you’ll be doing 1. Enterprise Architecture & Solution Design - Define and own the end-to-end technical architecture for digital platforms, seamlessly integrating E-commerce engines, CMS (Digital ...

Bombay, भारत

  • Hybrid
  • Full-time
  • Data Analytics
... accelerators - Security and Row-Level Security (RLS) templates - Continuously enhance accelerators based on project learnings and evolving best practices. Solution Architecture - Design scalable enterprise Power BI solutions. - Optimize DirectQuery, Import, Composite Models, and Hybrid Tables. - Ensure solutions meet enterprise ...

Bangalore, भारत

  • Remote
  • Hybrid
  • Full-time
... teams to shape the right technical solution and then drive its execution (50/50), balancing architectural integrity against delivery reality. WHAT YOU’LL DO: Architecture: - Own the solution blueprint end to end for your engagements — current-state assessment, target architecture, integration design, and the sequencing roadmap ...

Bangalore, भारत

  • Full-time
  • Contract
  • Project Management
... questions, and/or issues are brought to the appropriate internal teams. Architecture Design and Deployment Holds teams accountable for leveraging existing architecture approaches to achieve Microsoft's agreed commitments to the customer/partner and developing new solutions to scale across multiple customers/partners and ...

Noida, भारत

  • Full-time
... readiness assessments to build a phased modernization roadmap covering applications, data, integration, cloud platform, security - Design differentiated Oracle solutions that embed AI into business workflows across ERP, HCM, SCM and CX, with clear value realization, architecture and delivery plans What you need - LLMs - ERP ...

भारत