Note: The job is a remote job and is open to candidates in USA. Mannara Technologies Pvt. Ltd. is seeking a Senior SQL and Power BI Developer responsible for leading complex IT applications design and development. The role involves optimizing database performance, developing Power BI dashboards, and providing technical leadership while ensuring data integrity and effective data management.

Responsibilities

• A Senior Programmer is responsible for leading and/or working on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software
• This classification may also plan, install, configure, test, implement and manage a systems environment in support of an organization’s IT architecture and business needs
• The Senior Programmer will possess knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software
• Operating systems installation and configuration procedures; organization’s operational environment; software design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components; pertinent government regulations; infrastructure requirements, such as bandwidth and server sizing; database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing; functionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability; optimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the work; and speak and write effectively and prepare effective reports
• Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and a keen ability for fine-tuning database performance
• Demonstrate expertise in working with diverse and popular database management systems such as Oracle, MySQL, SQL Server, and Azure SQL
• Exhibit a strong understanding and extensive experience in Oracle PL/SQL programming
• Showcase the ability to design efficient data models that facilitate optimal storage and retrieval of information
• Demonstrate a comprehensive understanding of Extract, Transform, Load (ETL) processes and tools and scripting languages like Python, Perl, or Shell scripting for automating and data manipulation
• Exhibit a strong ability to optimize both database queries and underlying structures
• Possess knowledge of data warehousing concepts and tools, enabling effective management of vast volumes of data
• Display proficiency with Power BI, including crafting insightful visualizations and reports that translate raw data into valuable, actionable insights
• Demonstrate proficiency in utilizing version control systems like Git to effectively manage and track changes in database scripts and queries

Skills

• A minimum of seven (7) years of experience in electronic data processing systems study, design, and programming
• At least four (4) years of that experience must have been in a lead capacity
• This classification requires the possession of a bachelor's degree in an IT-related or Engineering field
• Additional qualifying experience may be substituted for the required education on a year-for-year basis
• Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and a keen ability for fine-tuning database performance
• Demonstrate expertise in working with diverse and popular database management systems such as Oracle, MySQL, SQL Server, and Azure SQL
• Exhibit a strong understanding and extensive experience in Oracle PL/SQL programming
• Showcase the ability to design efficient data models that facilitate optimal storage and retrieval of information
• Demonstrate a comprehensive understanding of Extract, Transform, Load (ETL) processes and tools and scripting languages like Python, Perl, or Shell scripting
• Exhibit a strong ability to optimize both database queries and underlying structures
• Possess knowledge of data warehousing concepts and tools
• Display proficiency with Power BI, including crafting insightful visualizations and reports
• Demonstrate proficiency in utilizing version control systems like Git

Company Overview

• * A leading Enterprise Data Management, Business Intelligence company in India with dedicated and talented workforce of around 60+
• 100% Software Export Oriented Company (EOU) registered with Software Technology Park of India (STPI) (Mumbai) & SEZ unit (Pune). It was founded in 1992, and is headquartered in Pune, Maharashtra, IN, with a work