• Data Warehousing concepts, Strong ETL Knowledge, Informatica PowerCenter installations /migrations /troubleshooting.
• Development & Testing of complex ETL logics, Cloud Data Integration in IICS, Administration in IICS, Installation of secure Agent in IICS, Informatica PowerCenter (Versions 9.x, 10.x), Informatica Administration, Talend Cloud Big data, HDFS, Understanding of Hadoop, Basics of Spark processing.
• Proficiency in Informatica PowerCenter 10.x or higher preferably in a Unix (Linux/AIX) environment with Oracle sources and targets.
• Must have experience in Oracle 19c or higher (SQL*Plus, PL/SQL)/Experience in Unix Shell Scripting (Linux/AIX)
• Experience Job scheduling tools like Control-M
• Good to have experience in Change Control Management tools & Visio
• Have experience on all stages of Software Development Life Cycle (SDLC)
• Able to do requirement gathering, impact analysis, ETL mapping, build, unit testing, support SIT/UAT/Production
• At least 3 years’ experience in Hadoop development
• Banking/finance domain experience will be an advantage.
• Integrate Multiple source system under Retail Banking to Data Lakes
• Bring the source system data into a standard format and loading into Hadoop.
• Reconciling the data provided and data load and generating reports of the data quality.
• Performing the Data quality on the data loaded into Data warehouse.
• Design and implement data models and databases for data storage in Data Lakes
• Achieved to work individually from Data Discovery to Production Implementation.
• Ontime deliver for Multiple projects in time within SLA.
• Monitor data loads and support the production incidents.
• Have experience using CI/ CD tools.
• Have Experience Implementing Project on DevOps.