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 )