ZipRecruiter

Log In

1

Etl Informatica Data Engineer Jobs in New Jersey

Avance Consulting Services

ETL Lead

Somerville, NJ · On-site

Fulltime Candidate must be experienced working in ETL based projects involving InformaticaMust be fully versed in working with Informatica Must have an understanding of ERP business processes, data ...

idexcel

NJ

$51 - $66.75/hr

Job Title : ETL Developer Location : Piscataway, New Jersey 08854 Duration : Long Term Client ... IT. Individual will a member of the business intelligence development team delivering data ...

NAVA Software Solutions

ETL Developer

Jersey City, NJ · On-site

$53 - $69.50/hr

NAVA Software solutions is looking for a ETL Developer Details: ETL Developer Location: Jersey city ... Implement ETL solutions for large volume of data by applying various data warehouse modeling ...

MM International

ETL Developer

Jersey City, NJ · On-site

$53.25 - $69.75/hr

Role: ETL Developer Location: Jersey City. NJ/Plano, TX - Hybrid (3 days onsite and 2 days remote ... complex ETL workflows using Informatica Powercenter. Create data mapping to ingest data from ...

Saxon Global

ETL Developer

Hoboken, NJ

$55.75 - $73/hr

... IT consulting, and engineering solution services from past 16 years ... Saxon global specializes in Business Intelligence, Mobility, Big Data & Cloud and provides IT tools ...

Info Way Solutions

ETL Tester (ETL/ Python)

Princeton, NJ · On-site

$54 - $70.50/hr

The role involves hands-on ETL/Big Data testing experience, writing complex Spark queries, and ... Founded and incorporated in 2012 , Info Way Solutions is an IT services and consulting company ...

next page

Showing results 1-20

All JobsEtl Informatica Data Engineer JobsEtl Informatica Data Engineer Jobs in New Jersey

Etl Informatica Data Engineer information

What is an ETL Informatica Data Engineer?

An ETL Informatica Data Engineer is a professional who specializes in designing, developing, and maintaining data integration workflows using Informatica tools. They are responsible for extracting data from various sources, transforming it according to business requirements, and loading it into data warehouses or databases. These engineers ensure that data is accurate, consistent, and accessible to support business analytics and reporting. They also troubleshoot ETL processes, optimize performance, and collaborate with other data professionals to meet organizational goals.

What are the key skills and qualifications needed to thrive as an ETL Informatica Data Engineer?

To thrive as an ETL Informatica Data Engineer, you need strong expertise in data warehousing, ETL processes, SQL, and a solid understanding of database concepts, often supported by a degree in computer science or related fields. Proficiency in Informatica PowerCenter, other ETL tools, and familiarity with databases like Oracle or SQL Server, along with certifications such as Informatica Certified Professional, are highly valued. Analytical thinking, problem-solving abilities, and effective communication stand out as essential soft skills for collaborating with stakeholders and troubleshooting complex data issues. These skills and qualifications are crucial for ensuring efficient, accurate, and scalable data integration that supports business intelligence and analytics initiatives.

What are some common challenges faced by ETL Informatica Data Engineers when integrating data from multiple sources?

ETL Informatica Data Engineers often encounter challenges such as handling inconsistent data formats, ensuring data quality, and managing large volumes of data from diverse sources. Resolving data mapping issues, dealing with performance bottlenecks during data loading, and ensuring seamless integration between legacy and modern systems are also common. Collaborating closely with data architects, business analysts, and QA teams helps to address these challenges effectively and deliver reliable data pipelines.

What is the difference between Etl Informatica Data Engineer vs Data Analyst?

AspectEtl Informatica Data EngineerData Analyst
Primary FocusDesigning, developing, and maintaining ETL processes using Informatica toolsAnalyzing data to generate reports and insights
Required SkillsETL development, SQL, Informatica PowerCenter, data warehousingData visualization, SQL, Excel, statistical analysis
Work EnvironmentData engineering teams, IT departments, data warehousesBusiness units, analytics teams, reporting platforms
CertificationsInformatica certifications, SQL certificationsNone specific, often data analysis or visualization certifications

The Etl Informatica Data Engineer focuses on building and maintaining data pipelines using Informatica tools, ensuring data is available for analysis. In contrast, Data Analysts interpret data to provide insights. While both roles require SQL skills, Data Engineers need expertise in ETL processes and data warehousing, whereas Data Analysts focus on data interpretation and reporting.

What cities in New Jersey are hiring for Etl Informatica Data Engineer jobs?

Cities in New Jersey with the most Etl Informatica Data Engineer job openings:

ETL Informatica Developer

Gladstone, NJ

Integrated Resources INC
Recruiting and Staffing Services • 51 - 200 employees
Learn more about Integrated Resources INCexternal

Full-time

Re-posted 14 days ago

Job description

Company Description

A Few Words About Us Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.

Job Description

Job Details:

Position: ETL Informatica Developer

Location: Peapack NJ

Duration: 6 months



Job Description:

Skills: 

4 plus years of technical experience in ETL Informatica Development. 

3 Plus years of experience in Cognos Framework Manager, Cognos Report Studio and Cognos Analysis Studio 

3 Plus years' experience in PL/SQL 

3 Plus years' experience in Oracle 11G and Sun Solaris 10. 

Strong analytical skills. 

Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica 

Provide technical expertise for ETL Development and Reporting in Cognos. Collaborate with business and technical teams to create and implement industry leading solutions. 

Communicate and coordinate clearly/extensively with function leads and technical teams to achieve project goals Proficiently manage all aspects of the System Development Life Cycle Develop solution deliverables ensuring expectations of stakeholders are met. 


Optional skills*:

Experience with integration for PeopleSoft HCM with Data warehouse.

Experience in UC4 job scheduling and Monitoring tool, TOAD 11.5 and HP Service Center will be preferable.



Additional Information

Kind Regards

Sachin Gaikwad

Technical Recruiter

Direct Line : 732-429-1920 

Integrated Resources, Inc.


Integrated Resources logo

About Integrated Resources

Sourced by ZipRecruiter

Integrated Resources Inc (IRI), based in Edison, NJ, US, is an esteemed player in the staffing solutions industry with a credible presence on their official website irionline.com. Notably, IRI provides a range of professional staffing services including contract, contract-to-hire, and direct hire solutions to a wide spectrum of industries such as healthcare, life sciences, manufacturing, financial, insurance, and others. Since its inception, IRI has been committed to delivering top-talent and optimum solutions to meet its clients' diverse needs.

Industry

Recruiting and staffing services

Company size

51 - 200 Employees

Headquarters location

Edison, NJ, US

Year founded

1996

View All Integrated Resources Jobs

Apply