HCL Unica Product _Sr. ETL Tester and Performance Engineer _F2F Interview 10th Jan_Pune (Hinjawadi)

Greetings from "HCL Software"

"HCL Software: - Is a Product Development Division of HCL Tech: That operates its primary Software business. At HCL Software we Develop, Market, Sell and Support over 20 Product families in the areas of Customer Experience, Digital Solutions, Secure DevOps, Security & Automation.

About Unica Product: - HCL Unica is Cloud Native: Adopt the whole new HCL Unica - Cloud native integrated marketing platform that can be deployed with the choice and flexibility to scale on any cloud & any environment - public, private, or hybrid - in minutes.

Imp Note: Are you available for a F2F Interview on Saturday (10th Jan) In Pune HCL Software office?

Location/Venue: Mekong 2nd Floor, Embassy TechZone, Hinjewadi Rajiv Gandhi Infotech Park, Hinjawadi Phase 2, Pune, Maharashtra .

Qualifications: -

We are looking for a Sr. ETL Tester and Performance Engineer with 5+ Yrs experience in our Unica Product team who possess the following skills: -

Job Summary : -

We are seeking a detail-oriented ETL Tester and Performance Engineer to ensure the accuracy, reliability, and performance of enterprise data pipelines. The role involves validating ETL processes, performing data quality checks, and conducting performance and load testing to ensure optimal system behaviour under varying workloads.

Key Responsibilities: -

Required Skills

• Strong experience in ETL testing and data validation
• Proficiency in advanced SQL skills (complex queries, joins, subqueries, performance tuning)
• Experience with performance testing tools (e.g., JMeter, LoadRunner, etc.)
• Hands-on experience with Python for data validation, test automation, scripting, and log analysis
• Experience working with relational databases (Oracle, SQL Server, MySQL, PostgreSQL)
• Experience analysing job execution trends, data volumes, failures, and SLA adherence
• Proficiency in identifying performance bottlenecks through log analysis, query analysis, and system metrics
• Familiarity with Unix/Linux commands and shell scripting.

ETL Testing Responsibilities

• Analyze business and technical requirements to design ETL test strategies and test cases
• Validate data extraction, transformation, and loading processes across source and target systems
• Perform data reconciliation, data integrity, and data completeness checks
• Execute functional, regression, and system testing for ETL workflows
• Identify, log, and track data defects using defect management tools
• Validate data transformations, aggregations, and business rules
• Collaborate with data engineers, DBAs, and business stakeholders to resolve issues

Performance Engineering Responsibilities

• Design and execute performance, load, stress, and scalability tests for ETL jobs and data pipelines
• Monitor ETL job execution times, resource utilization, and system bottlenecks
• Analyze performance test results and provide optimization recommendations
• Tune SQL queries, indexes, and ETL workflows for better performance
• Support performance benchmarking and capacity planning activities.