Qualifications :
- 7 years of experience in SQL, analytical (STAR schema) data modeling and Informatica PowerCenter.
- 5 years hands on experience in Informatica PWC / IICS ETL development.
- 5 years of Oracle (or comparable database) experience with BI / DW deployments.
- Must have proven experience with STAR and SNOWFLAKE schema techniques.
- Good to know cloud like AWS Services.
- Proven track record as an ETL developer potentially to grow as an Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
- Strong analytical skills and enjoys solving complex technical problems.
- Knowledge on additional ETL tools (Qlik Replicate), End to End understanding of data from ingestion to transformation to consumption in Analytics will be great benefits.
Primary skillsets :
5 years hands on experience in Informatica PWC ETL development.7 years of experience in SQL, analytical (STAR schema) data modeling and Informatica PowerCenter.5 years of Redshift / Oracle (or comparable database) experience with BI / DW deployments.Secondary skillsets :
Good to know cloud like AWS Services.Must have proven experience with STAR and SNOWFLAKE schema techniques.Skills Required
IICS, Informatica Powercenter, Redshift, Etl Development, Aws