ETL Dev Lead

Posted 2 Days Ago
Be an Early Applicant
Woodbridge Township, NJ, USA
In-Office
Senior level
Professional Services • Industrial • Manufacturing
The Role
Lead ETL developer responsible for designing and implementing Informatica PowerCenter ETLs to load an Oracle data warehouse. Duties include developing mappings, converting PL/SQL ETLs to Informatica, writing complex Oracle PL/SQL, troubleshooting transaction errors, performance tuning, and supporting data conversion strategy for analytical systems.
Summary Generated by Built In
Company Description

E*Pro Technologies is a world class IT solution provider offering technology solutions and managed services in verticals such as Customer Contact, Health care and Finance (banking & trading). Headquartered in the United States and with delivery centers in India, E*Pro has extended its services across the globe. E*Pro has evolved from being a business consulting company in its early stages to an one stop IT solution provider over the years.
Specialties involved,
Voice, Trading Solutions, Customer Contact Solutions, Healthcare Solutions, Microsoft Technologies, Java, Web 2.0, IT Staff Augmentation, Testing
Headquarters
1000 Route 9 North, Suite 303 Woodbridge, NJ 07095 United States
For more details please visit our website:www.epro-tech.com

Job Description

Seeking Informatica PowerCenter Developer with BI/DW experience needed to develop and enhance ETLs from various sources to Oracle data warehouse.
Responsible for devising data conversion strategy for a system focused on delivering an advanced analytical capability to the client.
Duties may include creation of new Informatica scripts, transition of PL/SQL ETLs to new Informatica scripts, or modification of existing scripts.
The candidate will be involved in developing Informatica Mappings and writing complex Oracle PL/SQL programs for the Data Warehouse.
Other tasks involve analyzing transaction errors, troubleshooting issues in the software, developing bug-fixes, involving in performance tuning efforts –
Must have strong Oracle PL/SQL experience –
Must have strong Oracle database structure creation, modification experience.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

  • Informatica PowerCenter development experience
  • BI/Data Warehouse (ETL) experience
  • Strong Oracle PL/SQL experience (complex programs)
  • Oracle database structure creation and modification experience
  • Experience developing Informatica mappings
  • Experience analyzing transaction errors, troubleshooting, and developing bug fixes
  • Performance tuning experience for ETL and database processes
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
6 Employees
Year Founded: 2011

What We Do

EPRO Services, Inc. is a leading provider of superior waterproofing and contaminant protection systems designed to keep building structures dry and safe. Founded in 1993, the company specializes in building envelope protection, offering a comprehensive range of solutions including vapor intrusion mitigation, air barrier systems, and leak repair services for a variety of site conditions across the United States and Canada.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

ETL Talend Lead

Information Technology • Professional Services • Software • Consulting
In-Office
Jersey City, NJ, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

ETL Talend Lead

Information Technology • Professional Services • Software • Consulting
In-Office
Jersey City, NJ, USA
87 Employees

DraftKings Logo DraftKings

Community Associate

Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Remote or Hybrid
United States
6400 Employees
56K-70K Annually

DraftKings Logo DraftKings

Security Engineer

Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Remote or Hybrid
United States
6400 Employees
161K-201K Annually

Similar Companies Hiring

True Anomaly Thumbnail
Aerospace • Artificial Intelligence • Hardware • Machine Learning • Software • Defense • Manufacturing
Centennial, CO
300 Employees
Fortune Brands Innovations Thumbnail
Manufacturing
Deerfield, IL
10000 Employees
Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account