Name Lead ETL Developer/ Analyst

Build automated reconciliation framework with sampling, diffing & volume -ready checks Build data quality framework to apply pro-active checks on data before . Investigate and resolve data issues across upstream and downstream systems, ensuring seamless data flow Write and optimize complex SQL queries to validate large datasets and troubleshoot issues Design, develop, and enhance Informatica PowerCenter ETL mappings, workflows, and sessions for new development and ongoing enhancements.

Must be on HCLtech vendor W2, no layering is allowed

Valid visa with min 12 months validity, Strong SQL expertise for data analysis, reconciliation, and performance tuning.

Experience: 5+Years Develop and maintain Unix shell scripts for ETL automation, file processing, job orchestration, and monitoring. Experience: 2+Years

Preferred skills: Experience or understanding of the insurance distribution domain, Strong SQL expertise for data analysis, reconciliation, and performance tuning. Experience: 5+Years Develop and maintain Unix shell scripts for ETL automation, file processing, job orchestration, and monitoring. Experience: 2+Years

Good to Have Experience or understanding of the insurance distribution domain

Technical Skills

Strong SQL and Informatica skills (complex queries, joins, aggregations, large dataset validation) Understanding of ETL processes, data pipelines, and data warehousing concepts Experience with data validation, reconciliation, and profiling techniques Experience designing and developing test plans and automated test cases

Must be good with 5 days onsite working as per customer expectation along with 6 months contract to hire