Key Responsibilities:
- Responsible for developing Unix scripting. Must be able to work independently with minimum supervision.
- Responsible to develop test cases and perform unit testing.
- Must be able to interact and co-ordinate with distributed team. Must have good communication skills.
- PL/SQL/ETL Informatica Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter. Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs.
Key Requirements and Technology Experience:
- Skills-PL/SQL, ETL, Informatica
- Expert in PL/SQL programming and Database design, with strong data analysis skills.
- Responsible to provide regular task status update to the management. Technically strong in Informatica Power center.
- Technically strong in performance tuning of targets, sources, mappings and SQL queries.
- Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views. Strong in UNIX commands and Scripting.
- Self-managed and proactive communicator, Unix scripts, Autosys
- Previous experience of working in a data warehouse project is a plus
- Python programming
- Tableau/reporting experience