- 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.
- 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.
- Experience with Hadoop, Hive, Pig.
- Experience writing software to automate manual workflows
- Team is taking data from PeopleSoft and moving it to Salesforce