SME - Extract Transform Load (ETL), Data Lakes (IN)
HCLTech
HCLTech
Seeking an experienced Application Support Engineer to maintain and enhance enterprise Data Warehouse and Analytics platforms. This role focuses on ensuring the smooth operation of critical data systems, including monitoring, troubleshooting, and resolving production incidents. You will be instrumental in guaranteeing data availability and supporting vital ETL and reporting processes across diverse environments such as AWS, Hadoop, Netezza, and SSIS.
Key responsibilities include providing L2/L3 support for Data Warehouse and Analytics applications. You will be tasked with monitoring data pipelines and ETL jobs, troubleshooting production incidents within defined SLAs, and conducting root cause analysis to implement preventative measures. The role also involves supporting AWS, Hadoop, Netezza, and SSIS data platforms, validating data integrity, and managing job scheduling and performance tuning. Collaboration with development, infrastructure, and business teams is essential for effective issue resolution, alongside supporting release deployments and maintaining operational documentation.
To excel in this role, a strong background in Application Support and Production Support is essential. You should possess hands-on experience with AWS services (EC2, S3, RDS, CloudWatch) and have a solid understanding of the Hadoop Ecosystem (HDFS, Hive, Spark). Experience with IBM Netezza Data Warehouse and strong expertise in SSIS (SQL Server Integration Services) are crucial. A good grasp of SQL, ETL processes, and Data Warehousing concepts is required, along with proven experience in monitoring, incident management, and troubleshooting. Familiarity with batch scheduling tools and support processes is also necessary.
HCLTech
IT Consulting