Senior Technical Consultant

Job description

seeking an experienced Data Engineer to design, develop, and optimize scalable enterprise data pipelines and transformation solutions on Google Cloud Platform (GCP). Key Responsibilities Data Engineering & Development • Design and develop scalable data ingestion, transformation, and processing pipelines on GCP. • Build reusable engineering frameworks and patterns for batch, incremental, and Change Data Capture (CDC) workloads. • Develop and maintain data transformations using BigQuery, Dataform, SQL, and Python . • Convert business and technical requirements into efficient data engineering solutions. • Support high-volume enterprise data migration and modernization initiatives. GCP Data Platform • Design and implement solutions using GCP services such as: • BigQuery • Cloud Storage • Pub/Sub • Dataflow • Dataproc • Cloud Composer • Dataform • Optimize BigQuery datasets, queries, partitioning, clustering, and overall workload performance. Data Integration & CDC • Design and implement batch and near-real-time data integration patterns. • Build CDC pipelines from enterprise source systems into GCP. • Handle inserts, updates, deletes, schema changes, incremental loads, and error/reprocessing scenarios. • Experience with CDC/integration technologies such as Qlik Replicate/Qlik CDC, Datastream, Informatica, or equivalent is advantageous. Data Quality & Reconciliation • Implement data validation and reconciliation between source and target systems. • Develop automated controls covering row counts, duplicates, nulls, aggregates, business rules, and transformation accuracy. • Troubleshoot data discrepancies and work with source-system, QA, and business teams to resolve issues. • Support SIT, UAT, migration rehearsals, production cutover, and hypercare. DevOps & Automation • Implement CI/CD practices for data engineering workloads. • Maintain source code and deployment artifacts using Git/GitHub . • Integrate automated testing and deployment into pipelines using tools such as GitHub Actions, Cloud Build, Jenkins, or equivalent . • Promote reusable coding standards, parameterized solutions, and automated deployments across environments. Technical Leadership • Provide technical guidance and mentoring to junior data engineers. • Review solution designs, code, SQL, transformation logic, and deployment artifacts. • Define reusable patterns and data engineering best practices. • Collaborate with Data Architects, Platform Engineers, Data Modelers, DBAs, QA teams, and business stakeholders. • Support technical troubleshooting and root-cause analysis of complex data issues. Skill Requirements Core skills • Google Cloud Platform (GCP) • BigQuery • Dataform • Advanced SQL • Python • Data integration / ETL / ELT • CDC patterns • Data modeling concepts • Git / GitHub • CI/CD • Data reconciliation and testing Other Requirements • 5- 9 years of overall data engineering/ETL experience with strong hands-on cloud data engineering expertise. • Strong experience working with large datasets and complex SQL transformations. • Experience delivering enterprise data migration, modernization, or analytics solutions. • Strong analytical, troubleshooting, communication, and stakeholder-management skills. Preferred Certifications • Google Cloud Professional Data Engineer 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 230,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 September 2026 totaled $14.8 billion. • Disclaimer • Privacy Statement • Terms of use • Sitemap • Raise a Grievance • We use cookies on our site. Please read more about cookies policy here. • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. • Opens in a new tab. Copyright © 2026 HCL Technologies Limited Cookie Consent Manager When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. Required Cookies These cookies are required to use this website and can't be turned off. Required Cookies Required Cookies Provider Description Enabled SAP as service provider We use the following session cookies, which are all required to enable the website to function: • "route" is used for session stickiness • "careerSiteCompanyId" is used to send the request to the correct data center • "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor • "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another Cookies from provider SAPasserviceprovider are required and cannot be turned off Functional Cookies These cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies. Consent to all Functional Cookies Functional Cookies Provider Description Enabled Vimeo Vimeo is a video hosting, sharing, and services platform focused on the delivery of video. Opting out of Vimeo cookies will disable your ability to watch or interact with Vimeo videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider Vimeo YouTube YouTube is a video-sharing service where users can create their own profile, upload videos, watch, like, and comment on videos. Opting out of YouTube cookies will disable your ability to watch or interact with YouTube videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider YouTube Advertising Cookies These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies. Consent to all Advertising Cookies Advertising Cookies Provider Description Enabled Google Analytics Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. Cookie Information Privacy Policy Terms and Conditions Consent to cookies from provider GoogleAnalytics Google Tag Manager Google Tag Manager is a tag management system for conversion tracking, site analytics, remarketing, and more. Privacy Policy Terms and Conditions Consent to cookies from provider GoogleTagManager LinkedIn LinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn. Cookie Policy Cookie Table Privacy Policy Terms and Conditions Consent to cookies from provider LinkedIn