Consultant - Bi

We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on our career website.

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.

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.

What's in it for you?

Pathways for career development

• Work with colleagues and clients around the world on interesting and challenging work.
• We provide internal career opportunities, so you can take your career further within TMF.
• Continuous development is supported through global learning opportunities from the TMF Business Academy.

Making an impact

• You’ll be helping us to make the world a simpler place to do business for our clients.
• Through our corporate social responsibility program, you’ll also be making a difference in the communities where we work.

A supportive environment

• Strong feedback culture to help build an engaging workplace.
• Our inclusive work environment allows you to work from our offices around the world, as well as from home, helping you find the right work-life balance to perform at your best.

Other Benefits

• Marriage Gift policy
• Paternity & Adoption leaves
• Interest free loan policy
• Salary advance policy
• Well-being initiatives