Lead Software Engineer - Freehold, United States - Hummingbirds Innovations

Description

JOB DUTIES:
Position will be responsible specific to

• Designing database tables and structures.
• Creating views, functions, triggers, stored procedures and packages.
• Research complex Oracle programs and address data issues.
• Provide batch application support.
• Build new ETL workflow in Teradata and unix.
• Work with the onshore and offshore team in application design and build using the technologies defined in the must have skills.
• Communicate status of the activities effectively with management or clients

Requirements

• Minimum 8 years of experience with Oracle, PL SQ
• Proficient in understanding and create complex SQL queries (ORACLE/Teradata)
• Knowledge of version control practices and procedures (GITLAB)
• Highly proficient in Oracle PL SQL developer activities and multi task to work in other technologies (Teradata/MS SQL Server)
• Experience in Unix shell scripting
• Worked in Agile mode with teams from different locations

Additional Skills good to have but not mandatory:

Experience in additional databases like MS SQL server, Teradata Experience with Teradata utilities (BTEQ, MLOAD, FLOAD, FAST EXPORT)

Exposer to any reporting tool set like Qlik or Tableau