Skip to main content
Tallo logoTallo logo

Find Jobs

Find Jobs Near You – Available Work in Your Location

Skip to job details

Back to Results

Apply for this opportunity

To apply for this job, you'll continue to an external website or email application.

HCL Technologies Limited

Senior Technical Lead

Review key factors to help you decide if the role fits your goals.
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
85
out of 100
Average of individual scores

Were these scores useful?

Job Description

Job Description Senior Technical Lead Davidson, Tennessee Job Summary Job Description:
Data Warehouse Lead - Informatica, Data Modelling & GCP Big DataPosition Data Warehouse Lead LocationIndiaExperience10-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 Job Alerts Link