5-8 years as database and ETL developer
Must have:
Experience on Informatica Intelligent Cloud Services (IICS)
- Data Integration
- Application Integration
- Experience on Amazon Redshift
- Data model design and development
- Development of advanced SQL queries include analytical function
- Database and SQL performance tuning
- Experience in building and/or supporting Data Warehouses/Data Marts
- Experience in implementing various SCDs using Informatica
- Knowledge/experience on other relational data models and databases (like Oracle, PostgreSQL etc.)
- String analytical and problem-solving skills
- Ability to prepare unit test cases and perform unit testing
- Configuration and deployment of IICS components & Redshift objects in different environments
- Experience in using source control systems like GitHub, SVN etc.
- Ability to participate in scrums and communicate with various stakeholders
- Experience or strong understanding on agile process
- Knowledge/experience on Web Services and REST APIs
Ability to debug and resolve issues related to IICS & Redshift in different environments