ETL Support Lead

Sonsoft Inc; Madison (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A growing technology firm based in New Jersey is seeking a hands-on Informatica PowerCenter expert with at least 4 years of Java experience. The role involves managing global delivery structures, executing data quality rules, and providing status reports to clients. This is a full-time position for U.S. citizens and authorized workers only, as sponsorship is not available. If you meet these qualifications, we encourage you to apply.

Qualifications

• Bachelor’s degree or equivalent from an accredited institution.
• 4+ years of experience with Java technologies.
• Extensive experience with Informatica PowerCenter.

Responsibilities

• Manage Global Delivery structure and act as point of contact.
• Execute and write Data Quality Rules against datasets.
• Provide status reports to clients/stakeholders.

Skills

Informatica PowerCenter

Teradata - SQL Queries

Data Modelling

Data Profiling

Java technologies

Automation in ETL

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 Infomatica 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 aFull Timejob oppurtunity.
• Only US Citizen,Green Card Holder,GC-EAD,H4-EAD,L2-EAD,TN VIsacan apply.
• No H1-B & OPT is applicable for this position.
  
• Please mention your email id in your emai l or resume .