ETL Informatica Developer / Enhancements Lead

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

Job summary

A technology services firm in Madison, NJ is seeking a skilled individual with extensive experience in Informatica and Teradata for a full-time position. The ideal candidate will have at least a Bachelor’s degree and 4 years of Java technology experience. Responsibilities include developing complex ETL jobs, managing stakeholder communications, and adhering to best practices. U.S. citizenship or equivalent is required, and unfortunately, no sponsorship is available.

Qualifications

• Bachelors or progressive experience in relevant field.
• At least 4 years of experience with Java technologies.

Responsibilities

• Develop complex ETL jobs using Informatica.
• Build and tune Teradata objects for performance.
• Collaborate with multiple stakeholders for project management.

Skills

Informatica PowerCenter

ETL Development

Data Profiling

Change Management

Java technologies

Education

Bachelor’s degree or foreign equivalent

Tools

Teradata

Version Control Tools

Job description

• Full-time

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
• 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 TIME job opportunity.
• OnlyUS 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.