Lead ETL Developer/ Analyst

Job Title/Role Name Lead ETL Developer/ Analyst
Experience level (Years) 9+ yrs

Client Interview (Yes/No) Yes
No. of Positions 1

Other Requirement Candidate must have:-

Must be on HCLtech vendor W2, no layering is allowed

Valid visa with min 12 months validity

Resume should have LinkedIn URL to validate

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

Vendor SPOC must enter his contact details (Name, Email, Phone#) so that TAG can reach out for next steps if profile get shortlisted

Must have skills
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


Detailed Job Description:
Essential Skills & Responsibilities

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.
Experience: 5+Years
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