Position Type: Full-Time


Job Responsibilities:


  • Design and create the data warehouse and all related extraction transformation and load of data functions

  • Understand ETL specifications and build the ETL applications like Mappings

  • Create mappings, sessions, and Workflows as per requirement of business to implement the logic

  • Perform code walk-through and debugging program code

  • Perform Unit Testing on developed code/jobs

  • Understand and perform Data Analysis, requirement gathering and Design and Development of code

  • Create a mapping document based on High-level design document 

  • Tuning and optimization of new and existing data structures, leveraging advanced indexing, in memory tables, and selective materialization and denormalization techniques. 

  • Identifying use cases that would benefit with NOSQL or caching technologies, collaborate with engineering team on design and implementation 

  • Assist with development and tuning of SQL stored procedures and functions. 

  • Monitoring of database performance, continuous tuning, and refinement 

  • Design and document standards and best practices 




  • Master’s Degree in Business Analytics, Mathematics, Statistics,  etc.

  • 0-1 years of practical experience with Microsoft SQL Server

  • Acknowledge of Data warehouse and ETL as well as SQL.

  • Creative, flexible, and quick to learn

  • Excellent communication and analytical skills

  • Ability to work in team environment and client interfacing skills.

Work Authorization Status:

BeaconFire Solution is an equal opportunity employer.