Lead ETL Developer/ Analyst

Jersey City, NJ, US • Posted 2 hours ago • Updated 2 hours ago
Contract Independent
Contract Corp To Corp
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🫥 Flibbertigibetting...

Job Details

Skills

  • SQL
  • data analysis
  • reconciliationn
  • tuning.
  • orchestration
  • insurance distribution domain
  • unix shell

Summary

Must have skills
•            Strong SQL expertise for data analysis, reconciliation, and performance tuning.
o            Experience: 5+Years
•            Develop and maintain Unix shell scripts for ETL automation, file processing, job orchestration, and monitoring.
o            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.
o            Experience: 5+Years
•            Strong SQL expertise for data analysis, reconciliation, and performance tuning.
o            Experience: 5+Years
•            Develop and maintain Unix shell scripts for ETL automation, file processing, job orchestration, and monitoring.
o            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: 91098872
  • Position Id: 5603-10115-109818
  • Posted 2 hours ago
Contact the job poster
PA

Pooja Agarwal

Recruiter @ Shrive Technologies LLC
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Newark, New Jersey

Today

Easy Apply

Third Party, Contract

Depends on Experience

Jersey City, New Jersey

Today

Easy Apply

Contract

$68.00 - $68.25 per hour

Hybrid in Brooklyn, New York

3d ago

Easy Apply

Contract, Third Party

90+

Hybrid in Morristown, New Jersey

15d ago

Easy Apply

Contract

$70 - $78

Search all similar jobs