ETL Developer

1 month ago

thiruvananthapuram, 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

  • Data Engineer

    4 weeks ago

    Thiruvananthapuram, India ProPMO Services Private Limited Full time

    Job Description :We have a requirement for 3 Data Engineers who could join us on a short notice.3 to 8 years of professional software development/engineering experience.Specialist experience working in Python coding as a Data Engineer. Must have good experience working with databases PostgreSQL/MySQL/MS SQL.Must have good experience working in AWS/GCP...

  • ETL Developer

    1 month ago

    Mumbai,Chennai,Pune,Gurgaon,Gurugram,Noida,Ahmedabad,Trivandrum,Thiruvananthapuram, India VY Systems Pvt Ltd. Full time

    Job Description : - 7-10 years of IT experience in Data Architecture, Data Warehouse, Business Intelligence, ETL, OLAP Cubes, Data Analysis, Design, Development, Implementation, Testing and troubleshooting of DW, strong emphasis on user requirements gathering, business rules and data analysis.- 7-10 years of technical hands-on experience in development of...

  • ETL Developer

    3 weeks ago

    Mumbai/Chennai/Pune/Gurgaon/Gurugram/Noida/Ahmedabad/Trivandrum/Thiruvananthapuram, IN VY Systems Pvt Ltd. Full time

    Job Description :- 7-10 years of IT experience in Data Architecture, Data Warehouse, Business Intelligence, ETL, OLAP Cubes, Data Analysis, Design, Development, Implementation, Testing and troubleshooting of DW, strong emphasis on user requirements gathering, business rules and data analysis.- 7-10 years of technical hands-on experience in development of...

  • Senior Data Engineer

    4 weeks ago

    Thiruvananthapuram, India Nissan Motor Full time

    Quality & After Sales team is integral part to Nissan’s manufacturing process. While targeting high quality in our vehicles, we work to increase the quality of its sales and service to customers in the purchasing process. The goal is to exceed customer expectations at all contact points. We are looking for Hands-On lead data engineer to build next...

  • Senior Data Engineer

    1 month ago

    thiruvananthapuram, India Nissan Motor Full time

    Quality & After Sales team is integral part to Nissan’s manufacturing process. While targeting high quality in our vehicles, we work to increase the quality of its sales and service to customers in the purchasing process. The goal is to exceed customer expectations at all contact points. We are looking for Hands-On lead data engineer to build next...

  • Senior Data Engineer

    4 weeks ago

    Thiruvananthapuram, India Nissan Motor Full time

    Description : We are looking for passionate senior ETL engineers, with Talend experience, who can assist in the process of maintaining all the relevant sources of data and ensuring that it is being stored properly. He/she is involved in developing the ETL processes and is involved in designing and preparing the codes that meet the program...

  • Senior Data Engineer

    1 month ago

    thiruvananthapuram, India Nissan Motor Full time

    Description : We are looking for passionate senior ETL engineers, with Talend experience, who can assist in the process of maintaining all the relevant sources of data and ensuring that it is being stored properly. He/she is involved in developing the ETL processes and is involved in designing and preparing the codes that meet the program...

  • Architect - Data Fusion

    4 weeks ago

    Thiruvananthapuram, India QBurst Full time

    **Description**: QBurst is hiring a Data Architect with expertise in Data Fusion to help build extensive big data pipelines. As a Data Architect at QBurst, you will be responsible for developing, constructing, testing, and maintaining architectures used for large-scale data processing. **Responsibilities**: - Act as the technical leader for the 8-10 member...

  • Senior Data Engineer

    4 weeks ago

    Thiruvananthapuram, India Quantiphi Full time

    Role: Senior Data EngineerExperience Level: 4 to 7 YearsWork location: Trivandrum (Hybrid Only)Required Skills:● Bachelor’s degree in Computer Science or similar field or equivalent work experience.● 3+ years of experience on Data Warehousing, Data Engineering or Data Integration projects.● Expert with data warehousing concepts, strategies, and...

  • Data Engineer

    1 month ago

    Trivandrum,Thiruvananthapuram,Cochin,Kochi,Anywhere in India,Multiple Locations ProPMO Services Private Limited Full time

    Job Description : We have a requirement for 3 Data Engineers who could join us on a short notice. 3 to 8 years of professional software development/engineering experience. Specialist experience working in Python coding as a Data Engineer. Must have good experience working with databases PostgreSQL/MySQL/MS SQL. Must have good experience working in AWS/GCP...

  • Data Engineer

    3 weeks ago

    Trivandrum/Thiruvananthapuram/Cochin/Kochi/Anywhere in India/Multiple Locations, IN ProPMO Services Private Limited Full time

    Job Description :We have a requirement for 3 Data Engineers who could join us on a short notice.3 to 8 years of professional software development/engineering experience.Specialist experience working in Python coding as a Data Engineer. Must have good experience working with databases PostgreSQL/MySQL/MS SQL.Must have good experience working in AWS/GCP...

  • Freelance Interviewer

    3 days ago

    Thiruvananthapuram, India Futuremug Full time

    Skills Required : Strong expertise in Fivetran, including: Connectors: Configuring and managing Fivetran connectors to efficiently extract data from various sources. Transformations: Developing data transformations using SQL to cleanse, manipulate, and enrich data for analysis. Configurations: Optimizing Fivetran pipelines for performance and reliability. ...

  • Freelance Interviewer

    3 days ago

    Thiruvananthapuram, India Futuremug Full time

    Skills Required : Strong expertise in Fivetran, including:Connectors: Configuring and managing Fivetran connectors to efficiently extract data from various sources.Transformations: Developing data transformations using SQL to cleanse, manipulate, and enrich data for analysis.Configurations: Optimizing Fivetran pipelines for performance and...

  • Data Engineer

    2 weeks ago

    Delhi NCR/Chennai/Bangalore/Hyderabad/Noida/Pune/Trivandrum/Thiruvananthapuram/Cochin/Kochi, India Macropace technologies Full time

    Role : Data Engineer Job Description : We are seeking a highly skilled Data Engineer to join our team. The ideal candidate will have a strong foundation in SQL and Snowflake, with a passion for transforming and optimizing data pipelines. As a Data Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure...

  • Data Engineer

    3 weeks ago

    Delhi NCR/Chennai/Bangalore/Hyderabad/Noida/Pune/Trivandrum/Thiruvananthapuram/Cochin/Kochi, IN Macropace technologies Full time

    Role : Data Engineer Job Description : We are seeking a highly skilled Data Engineer to join our team. The ideal candidate will have a strong foundation in SQL and Snowflake, with a passion for transforming and optimizing data pipelines. As a Data Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure to...

  • QA Engineer

    4 days ago

    thiruvananthapuram, India Guidehouse Full time

    Job Family: Application Testing (India)Travel Required: NoneClearance Required: None What You Will Do: Write Test Cases for iteration tickets and discuss with developers on the TC . Test the application. Raise bugs and do regression and security testingWhat You Will Need: 3+ years of experience in Manual testingGood SQL knowledge and Testing Knowledge....

  • Data Integration Consultant

    4 weeks ago

    Thiruvananthapuram, India CloudQ IT Services Full time

    Job Description :- Proficiency in Python programming language 4+ years of experience in Python itself- Strong understanding and experience with APIs- Advanced SQL skills- Experience extracting data from SAP systems (ECC, S4HANA)- Expertise with SSIS - Ability to develop Python scripts to parse API responses.- Expertise with data loading processes into...

  • Bi-Lingual Project Manager

    3 weeks ago

    thiruvananthapuram, India Nissan Motor Full time

    Position : Role/Title: Project Lead (Bi-Lingual Japanese) Job Location : Trivandrum Nissan is a pioneer in Innovation and Technology. With a focus on Mobility, Operational Excellence, Value to our Customers and Electrification of vehicles, you can expect to be part of a very exciting journey here at Nissan. Nissan is going after a massive...

  • Bi-Lingual Project Manager

    4 weeks ago

    Thiruvananthapuram, India Nissan Motor Full time

    Position : Role/Title: Project Lead (Bi-Lingual Japanese) Job Location : Trivandrum Nissan is a pioneer in Innovation and Technology. With a focus on Mobility, Operational Excellence, Value to our Customers and Electrification of vehicles, you can expect to be part of a very exciting journey here at Nissan. Nissan is going after a massive Digital...

  • Tableau Developer

    2 weeks ago

    MP/Bhopal/Orrisa/Guwahati/Trivandrum/Thiruvananthapuram/Cuttack/Bhubaneshwar/Bangalore/Mysore/Karnat, India Aricent Full time

    Position : Tableau DeveloperJob description :- Design, develop, test, and maintain Tableau reports and dashboards based on user requirements. - Troubleshoot performance issues associated with Tableau reports and dashboards. - Develop Tableau data visualizations and dashboards using different levels of Tableau calculations, including level of detail...