ETL Support Lead

Reposted 6 Days Ago
Be an Early Applicant
Peapack, NJ, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Lead day-to-day ETL support and architecture for Informatica PowerCenter and Teradata environments. Hands-on responsibilities include job monitoring, debugging, data profiling, data quality rule execution, ETL automation, DR support, code migration, incident management, and stakeholder status reporting across a global delivery model.
Summary Generated by Built In
Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Description:-

  • Extensive 8.6 or Higher Version- Informatica PowerCenter Technical Experience
  • Extensive Experience in Teradata - SQL Queries, Bteq,Jobs Development ,Export Utilities, Jobs Debugging
  • Exposure to MSTR/Tableau. Exposure to MDM
  • We need someone who is HANDS-ON
  • Architectural Design and Data Modelling Experience
  • Experience in Data Profiling
  • Experience in writing and executing Data Quality Rules against Datasets
  • Single point of contact for overall solution/program - technically.
  • Manage Global Delivery structure
  • Status Reporting Periodic to Clients/Stakeholders
  • Incident Management
  • Experience in Implementing Best Practices of ETL Projects
  • Resolve the issues when the Infomatica PowerCenter server is down.
  • Support DR activities for Informatica PowerCenter
  • Support Informatica PowerCenter code migration/deployment activities into Production.
  • Automation Experience in ETL Support Projects
  • Extensive Experience in Jobs Monitoring and debugging of failed Jobs
  • Work Experience in Third Party Schedulers like Autosys, TWS, etc
  • Experience in detailed investigation of long running jobs and provide suggestions

Qualifications

Basic Qualifications :-

  • Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
  • At least 4 years of experience with Java technologies.

Additional Information

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

  1. This is a FULL TIME job oppurtunity.
  2. Only US CitizenGreen Card HolderGC-EADH4-EADL2-EADTN VIsa can apply.
  3. H1-B transfer can also apply.
  4.  OPT-EAD can also apply for this position.
  5. Please mention your email id in your email or resume.

Skills Required

  • Informatica PowerCenter (8.6 or higher) technical experience
  • Teradata experience: SQL queries, BTEQ, jobs development, export utilities, job debugging
  • Experience with job monitoring and debugging of failed ETL jobs
  • Experience with third-party schedulers (Autosys, TWS)
  • Hands-on experience in ETL support and automation
  • Architectural design and data modeling experience
  • Experience in data profiling
  • Experience writing and executing data quality rules against datasets
  • Incident management and DR support for Informatica PowerCenter
  • Support for Informatica code migration/deployment into production
  • Experience implementing ETL best practices
  • Experience investigating long-running jobs and providing recommendations
  • At least 4 years of experience with Java technologies
  • Exposure to MicroStrategy (MSTR) and/or Tableau
  • Exposure to MDM (Master Data Management)
  • Bachelor's degree or foreign equivalent (or equivalent progressive experience)
  • Ability to act as single technical point of contact and manage global delivery
  • Authorized to work in the U.S. (US citizen/Green Card/GC-EAD/H4-EAD/L2-EAD/TN/H1B transfer/OPT-EAD as noted)
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
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

ETL Informatica Support Lead

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

SonSoft Inc. Logo SonSoft Inc.

ETL Support Lead

Information Technology • Professional Services • Software • Consulting
In-Office
Madison, NJ, USA
87 Employees
Hybrid
Iselin, NJ, USA
205000 Employees
159K-305K Annually

Wells Fargo Logo Wells Fargo

Senior Premier Banker - Edison NJ

Fintech • Financial Services
Hybrid
Edison, NJ, USA
205000 Employees
37K-66K Hourly

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account