Senior Technical Lead
United States
Apply now
Job Description
Senior Technical Lead
Davidson, Tennessee

Job Summary

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 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.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

Key Responsibilities

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.

Skill Requirements

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

Other Requirements

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.
Maximum Salary (US): 
Minimum Salary (US): 
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion. 

 

Compensation and Benefits

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.