Informatica

SQL- Developer with Data Analysis Experience

Data Quality

Data Governance

Data Modelling

SQL- Good

more of an integration-no development-max data analysis

Data Governance Platform

Will have to work on Oracle- SQL Server- AWS Redshift- Data Servers

Job Description

Responsibilities:

• Database design: Design and implement efficient database structures and schemas to support application functionality Code writing: Write and optimize complex SQL queries for data retrieval, manipulation, and reporting Database queries: Write SQL queries to extract and manipulate data Testing and troubleshooting: Test databases and identify and fix issues related to performance, security, or data integrity Software specifications: Research, design, document, and modify software specifications Business requirements: Analyze the company's data need and assist in data migration and transformation projects to support business needs
• Collaboration: Work across IT teams and with business users understand the business needs and translate it to implementation.
• Security processes: Develop security processes Best practices: Develop and maintain documentation for database schemas, procedures, and best practices
• Standards: Verify that all database programs adhere to the organization’s and performance standards.
• Database performance: Assess the effectiveness and performance of database systems and applications

Requirements and Skills:

• 5-7 years of experience working in Oracle and DB2 Databases.
• Proven work experience as a Database developer.
• In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring).
• SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.
• Knowledge of software development and Agile delivery methodology.
• Proficiency in working with specific database like DB2, Oracle & SQL server.
• Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases) Excellent analytical and organizational skills.
• Understanding the needs of front-end users and having a problem-solving mindset.
• Excellent verbal and written communication skills.