ETL PL/SQL Developer
Duration: 12+ months
Location: Jersey City, NJ
Responsibilities:-
- Experience in administrative(upgrade/config related stuff) as well as development tasks with Informatica PowerCenter ( Optional )
- Experience in Installing, Upgrading, Configuring Informatica PowerCenter in Linux O/S platform ( Optional )
- Good Understanding of RDBMS/SQL concepts and experience in working with relational databases such as DB2.
- Good understanding of data modeling, data integration, and data warehousing concepts and terminology.
- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications and documentation.
- Works with DBAs and Data Architects to plan and implement repository/metadata migration strategy in the Data Warehouse.
- Good experience in development tasks with Informatica PowerCenter Workflow Designer/Manager.
- Good Understanding of RDBMS/SQL concepts and experience in working with relational databases such as DB2.
- Good understanding of data modeling, data integration, and data warehousing concepts and terminology.
- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications and documentation.
- Good experience in scripting shell, python etc. ( Optional)
- Production support / troubleshooting
- Small enhancements to the codebase and database
- Additional skill: like (AWS/Cloud/Java/Python/Qlik/.Net)
- Very strong experience in Oracle Pl/SQL Exp.