ETL Developer

idexcel; Piscataway Township (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A global staffing and IT services organization is seeking an ETL Developer in Piscataway, New Jersey. The role focuses on data delivery, reporting, and analytics within Supply Chain IT. The ideal candidate will have extensive experience with ETL tools like Informatica and strong SQL skills. Responsibilities include designing complex software applications and fulfilling business analytics needs. Candidates must possess US work authorization and be ready for a long-term position with W2 requirements.

Qualifications

• 5+ years of experience with ETL software tool Informatica.
• Proven ability to read and write complex SQL queries.
• Experience with reporting tools Cognos/Tableau preferred.
• 5+ years experience with Informatica ETL.
• 5+ years Informatica Data Quality in data cleansing, matching, conversion, exception handling, reporting and monitoring.
• Experience with Cognos/Tableau preferable.
• Knowledge of data warehouse concepts.
• Able to write complex Oracle queries for data validation.

Responsibilities

• Design and code from specifications.
• Analyze, evaluate, test, debug, and document software applications.
• Deliver reporting and analytics needs for the business.
• Collaborates with BI and IT teams to deliver analytics solutions in Supply Chain IT.
• Ensures performance, quality, and data integrity across ETL pipelines.

Skills

SQL queries

ETL software tool Informatica

Data cleansing

Data matching

Data validation

Reporting tools Cognos/Tableau

Database performance

Data warehouse concepts

Analytics trends

Tools

Informatica

Cognos

Tableau

Job description

Idexcel is a global staffing and IT services organization, with a mission to bring great people and great organizations together. Our diverse client base represents a wide range of industries, including technology, telecom, insurance, healthcare, manufacturing, banking & financial services, food & commodities trading and federal organizations. Our teams of experienced recruiters directly work with client companies seeking exceptional people to help with their business initiatives.

Idexcel, Inc. is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.

Job Description

Job Title : ETL Developer

Location : Piscataway, New Jersey 08854

Duration : Long Term

W2 Requirement

This position is in Supply Chain IT. Individual will a member of the business intelligence development team delivering data, reporting & analytics needs for the business. The candidate will contribute to the intake, analysis, design, modeling, development, quality assurance and support of Supply Chain analytics.

• Designs and codes from specifications, analyzes, evaluates, tests, debugs, documents, and implements moderately complex software applications
• Experience designing and developing dashboard applications with full Reporting and Analytics functionality
• Proven ability to read and write complex SQL queries
• Deep understanding of Database Performance aspects
• 5+ Experience with the use and capabilities of ETL software tool Informatica
• 5+ year of experience in Informatica data quality tool in data cleansing, data matching, data conversion, exception handling, reporting and monitoring
• Experience with reporting tools Cognos/Tableau preferable
• Good understanding Data warehouse concepts
• Able to write complex relational Oracle queries to help with data validation
• Ability to complete deliverables in a tightly timeframe with cost effective testing and release cycle
• Knowledge of latest analytics trends preferred

Primary Skill Requirement

Additional Information

Note: Only US work Authorization candidates can apply for this job, W2 Requirement