ETL Developer / Enhancements Lead
sonsoftMadison (NJ)
ETL Developer / Enhancements Lead
Posted 43 days ago
sonsoftMadison (NJ)
SENIORITY
Lead
About the role
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 ExperienceExperience in Informatica Complex ETL jobs DevelopmentExperience in Informatica Complex Transformations, Partitioning, PushDown Optimization
- Experience in Informatica Tasks - Session, email, Command, etcExperience in Informatica Experience in Processing various sources including flat files, Oracle, XML, etcExperience in Informatica - SCD2, SCD3 Implementation
- Experience in Teradata - BTEQ Scripts DevelopmentExperience in Teradata Load Utilities - FastLoad, MultiLoad, TRUMP, FastExportExperience 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 MDMWe need someone who is HANDS-ONChange Management
- Architectural Design and Data Modelling ExperienceExperience 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 a FULL TIMEjob oppurtunity. Only US 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.
Summary
Type: Full-time
Function: Information Technology
Experience level: Mid-Senior Level
Industry: Information Technology And Services
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.