Consultant – Power BI – Jobs in Bangalore

Job Description

Company :TMF Group

About the job

About TMF Group

TMF Group is a leading global provider of high-value business services to clients operating and investing globally. We focus on providing specialized and business-critical financial and administrative services that enable our clients to operate their corporate structures, finance vehicles and investment funds in different geographical locations.

TMF India is a Great Place to Work, ISO & ISAE certified organization.

Pls note that this role is a contractual role for 1 year. Confirmation basis performance after contract.

Job Duties

  • Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements.
  • Develop enterprise level ETL processes that include process logging, data validation, and data integrity checks.
  • Automate processes using SQL agent jobs, Python and other tools
  • Ensure accuracy and integrity of data through the development of constraints and validation rules.
  • Manage SQL code in a source control system.
  • Establish and enforce SQL development coding standards and best practices. Lead/participate in SQL code reviews.
  • Stay current with database/reporting/Microsoft SQL Server tools and technologies and the direction of the general database industry as a whole.
  • Provide technical mentoring and coaching for junior and mid-level database developers and data quality analysts.
  • Additional duties as assigned.

Job Description

  • The Senior Database Developer leads the planning, design and implementation of complex data interfaces, transformations, and OLTP and OLAP databases. The individual has a strong technical background and substantial experience in managing and administering different databases like MSSQL, MYSQL, Redshift and PostgreSQL.
  • The individual should have a deep understanding of database architecture, performance, security, and integrity, data access and table maintenance, developing and administering ETL processes using different tools, SQL coding and performance tuning, and proactive monitoring and alerting.
  • The individual will also have experience utilizing and interpreting data models, developing reporting, data marts, analytic cubes, and visualization.

Education, Experience & Knowledge:

  • Education: BE/B.Tech/MCA/BCA
  • Experience/Knowledge: 2+ years in relevant area.
  • Advanced level at developing ETL processes and packages..
  • Good exposure to Python and various libraries
  • Advanced SQL development and tuning skills
  • Exposure to business intelligence tools will be added advantage.
  • Familiarity with RedShift
  • Knowledge of software development and user interface web applications
  • Familiarity working with .Net Framework, JavaScript, HTML and Oracle
  • An ability to understand front-end users’ requirements and a problem-solving attitude.

Interested candidates can reach at ankita.dwivedi@tmf-group.com

Location