Ab Initio Developer

Required Experience:

• Total of 7+ Years of IT Experience predominantly in Data Integration/ Data Warehouse area
• Must have at least 3 years of ETL Design and Development experience using Ab Initio 1-2 years of Data Integration
• Conduct analysis of the Ab-Initio code and other interdependent code, track code changes and versions using Enterprise Metadata repository (EME).
• Modify Ab-Initio code following project guidelines and standards
• Analyze existing wrappers and create new wrapper scripts using Unix to call the required Ab-Initio code from the Unix/Linux based systems.
• Responsible for performance tuning of the existing/new Ab-Initio code using Ab-Initio standard practices in order to get optimized performance in the cloud environment.
• Project experience on Hadoop Platform, preferably Cloudera At least one project implementation of Ab-Initio CDC ( Change Data Capture ) in a Data Integration/ETL project Working knowledge of HDFS, Hive, Impala and other related Hadoop technologies
• Sound understanding of SQL and ability to write well performing SQL queries
• Good knowledge of OLTP and OLAP data models and other data warehouse fundamentals
• Rigor in high code quality, automated testing, and other engineering best practices, ability to write reusable code components
• Ability to unit test the code thoroughly and to troubleshoot issues in production environments
• Must have some working experience with Unix/Linux shell scripting
• Must be able to work independently and support other junior developers as needed
• Some Java development experience is nice to have
• Knowledge of Agile Development practices is required