Lead ETL Developer/ Analyst

Resource Logistics, Inc.

New jersey, NJ

Apply

JOB DETAILS

SKILLS

Analysis Skills, Data Analysis, Data Management, Data Processing, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Identify Issues, Informatica, Insurance, Performance Tuning/Optimization, Problem Solving Skills, Query Optimization, Reconciliation, SQL (Structured Query Language), Scripting (Scripting Languages), Test Automation, Test Case, Test Design, Test Plan/Schedule, Testing, Unix Shell Programming

LOCATION

New jersey, NJ

POSTED

11 days ago

Job Title: Lead ETL Developer/ Analyst
Location: New Jersey onsite
Experience level (Years) 9+ yrs

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.

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

About the Company

Resource Logistics, Inc.

COMPANY SIZE

500 to 999 employees

INDUSTRY

Medical Devices and Supplies

Resume Resources

Free Resume Templates Free Resume Builder