ETL Developer

2 weeks ago


Thiruvananthapuram, Kerala, India CONNECTING 2 WORK Full time

Job Description

ETL Developer

Overview

The ETL Developer is responsible for the design, development, and implementation of Business Intelligence dashboards and reports using the MS BI stack/Tableau. The Senior ETL engineer will be responsible for supporting schema, reports, templates and dashboards implemented in the environments. As part of the role they will be responsible for implementing data dashboards to all levels of the organization. Works at direction of manager, team lead, or project manager to ensure that assignments align with business priorities.

Duties and Responsibilities

Design and deploy data table structures, forms, reports, and queries Query, analyze, and profile data from source to target to assess data integrity gaps are identified in order to meet the business requirements of the reports

Designs, develops, tests, and implements software programs, interfaces, reports and controls in accordance with best practices.

Modify and enhance existing reports and dashboards to meet ongoing operational needs.

Interpret data, analyze results using statistical techniques and provide ongoing reports

Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality Identify, analyze, and interpret trends or patterns in complex data sets

Manage the data model, data architecture, design & development for availability, upgrades, maintenance, performance and security of the Database infrastructure

Work collaboratively with business unit partners to assess reporting needs and solutions, and implement a strategy for continuous improvement of the historical reporting, analytics and dashboards

Analyze large customer data sets using a variety of database query and visualization tools.

Deploy analytic models within the various self-service reporting systems and environments

Develop, enhance and maintain large data sets processed through the MS BI stack. Design and develop complex ETL packages utilizing MS SSIS.

Design and develop complex MS SSRS reports/Tableau Architect new and enhance existing data models to meet business and technical requirements.

Create and maintain stored procedures.

Design and develop MS SSAS cubes.

Assist with performance tuning especially related to SSIS and SSRS run times.

Identify inefficiencies in current databases and investigate solutions.

Functions as technical architect and Subject Matter Expert (SME) on enterprise related Database systems Development and maintenance of the database stored procedures, views and functions for applications.

Creation and maintenance of technical documentation.

Development and maintenance of Data Warehouse.

Designs or modifies procedures to solve complex problems considering Database availability, capacity, operating schedules, and business results.

Developing architectural and logical design documentation and periodically reviewing completeness or response to audit or business requirement changes.

Build and integrate reporting system (Tableau) for ad-hoc queries and business dashboards SSIS Data Flow Error

Handling Shall understand and abide by the organizations' information security policy and protect the confidentiality, integrity and availability of all information assets.

Shall report incidents related to security of information to concerned authorities.

Troubleshooting Stays current with the Database BI and ETL technology advances to enable production support and incident resolution that meets service level agreements.

Interfaces with IT disciplines, vendors and professional services providers to ensure service level achievement.

Requirements Engineering/Science graduate with 2 to 4 years' experience as ETL/SQL developer

Expert knowledge of: MSSQL, NoSQL Server.

Experience extracting and manipulating data from relational databases with advanced SQL stored procedures. Experience working in any of the enterprise class BI, ETL and Reporting tools like SQL Server Reporting Services (SSRS)/Tableau/Power BI/SAS BI/ SQL Server Integration Services (SSIS)/ Informatica /Pentaho, etc.

Experience extracting and manipulating data from relational databases with advanced SQL, stored procedures.

Experience in coding advanced SQL queries, ETL automation, and stored procedures to support business inquiries Good Experience in Tableau Projects.

Requirement gathering, data modeling scripting, developing and testing dashboards using Tableau Experience with system development lifecycle methodologies, deliverables and controls

Excellent verbal and written communication skills

Monitoring and problem resolution of production incidents

Must have experience working in an MNC with diverse and geographically dispersed team.

Experience and knowledge of service oriented architecture preferred.

Microsoft Database certifications Other Skills/Abilities Strong analytical, trouble shooting/problem solving, and time management skills Ability to self-direct, prioritize, and manage multiple tasks and demands

Apply here



  • Thiruvananthapuram, Kerala, India Guidehouse Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Family:Software Application & Development (India)Travel Required:NoneClearance Required:NoneWhat you will do Design, develop, and optimize ETL workflows using Pentaho Data Integration (PDI/Kettle) to extract, transform, and load data from various sources into target databases and data warehouses.Collaborate with business analysts and other team members...

  • Senior ETL Specialist

    2 weeks ago


    Thiruvananthapuram, Kerala, India beBeeETL Full time ₹ 20,00,000 - ₹ 25,00,000

    As a seasoned ETL expert, you will play a pivotal role in ensuring the accuracy and reliability of our data pipelines.The ideal candidate will possess a strong background in database engineering, with expertise in writing complex SQL queries and performing data profiling.You will be responsible for validating the extraction, transformation, and loading...

  • ETL Tester

    2 weeks ago


    Thiruvananthapuram, Kerala, India Zafin Full time

    We are looking for a QA Engineer with experience in ETL testing, Kafka/Redpanda, and MongoDB. The role involves testing large-scale data pipelines, ensuring data accuracy, consistency, and throughput in event-driven systems. Major Responsibilities: Test ETL processes and perform data reconciliation across systems. Validate Kafka/Redpanda pipelines...


  • Thiruvananthapuram, Kerala, India Zafin Full time

    We are looking for a QA Engineer with experience in ETL testing, Kafka/Redpanda, and MongoDB. The role involves testing large-scale data pipelines, ensuring data accuracy, consistency, and throughput in event-driven systems.Major Responsibilities:- Test ETL processes and perform data reconciliation across systems.- Validate Kafka/Redpanda pipelines...

  • SAS Developer

    3 weeks ago


    Thiruvananthapuram, Kerala, India Claidroid Full time

    LinkedIn Job Post – Claidroid Technologies We're Hiring – SAS Developer Claidroid Technologies is looking for a proficient SAS Developer with 3–5 years of experience to join our Data Development & Engineering (DDE) team. This is an exciting opportunity to work in a fast-paced, agile environment where digital, data, and the customer are at the heart...

  • Lead I

    3 weeks ago


    Thiruvananthapuram, Kerala, India UST Full time

    Role Proficiency JD for SAP BODS Data Engineer Strong proficiency in designing developing and implementing robust ETL solutions using SAP Business Objects Data Services BODS with strong EDW experience Strong proficiency in SAP BODS development including job design data flow creation scripting and debugging Design and develop ETL processes using...


  • Thiruvananthapuram, Kerala, India beBeeDeveloper Full time ₹ 12,00,000 - ₹ 18,00,000

    Job Opportunity: ETL DeveloperWe are seeking a highly skilled and experienced ETL Developer to join our team.The ideal candidate will have a strong background in designing, developing, and implementing Business Intelligence dashboards and reports using the MS BI stack/Tableau. The role will involve querying, analyzing, and profiling data from source to...

  • Lead I

    3 weeks ago


    Thiruvananthapuram, Kerala, India UST Full time

    Job Summary We are seeking a highly skilled SAP BODS Data Engineer with strong expertise in ETL development and Enterprise Data Warehousing EDW The ideal candidate will have a deep understanding of SAP Business Objects Data Services BODS and will be responsible for designing developing and maintaining robust data integration solutions Key...


  • Thiruvananthapuram, Kerala, India beBeeDataIntegration Full time ₹ 10,00,000 - ₹ 12,00,000

    Job Description:We are seeking a highly skilled Data Integration Specialist to design, develop, and maintain ETL processes. The ideal candidate will be responsible for creating efficient data pipelines and ensuring accurate data transformation.Design and implement data integration solutions using SSIS (SQL Server Integration Services).Utilize T-SQL to write...


  • Thiruvananthapuram, Kerala, India beBeeDataExpert Full time ₹ 15,00,000 - ₹ 28,00,000

    Snowflake Data Warehouse ExpertDevelop high-performance data warehouses on the Snowflake cloud platform, ensuring scalability and efficiency. Utilize advanced features for seamless data storage and processing.Design and implement optimized data warehouse solutions.Collaborate with cross-functional teams to meet business requirements.Data Pipeline...