Senior Technical Lead (IN)

HCLTech

5+ yrs India Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a seasoned Senior Technical Lead to spearhead our data modernization initiatives within the AWS ecosystem. This role demands a deep understanding of database technologies and extensive experience in cloud-based data engineering.

You will be instrumental in transforming existing SQL Server environments into robust, scalable PostgreSQL solutions on Amazon Aurora. A key focus will be migrating complex ETL processes and analytical workloads to leverage the power of AWS services.

This is an opportunity to shape the future of our data architecture, implementing cutting-edge solutions and ensuring best practices in data management, security, and operations. Your leadership will guide the team towards successful project delivery and innovation.

Responsibilities

Lead the modernization of SQL Server databases to Amazon Aurora PostgreSQL.

Analyze and convert SSIS ETL workflows into efficient AWS Glue jobs and workflows.

Migrate SSAS models and analytical workloads to Amazon Redshift for enhanced performance.

Rebuild SSRS reports and dashboards utilizing AWS QuickSight for improved business intelligence.

Design and develop scalable data ingestion, transformation, and reporting solutions.

Optimize data models, schemas, and database performance for maximum efficiency.

Build and maintain CI/CD pipelines for seamless database and data pipeline deployments.

Implement robust data quality, monitoring, and operational support capabilities.

Collaborate closely with architects, developers, business stakeholders, and reporting teams to achieve migration objectives.

Support all testing, reconciliation, cutover, and post-production activities.

Qualifications

A minimum of 5 years of experience in Database and Data Engineering is required.

Possess strong expertise in SQL and database performance tuning.

Demonstrate experience with AWS data services, including Amazon Aurora PostgreSQL, AWS Glue, Amazon Redshift, and AWS QuickSight. Familiarity with AWS DMS and Schema Conversion Tool is desirable.

Exhibit strong SQL and data modeling skills, along with proficiency in Python and/or PySpark.

Proven experience in building ETL/ELT pipelines and cloud-native data solutions is essential.

Familiarity with Git, CI/CD, DevOps, and Agile delivery practices is necessary.

Understanding of data governance, security, and operational support principles is expected.

Knowledge of data technologies such as Athena, Iceberg, Flink, and Kafka is beneficial.

Familiarity with cloud hosting environments like AWS, understanding of network design, and AWS native services such as Step Functions are valuable.

Experience with data pipelines using Airflow, data ingestion, transformation, governance, and semantic/physical data modeling is required.

Proficiency in developing RESTful services and automation scripts is needed.

Experience with DevOps tools like Jenkins, Git, Docker, Kubernetes, and IAM Vault, along with an operations mindset, is crucial.

Understanding of data governance, risk management, and agile delivery collaboration with squads and stakeholders is expected.

Essential Skills

SQLDatabase Performance TuningAmazon Aurora PostgreSQLAWS GlueAmazon RedshiftAWS QuickSightAWS DMSSchema Conversion ToolData ModelingPythonPySparkETLELTCloud-Native Data SolutionsGitCI/CDDevOpsAgileData GovernanceData SecurityOperational SupportAWSAirflowRESTful ServicesAutomation ScriptsJenkinsDockerKubernetesIAM VaultRisk Management

Highlights

  • Actively hiring

More Details

RoleSenior Technical Lead (IN)
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting

Senior Technical Lead (IN) at HCLTech | SkillMX | SkillMX