Role: Software Consultant
Skills: ETL, UNIX, SQL, SAS, Hadoop, OCP, Spark, Scala, Hive, Shell Scripting and Informatica.
Key Responsibilities:
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.