ETL 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
Hands-on ETL support lead responsible for Informatica PowerCenter operations (8.6+), Teradata SQL/BTEQ jobs, job monitoring/debugging, DR and deployment support, ETL automation, data modelling, profiling, data quality rule execution, incident management, and global delivery/status reporting.
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 Full Time 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 (v8.6 or higher) technical experience
  • Extensive Teradata experience including SQL queries, BTEQ, job development, export utilities, and job debugging
  • Experience with job monitoring and debugging of failed ETL jobs
  • Hands-on ETL support experience (operations, incident resolution, server recovery)
  • Experience supporting DR activities and resolving Informatica PowerCenter server outages
  • Experience supporting Informatica code migration/deployment into production
  • Automation experience in ETL support projects
  • Work experience with third-party schedulers (Autosys, TWS, etc.)
  • Experience in detailed investigation of long running jobs and performance suggestions
  • Architectural design and data modeling experience
  • Experience in data profiling
  • Experience writing and executing data quality rules against datasets
  • At least a Bachelor's degree or equivalent (or progressive experience substitution as described)
  • At least 4 years of experience with Java technologies
  • Exposure to MicroStrategy (MSTR) or Tableau
  • Exposure to Master Data Management (MDM)
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 Support Lead

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

SonSoft Inc. Logo SonSoft Inc.

ETL Informatica Support Lead

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

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

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