Description

Manage relational database design, administration, and data consistency across multiple platforms.

Responsibilities

• Design and administer relational databases using SQL and object-oriented programming principles.
• Develop stored procedures, views, triggers, and indexes to ensure efficient data manipulation.
• Perform data profiling using Informatica Developer and Analyst tools to inform ETL designs.
• Configure Informatica BDM by integrating with Kerberos-enabled HDP.
• Conduct feasibility studies and travel to various locations for system setups.

Required Skills

• 5+ years of experience in database administration and design.
• Proficiency in SQL Server and Oracle.
• Experience with Teradata and Hive.
• Hands-on work with ETL Designs and PowerCenter.
• Experience developing with SSIS and SSRS.
• Knowledge of DDL/DML and data modeling.
• Ability to use Informatica IDQ/BDQ for source data profiling.
• Familiarity with EDC for loading data assets into repositories.

Key Skills

Education

Any Graduate