ETL Informatica Support Lead

Reposted 7 Days Ago
Be an Early Applicant
Madison, NJ, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Lead ETL support for Informatica PowerCenter: hands-on monitoring, debugging, code migration, DR support, and incident management. Provide architecture, data modeling, profiling, and data quality rule implementation. Manage global delivery, report status to stakeholders, and work with schedulers (Autosys/TWS) and Teradata environments.
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

  • 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

  • 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 Fulltime job oppurtunity.
  2. Only US CitizenGreen Card HolderGC-EADH4-EADL2-EADTN VIsa can apply.
  3. No H1-B  & OPT is applicable for this position.
  4. Please mention your email id in your email or resume.

Skills Required

  • Extensive Informatica PowerCenter (8.6 or higher) experience
  • Teradata experience (SQL, BTEQ, export utilities, job development and debugging)
  • At least 4 years of experience with Java technologies
  • Hands-on ETL support: job monitoring, debugging failed jobs, incident management
  • Experience with ETL code migration/deployment and supporting DR activities for Informatica
  • Architectural design and data modeling experience
  • Data profiling and writing/executing data quality rules against datasets
  • Experience with third-party schedulers (Autosys, TWS)
  • Automation experience in ETL support projects
  • Exposure to MicroStrategy/Tableau
  • Exposure to MDM
  • Bachelor's degree or equivalent (or progressive experience in lieu of education)
  • Authorization to work in the U.S. without sponsorship (US Citizen, Green Card, GC-EAD, H4-EAD, L2-EAD, TN Visa)
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

BAE Systems, Inc. Logo BAE Systems, Inc.

Senior Principal System Security Lead

Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Hybrid
Totowa, NJ, USA
40000 Employees
153K-261K Annually

Dynatrace Logo Dynatrace

Senior Data Analyst

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Remote or Hybrid
United States
5600 Employees
86K-107K Annually

Zocdoc Logo Zocdoc

Account Director

Healthtech • Information Technology • Software • Telehealth
Easy Apply
Remote or Hybrid
USA
900 Employees
170K-220K Annually

Grow Therapy Logo Grow Therapy

Provider Growth Associate

Healthtech • Social Impact • Software
Remote or Hybrid
USA
460 Employees
31-31 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