ETL Informatica Support Lead

Sonsoft Inc; Madison (NJ); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology services company in New Jersey is seeking an experienced IT professional with expertise in Informatica PowerCenter and Teradata. The ideal candidate should have strong skills in data profiling and automation within ETL projects. A Bachelor’s degree or equivalent experience is required, along with at least 4 years in Java technologies. U.S. citizens and authorized workers can apply. This is a full-time position with no sponsorship available.

Qualifications

• Bachelor's degree or foreign equivalent required, or three years of relevant experience.
• At least 4 years of experience with Java technologies.

Responsibilities

• Extensive experience with Informatica PowerCenter.
• Manage global delivery structure and status reporting.
• Execute and monitor ETL processes and resolve issues.

Skills

Informatica PowerCenter

Teradata SQL Queries

Data Profiling

Data Quality Rules

ETL Automation

Java technologies

Education

Bachelor’s degree or foreign equivalent

Tools

Autosys

TWS

Job 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
• Experience in Implementing Best Practices of ETL Projects
• Resolve the issues when the Informatica PowerCenter server is down.
• 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:

• This is a Full-time job opportunity.
• Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN Visa can apply.
• No H1-B & OPT is applicable for this position.
• Please mention your email id in your email or resume.