ETL Developer

Bengaluru, Karnataka, India

Job Type

Full Time

About the Role

RESPONSIBILITIES:

• Partners with ETL developers/Tableau developers/Architect through the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develops error handling processes and testing dashboards in the Tableau environment

• Perform data analysis, build strong and effective SQL queries to validate data and KPI calculation in UAT and PROD

• Interact with customers to understand their business problems and provide best-in-class analytics support.

• Defining and documenting technical test-cases in a structured way to be easily reproduced and executed along the application lifecycle.

• The testers ensures the data being used is representing the real use cases, and ensures that data items end-to-end are representing the business information according to the source systems and further transformations implemented.

• QA Performance Analyst will support the development team to fix all detected errors

• QA Performance Analyst will support data owners in the final KPI & Dashboard/Reports testing and error fixing.

• Demonstrate strength in data modelling, ETL development, data analysis and data warehousing

• Proficient in complex SQL and Query performance tuning skills

• Ability to work on multiple tracks and status reporting
•

Work with team to ensure standards and patterns are followed.

• Evaluates existing applications that could address client requirements and makes recommendations from complex projects.

• Identifies alternative uses of technologies that will enhance current or anticipated information systems and that support overall corporate and business goals that are appropriately aligned with the enterprise architecture.

• Assists in the testing and development of ETL & Tableau related Service Level Agreements.

• Communicates risks and ensures understanding of these risks.

Requirements

RESPONSIBILITIES:

• Partners with ETL developers/Tableau developers/Architect through the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develops error handling processes and testing dashboards in the Tableau environment

• Perform data analysis, build strong and effective SQL queries to validate data and KPI calculation in UAT and PROD

• Interact with customers to understand their business problems and provide best-in-class analytics support.

• Defining and documenting technical test-cases in a structured way to be easily reproduced and executed along the application lifecycle.

• The testers ensures the data being used is representing the real use cases, and ensures that data items end-to-end are representing the business information according to the source systems and further transformations implemented.

• QA Performance Analyst will support the development team to fix all detected errors

• QA Performance Analyst will support data owners in the final KPI & Dashboard/Reports testing and error fixing.

• Demonstrate strength in data modelling, ETL development, data analysis and data warehousing

• Proficient in complex SQL and Query performance tuning skills

• Ability to work on multiple tracks and status reporting
•

Work with team to ensure standards and patterns are followed.

• Evaluates existing applications that could address client requirements and makes recommendations from complex projects.

• Identifies alternative uses of technologies that will enhance current or anticipated information systems and that support overall corporate and business goals that are appropriately aligned with the enterprise architecture.

• Assists in the testing and development of ETL & Tableau related Service Level Agreements.

• Communicates risks and ensures understanding of these risks.

About the Company

Cigres Technologies Private Limited is a technology consulting and services company that focuses on helping clients resolve their significant digital problems and enabling radical digital transformation using multiple technologies on premise or in the cloud. The company was founded with the goal of leveraging cutting-edge technology to deliver innovative solutions to clients across various industries.