Lead ETL Developer

ETL Developer / Enhancements LeadSonsoft, 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 DescriptionExtensive 8.6 or Higher Version- Informatica PowerCenter Technical ExperienceExperience in Informatica Complex ETL jobs DevelopmentExperience in Informatica Complex Transformations, Partitioning, PushDown OptimizationExperience in Informatica Tasks - Session, email, Command, etcExperience in Informatica Experience in Processing various sources including flat files, Oracle, XML, etcExperience in Informatica - SCD2, SCD3 ImplementationExperience in Teradata - BTEQ Scripts DevelopmentExperience in Teradata Load Utilities - FastLoad, MultiLoad, TRUMP, FastExportExperience in building Teradata Objects: Tables, views, macros, stored procedures and triggersExperience in Teradata Performance Tuning - Debugging the Job, Collect Stats Experience in large scale Maintenance Projects that involves extensive Impact Analysis, Code Modifications and DeploymentExposure/Knowledge on MDMWe need someone who is HANDS-ONChange ManagementArchitectural Design and Data Modelling ExperienceExperience in Writing and validating Data Quality rules against DataExperience in Data ProfilingWork with multiple stakeholdersManage Global Delivery structureStatus Reporting Periodic to Clients/StakeholdersExperience in Implementing Best Practices of ETL ProjectsExperience in following and adhering to Process FrameworkExperience in Version Control Tools, Code Comparison approaches.QualificationsBachelor'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 TIME job opportunity.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.