SQL & ETL Developer

  • Chennai
  • Nroot Labs

Role: SQL & ETL Developer

Job Location: Chennai

Educational Qualification: B.Tech/M.Tech/B.Com/B.Sc/MCA/ MS Degree

Work experience: 2-4 years


Job Description:

NRoot Labs is looking for SQL & ETL developers who will be responsible for building, implementing and supporting datawarehouse solutions (logical design, physical design, implementation, testing and deployment).


Responsibilities:

  • Design and implement databases, tables, and schemas to support business requirements.
  • Write SQL scripts, stored procedures, and functions to support application data requirements.
  • Develop and maintain SQL queries for data analysis, reporting, and data migration.
  • Collaborate with cross-functional teams to understand data needs and develop solutions.
  • Optimize database performance by monitoring queries and implementing indexes
  • Implement data integrity, security, and privacy standards.
  • Monitor database performance and provide technical support to resolve any issues that arise.
  • Perform data analysis to identify trends, patterns, and insights to support business decisions.
  • Participate in the design and implementation of data warehousing solutions.
  • Design and implement SSIS packages to support data integration and migration.
  • Extract, transform, and load data from various sources into a data warehouse using SSIS.
  • Develop and maintain complex data flow transformations using SSIS components.
  • Debug and resolve issues with SSIS packages to ensure data quality and accuracy.
  • Collaborate with cross-functional teams to understand data needs and develop solutions.
  • Monitor and maintain existing SSIS packages, making improvements and optimizations as needed.
  • Stay up-to-date with the latest SQL and SSIS development techniques and technologies.


Primary Skills:

  • 2+ years of experience in SSIS development, SQL programming, and database management.
  • Strong proficiency in SQL and experience with SQL Server.
  • Knowledge of data warehousing concepts and architecture.
  • Strong understanding of data structures, algorithms, and data modeling.
  • Experience with relational database management systems such as MySQL, SQL Server, and Oracle.
  • Excellent problem-solving and analytical skills.
  • Ability to work independently and in a team environment.
  • Good communication and interpersonal skills.