ETL Developer / Enhancements Lead

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

Job summary

A growing software consultancy in New Jersey is seeking a skilled individual with extensive experience in Informatica PowerCenter and complex ETL jobs. Candidates should have at least 4 years of Java experience and a Bachelor's degree or equivalent. This is a full-time position open to U.S. citizens and authorized workers, emphasizing hands-on experience in ETL best practices and global delivery management.

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution.
• At least 4 years of experience with Java technologies.

Responsibilities

• Develop complex ETL jobs using Informatica.
• Manage global delivery structure and ensure high quality.

Skills

Informatica PowerCenter

ETL jobs Development

Teradata

Java technologies

Data Quality

Data Profiling

Architectural Design

Education

Bachelor's degree or equivalent experience

Tools

Version Control Tools

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
• Experience in Informatica Complex ETL jobs Development
• Experience in Informatica Complex Transformations, Partitioning, PushDown Optimization
• Experience in Informatica Tasks - Session, email, Command, etc
• Experience in Informatica Experience in Processing various sources including flat files, Oracle, XML,etc
• Experience in Teradata - BTEQ Scripts Development
• Experience in Teradata Load Utilities - FastLoad, MultiLoad, TRUMP,FastExport
• Experience in building Teradata Objects: Tables, views, macros, stored procedures and triggers
• Experience in Teradata Performance Tuning - Debugging the Job, Collect Stats Experience in large scale Maintenance Projects that involves extensive Impact Analysis, Code Modifications and Deployment
• Exposure/Knowledge on MDM
• We need someone who is HANDS-ON
• Change Management
• Architectural Design and Data Modelling Experience
• Experience in Writing and validating Data Quality rules against Data
• Experience in Data Profiling
• Work with multiple stakeholders
• Manage Global Delivery structure
• Status Reporting Periodic to Clients/Stakeholders
• Experience in Implementing Best Practices of ETL Projects
• Experience in following and adhering to Process Framework
• Experience in Version Control Tools, Code Comparison approaches.

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.
• OnlyUS 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 youremail orresume.