At least 3 years of experience developing ETL processes.
- Strong in Informatica design concepts using its products.
- Hands-on knowledge of Mapplets, Mappings, Workflows, and Applications.
- Proficient in Creating Mappings, workflows and implementing ETL concepts.
- Solid data warehousing concepts - dimensional modelling, facts, dimensions, helper tables, SCD concepts etc.
- Strong ETL and data modelling experience.
- Experience in development of database processes using Oracle SQL, Hive, MapReduce.
- Sound Unix shell scripting and command level experience.
- Knowledge of Hadoop, Map Reduce, Hive, Spark is an advantage.
- Excellent knowledge of debugging, tuning and optimising the performance of database queries.
- Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications.
- Experience in Netezza
- Actively participate in business requirements sessions, design review and test case review meetings.
Basic understanding of any programming language. As developer, should worked on change requests or enhancements by making some code changes. .:
Good to have Understanding of SAS programming language.