Logo
SonSoft

ETL Developer / Enhancements Lead

SonSoft, Madison, New Jersey, us, 07940

Save Job

Sonsoft, Inc. is a USA-based corporation organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. specializes in Software Development, Software Consultancy, and Information Technology Enabled Services. Job Description

Extensive experience with Informatica PowerCenter (version 8.6 or higher) Development of complex ETL jobs in Informatica Experience with complex transformations, partitioning, and pushdown optimization in Informatica Proficiency in Informatica tasks such as sessions, emails, commands, etc. Processing data from various sources including flat files, Oracle, XML, etc. Experience with Teradata, including BTEQ script development, load utilities (FastLoad, MultiLoad, TRUMP, FastExport), and building Teradata objects like tables, views, macros, stored procedures, and triggers Teradata performance tuning and debugging jobs, with experience in large-scale maintenance projects involving impact analysis, code modifications, and deployment Knowledge or exposure to Master Data Management (MDM) Hands-on experience is required Change management, architectural design, and data modeling experience Writing and validating data quality rules, data profiling Ability to work with multiple stakeholders and manage global delivery structures Periodic status reporting to clients and stakeholders Adherence to ETL best practices and process frameworks Experience with version control tools and code comparison approaches Qualifications

Bachelors degree or equivalent from an accredited institution; three years of progressive experience can substitute for each 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. Sponsorship is not available at this time. Note: This is a

FULL TIME

job opportunity. Applicants must be US Citizens, Green Card Holders, GC-EAD, H4-EAD, L2-EAD, or TN Visa holders. H1-B and OPT are not applicable for this position. Please include your email ID in your email or resume.

#J-18808-Ljbffr