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 )