ETL/Informatica Analyst Developer

Company DescriptionSonSoft 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 DescriptionProvides ETL processing subject matter expertise to client projects Designs and implements industry best ETL technologies to satisfy client requirementsDesigns and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sourcesGathers and translates business requirements into analytical applications.Collaborates with other project members and drive the development of BI initiativesDesigns, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processesEstablishes ETL environments according to project requirementsDesign and implements an efficient migration process to move ETL objects from development to test and production environmentsUnderstands database design, programming concepts, data modeling and framework management.Daily Tasks Performed.Discuss and understand ETL requirements with Data AnalystsDevelop, build Informatica mapping, workflows, create scripts forproduction jobs; under a supervision of ETL Architect.Working with Operations to implement jobs and support warrantyUnit test, UAT, and SIT the data and able to document all the testprocess and results.WantsAt least 5 years of Informatica PowerCenter experience.This person will be the backup developer of the existing ETL developers, working well with the person is a crucial criterion.Due to the project requirements, this person cannot take a long vacation (more than 1 week) in the first 6 months.The visa status must allow the person to work in CA for two years.Informatica PowerCenter v9+Developer with 5+ years direct experienceFamiliarity with DB2, SQL Server DatabaseKnowledge of Big Data is a plusQualificationsMustsBA/BS in Computer Science or equivalent trainingBusiness ExperienceData Warehousing 3-5 yearsETL 3-5 yearsInformatica 3-5 yearsOracle/SQL 3-5 yearsAdditional Information** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.Note:-This is a Contract job opportunity for you.Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD & TN-Visa can apply.No OPT-EAD & H1B candidates, please.Please mention your Visa Status in your email or resume.** All your information will be kept confidential according to EEO guidelines.SummaryType: ContractFunction: Information TechnologyExperience level: AssociateIndustry: Information Technology And Services