• Drive the collection of new data and architect the ETL to load data into Salesforce(DALI) instance.
  • Create mappings in Informatica to complete the ingestion along with transformations required to fit them into the corresponding Salesforce objects.
  • Create mappings in Informatica to get the data from Salesforce to Redshift.
  • Support data analysts and product managers by turning business requirements into functional specifications and then executing delivery .
  • Tune the ETL to ensure that mappings can scale with the data volume.
Required Skills:
  • 5+ years' experience in dimensional data modeling, ETL development, and Data Warehousing
  • 2+ years' experience with BI/DW/ETL projects.
  • Knowledge of AWS product suite including S3, Redshift.
  • Good knowledge of ETL , Informatica. Experience in Informatica Cloud a must.
Preferred Skills:
  • Experience with Hadoop, Hive, Pig.
  • Experience writing software to automate manual workflows
Key Projects:
  • Team is taking data from PeopleSoft and moving it to Salesforce