Senior Technical Lead

data requirements.Data Integration & ETLDesign, develop, and optimize ETL/ELT pipelines using Informatica PowerCenter and Informatica Cloud (IICS).Ensure high-quality data movement, transformation, validation, and reconciliation processes.Establish standards for ETL development, code reviews, deployment, and support.Data ModellingDesign conceptual, logical, and physical data models.Develop dimensional models including Star and Snowflake schemas.Perform data analysis and create scalable data structures supporting analytics and reporting requirements.Ensure adherence to enterprise data modelling standards.GCP Big Data EngineeringDesign and implement cloud-native data solutions on GCP.Develop and optimize data pipelines using:BigQueryDataflowDataprocCloud StoragePub/SubComposer (Airflow)Drive cloud migration and modernization initiatives.Optimize performance, scalability, and cost efficiency of GCP services.Team & Stakeholder ManagementLead, mentor, and guide offshore/onsite development, Key ResponsibilitiesData Warehouse LeadershipLead end-to-end delivery of enterprise Data Warehouse and Data Integration initiatives.Define and implement data architecture, data governance, and best practices.Drive modernization of legacy ETL and warehouse platforms to cloud-based architectures.Collaborate with business, analytics, and application teams to define data requirements.Data Integration & ETLDesign, develop, and optimize ETL/ELT pipelines using Informatica PowerCenter and Informatica Cloud (IICS).Ensure high-quality data movement, transformation, validation, and reconciliation processes.Establish standards for ETL development, code reviews, deployment, and support.Data ModellingDesign conceptual, logical, and physical data models.Develop dimensional models including Star and Snowflake schemas.Perform data analysis and create scalable data structures supporting analytics and reporting requirements.Ensure adherence to enterprise data modelling standards.GCP Big Data EngineeringDesign and implement cloud-native data solutions on GCP.Develop and optimize data pipelines using:BigQueryDataflowDataprocCloud StoragePub/SubComposer (Airflow)Drive cloud migration and modernization initiatives.Optimize performance, scalability, and cost efficiency of GCP services.Team & Stakeholder ManagementLead, mentor, and guide offshore/onsite development teams.Conduct solution reviews, technical design sessions, and architecture discussions.Collaborate with architects, product owners, business stakeholders, and leadership teams.Drive incident resolution, root cause analysis, and continuous improvements.

Job Description: Data Warehouse Lead - Informatica, Data Modelling & GCP Big DataPositionData Warehouse LeadLocationIndiaExperience10-14 YearsEmployment TypeFull-TimeJob SummaryWe are seeking an experienced Data Warehouse Lead with strong expertise in Data Warehousing, Informatica, Data Modelling, and Google Cloud Platform (GCP) Big Data technologies. The ideal candidate will lead the design, development, modernization, and support of enterprise-scale data warehouse and analytics solutions. The role requires hands-on technical leadership, stakeholder management, architectural decision-making, and mentoring of development teams.Key ResponsibilitiesData Warehouse LeadershipLead end-to-end delivery of enterprise Data Warehouse and Data Integration initiatives.Define and implement data architecture, data governance, and best practices.Drive modernization of legacy ETL and warehouse platforms to cloud-based architectures.Collaborate with business, analytics, and application teams to define, teams.Conduct solution reviews, technical design sessions, and architecture discussions.Collaborate with architects, product owners, business stakeholders, and leadership teams.Drive incident resolution, root cause analysis, and continuous improvements.Required SkillsCore TechnologiesInformatica PowerCenterInformatica Intelligent Cloud Services (IICS)Enterprise Data WarehousingData Modelling (Conceptual, Logical, Physical)Dimensional Modelling (Star/Snowflake Schema)SQL and Advanced Database DevelopmentGCP Big DataBigQueryDataflowDataprocCloud StoragePub/SubCloud Composer (Airflow)IAM & Security ConceptsDatabasesOracleSQL ServerPostgreSQLBigQueryData EngineeringETL/ELT Design and DevelopmentData MigrationData Quality FrameworksData GovernancePerformance OptimizationLeadershipTechnical LeadershipTeam ManagementStakeholder CommunicationDelivery ManagementAgile/Scrum MethodologiesPreferred QualificationsBachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or related field.GCP Professional Data Engineer Certification preferred.Informatica Certification preferred.Experience working in Retail, Supply Chain, Logistics, or Consumer Business domains is a plus.Exposure to Data Lake, Lakehouse, and real-time streaming architectures.Nice to HavePythonShell ScriptingTerraformSpark/PySparkKafkaLookerTableauPower BIData Catalog & Metadata Management Tools, Core TechnologiesInformatica PowerCenterInformatica Intelligent Cloud Services (IICS)Enterprise Data WarehousingData Modelling (Conceptual, Logical, Physical)Dimensional Modelling (Star/Snowflake Schema)SQL and Advanced Database DevelopmentGCP Big DataBigQueryDataflowDataprocCloud StoragePub/SubCloud Composer (Airflow)IAM & Security ConceptsDatabasesOracleSQL ServerPostgreSQLBigQueryData EngineeringETL/ELT Design and DevelopmentData MigrationData Quality FrameworksData GovernancePerformance OptimizationLeadershipTechnical LeadershipTeam ManagementStakeholder CommunicationDelivery ManagementAgile/Scrum Methodologies, Preferred QualificationsBachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or related field.GCP Professional Data Engineer Certification preferred.Informatica Certification preferred.Experience working in Retail, Supply Chain, Logistics, or Consumer Business domains is a plus.Exposure to Data Lake, Lakehouse, and real-time streaming architectures.