ETL Developer​/Enhancements Lead

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.

• Extensive experience with Informatica Power Center (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 (Fast Load, Multi Load, TRUMP, Fast Export), 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

• Bachelor’s 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

** 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  your email or resume.