ETL Developer (SAP BODS)

Indra Group; Philippines; Hybrid; PHP 400,000 - 700,000; Full time

Job summary

Indra Group is seeking a data analytics professional to document business data needs, gather requirements with stakeholders, and deliver technical specs for ETL and data integration projects. You will map source-to-target data, define transformation rules, and support reporting with BI tools in a hybrid setup.

You will work with diverse data sources (Oracle, SQL Server, MySQL) and leverage SQL for complex analysis, contributing to financial services data strategies and adherence to data

Qualifications

• Experience in ETL Development, Data Profiling and Data Analysis.
• Knowledge of data warehousing, data mapping and data profiling.
• Ability to write complex SQL queries to analyze data.
• Familiarity with Oracle, SQL Server and MySQL databases.
• Domain knowledge in Financial Services.
• Knowledge of reporting tools PowerBI and Tableau is a plus.

Responsibilities

• Document the Business Data needs. Work with Business stakeholders in identifying business requirements for analytics projects, products, and programs of work that maximize business impact / benefits within a realistic setting
• Experience in creating detailed technical documentation for data integration (ETL) programs and other deliverables.
• Experienced in ETL Development, Data Profiling and Data Analysis. Identify and map the data that are required from source to be loaded into target tables
• Define and document transformation requirements from Staging to the Final Reporting Table(s)
• Knowledge of data warehousing, including data mapping and transformations, data dependencies, data source analysis and profiling.
• Experienced in writing complex SQL queries to analyze data and provide results to business users or project team members.
• Visualize process changes in collaboration with business stakeholders and the IT user adoption team, to establish mutual understanding and accountability
• Understanding of the dependencies between components of data infrastructure
• Define standards and implement best practices for implementation of target data state
• Familiarity with different database technologies (Oracle, SQL Server, MySQL)
• Domain Knowledge Financial Services
• Knowledgeable in different reporting tools (PowerBI, Tableau) is a plus

Skills

ETL Development

Data Analysis

SQL

Data Profiling

Data Mapping

Tools

Oracle

SQL Server

MySQL

PowerBI

Tableau

Job description

Select how often (in days) to receive an alert:

Location:

Philippines, 00, PH

Profile: DATA

Required experience:

Working mode: Hybrid

Role: T I

• - Document the Business Data needs. Work with Business stakeholders in identifying business requirements for analytics projects, products, and programs of work that maximize business impact / benefits within a realistic setting
• - Experience in creating detailed technical documentation for data integration (ETL) programs and other deliverables.
• - Experienced in ETL Development, Data Profiling and Data Analysis. Identify and map the data that are required from source to be loaded into target tables
• - Define and document transformation requirements from Staging to the Final Reporting Table(s)
• - Knowledge of data warehousing, including data mapping and transformations, data dependencies, data source analysis and profiling.
• - Experienced in writing complex SQL queries to analyze data and provide results to business users or project team members.
• - Visualize process changes in collaboration with business stakeholders and the IT user adoption team, to establish mutual understanding and accountability
• - Understanding of the dependencies between components of data infrastructure
• - Define standards and implement best practices for implementation of target data state
• - Familiarity with different database technologies (Oracle, SQL Server, MySQL)
• - Domain Knowledge Financial Services
• - Knowledgeable in different reporting tools (PowerBI, Tableau) is a plus