Job Summary:
The Analyst Engineer is a critical role responsible for designing, developing, and optimizing IT systems, databases, and data workflows. This position involves leveraging various programming languages, scripting, automation, database development, and ETL processes to ensure system efficiency and reliability.
Key Responsibilities:
• Database Development & Management
• Design, develop, and optimize database queries, stored procedures, and functions using SQL and PL/SQL.
• Perform database tuning, indexing, and optimization for improved performance.
• Support database maintenance, backup, and recovery processes.
• Scripting & Automation
• Develop and maintain UNIX Shell scripting, Perl, and Python scripts for process automation and system monitoring.
• Automate data extraction, transformation, and loading (ETL) processes for improved efficiency.
• Implement workflow automation to streamline operational tasks and reduce manual efforts.
• ETL Workflows & Data Processing
• Design, implement, and manage ETL workflows for seamless data integration across systems.
• Perform data extraction, transformation, and loading from various sources into databases.
• Ensure data accuracy, consistency, and performance optimization in ETL processes.
• Version Control & Documentation
• Utilize GIT for version control, managing code repositories and collaborative development.
• Maintain technical documentation, process workflows, and best practices using Confluence.
• Document database schemas, scripts, ETL workflows, and automation procedures.
• System Administration & ITIL Best Practices
• Monitor system performance, troubleshoot issues, and provide support for IT infrastructure.
• Follow ITIL best practices for incident, problem, and change management.
• Collaborate with IT teams to ensure compliance with security and governance policies.