Lead ETL Developer/ Analyst
Aroha Technologies
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- Test Cases
- Test Plans
- Data Analysis
- Data Quality
- Marketing Analysis
- SQL
- SQL Queries
- ETL
- Performance Tuning
- Shell Scripting
- Data Pipelines
- Informatica
- UNIX
- Reconciliation
- Data Warehousing
- Datasets
- Data Validation
- Sampling
- PowerCenter
Summary
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
- Dice Id: 10515154
- Position Id: 2026-6805/37291
- Posted 8 hours ago
Company Info
About Aroha Technologies
Michael Arrington, founder and co-editor of Tech Crunch once famously said that ‘The best startups generally come from somebody needing to scratch an itch’.
Quite true to the thought, Aroha Technologies Inc was launched in 2008 in Florida. While we began our journey with a powerful Staffing Specialist & Software Development, Today our procedure has amplified into a more robust and simplified solution for Marketers looking for consistent and long term.
In our quest to do better, we resolve to simplify user acquisition, retention, engagement and large Business without blinking an eyelid! A semi-remote team spread across the globe, we are here to help you one step at a time.
Unmatchable growing excellence When AROHA was formed, we interviewed many potential clients and business colleagues and asked what a single important question seemed: “If you could design a firm to meet your needs, what would it look like?” The answers to that question have guided our thinking and planning on an ongoing basis, and form the core of our thinking about how we treat our clients and our employees, whom we call associates.
At a most basic level, we have stated our mission in a promise to our clients and our associates: “Unmatchable growing excellence.” This alignment governs superior service to our customers and supports our associates who perform that work, which cannot be matched by our competitors.
In short, we believe that care of our associates, disciplined financial management, and constant attention to the fundamentals of good delivery adds up to a successful, scalable business.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs