Apply Now

Lead ETL Developer/ Analyst

• Posted 10 hours ago • Updated 23 minutes ago

Contract Corp To Corp

Contract W2

Aroha Technologies

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10515154
Position Id: 2026-6805/37380
Posted 10 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.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Lansing, Michigan

•

Today

Programmer Analyst 6 - Senior IBM Master Data Management (MDM) & Integration Developer resumes are kept to 4-5 pages Contract that is able to extend. Dependent on Business need Interview Process: Virtual, Mostly technical interview with hiring manager and other team members with a little soft skills portion at the end. Likely to only be 1 round, but could be more if needed. Hybrid position, Mondays and Tuesdays are required on-site days (non-negotiable) Must meet these requirements from beginnin

Easy Apply

Third Party, Contract

Search all similar jobs