What are the responsibilities and job description for the Sr. Database Developer position at Global Channel Management?
Sr. Database Developer needs 8 years of professional experience with SQL / PLSQL
Sr. Database Developer requires :
- 8 years of professional experience with SQL / PLSQL
- 6 years Informatica or other ETL tool
- Understand Data Federations, Data Lake, Data Mesh and Advance Cloud concepts.
- Experience automating ETL with job scheduling tools. Autosys Preferred
- Experience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plus
- Sr. Database Developer duties :
- Translate business requirements into technical specifications.
- Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.
- Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams
- Collaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.
- Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle / MS SQL server.
- Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )
