> Markdown version of [/jobs/ext/1054956-name-lead-etl-developer-analyst](https://www.wearedevelopers.com/jobs/ext/1054956-name-lead-etl-developer-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Name Lead ETL Developer/ Analyst

- **Company:** Aroha Technologies
- **Location:** United States
- **Experience:** Expert
- **Contract:** Temporary to permanent
- **Skills:** Data Analysis, Automation of Tests, Big Data, Data Validation, Extract Transform Load (ETL), Data Warehousing, Database Queries, File Systems, Unix Shell, Performance Tuning, Standard Sql, Data Streaming, Freeform SQL, Informatica Powercenter, Data Pipelines
- **Published:** June 30, 2026
- **Apply:** https://www.dice.com/job-detail/8a292b69-86c7-4b80-bc20-a67825c91cb0

## About the Role

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

## Description

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.


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure)
- [Possibilities with Web Capabilities](https://www.wearedevelopers.com/videos/1575-possibilities-with-web-capabilities)
- [Old tools, new tricks](https://www.wearedevelopers.com/videos/1916-old-tools-new-tricks)
- [Behind the Curtain: How Recruiters Shortlist Devs in an AI-Driven Market and How You Stand Out](https://www.wearedevelopers.com/videos/100229-behind-the-curtain-how-recruiters-shortlist-devs-in-an-ai-driven-market-and-how-you-stand-out)
- [ Project Fugu: Progressive Web Apps, Superpowered](https://www.wearedevelopers.com/videos/290-project-fugu-progressive-web-apps-superpowered)

## Related Articles

- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)