Data Warehouse Etl Expert for ERP Data Integration

2 months ago

Bengaluru Karnataka, India Upwork Full time

**Company Description**
Our client is a top-tier enterprise client in the commercial doors and electronic access control arena.

They are seeking a skilled Data Warehouse ETL Expert for a one-off, part-time project.
- Load data into the SQL Data Warehouse from Sedona Office and Connectwise MSP Software, ensuring the integrity and accuracy of the data.
- Maintain the existing structure of the SQL Data Warehouse while integrating new data.
- Perform data mapping from source systems to target tables within the data warehouse, such as FactRevenue.
- Utilize SQL queries and API calls to identify and extract the correct data sources from ERP systems.
- Create detailed mapping instructions, including queries and API call instructions, that align with existing data warehouse structures.
- Quality assures the results from end-to-end, extending to Power BI datasets, and provides remediation instructions or explains limitations to the Financial Planning and Analysis (FPA) team.
- Collaborate with ETL developers and the FPA team for guidance and validation of data integration processes

**Qualifications**

**Requirements**:

- Proven experience in SQL, data warehouse, data analysis, ETL processes, and working with ERP systems.
- Specific experience with Sedona Office and/or Connectwise ERP systems data structure and available APIs.
- Strong T-SQL, SSIS, and ETL development skills.
- Capability to work with API integration and ability to call/test APIs with tools like Postman.
- Ability to query databases directly and via API calls.
- Familiarity with business process concepts and data transformation techniques.
- Strong problem-solving skills and attention to detail.
- Availability to consult with the ETL team for 3-4 hours a day and respond to the FPA team during normal Eastern US business hours.
- Willingness to engage with offshore teams during specified overlap hours.
- Excellent communication skills and ability to participate in scenario-based interviews.

**Nice to have**:

- Comfortable asking pointed questions to understand business processes and systems.
- Able to explain their work clearly and participate in unscheduled walkthroughs of their deliverables at short notice.

**Additional Information**
Remote Opportunity

Work in Eastern US Business Hours

  • Data Warehouse Expert

    2 weeks ago

    Bengaluru, Karnataka, India PradeepIT Consulting Services Full time

    **About the job Data Warehouse Expert**: Timing: 12 PM to 8PM Rounds of Interviews: 3 to 4 **_ Position Overview:_** As a Senior Data Warehouse Expert, you will play a critical role in the development and implementation of an Operational Data Warehouse (OEDW) system for our client. This initiative aims to create a Single Source of Truth (SSOT) for their...

  • ETL Developer

    2 months ago

    Bengaluru, India CONGRUENCE HR PRIVATE LIMITED Full time

    Mandatory Skills:- Rest API, ETL, JSON, Data Integration, Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data...

  • ETL Developer

    3 weeks ago

    Bengaluru, India CONGRUENCE HR PRIVATE LIMITED Full time

    Mandatory Skills:- Rest API, ETL, JSON, Data Integration, Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data...

  • ETL Developer

    2 months ago

    Bengaluru, India Trothandally Full time

    Roles & Responsibilities :- Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data integration and exchange...

  • ETL Developer

    3 weeks ago

    Bengaluru, India Trothandally Full time

    Roles & Responsibilities :- Design, develop, and implement ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.- Collaborate with cross-functional teams to understand data integration requirements and implement solutions that meet business needs.- Utilize Rest API for data integration and exchange...

  • System Integration Advisor

    3 weeks ago

    Bengaluru, India NTT DATA Full time

    Job DescriptionETL TesterReq. Experience: 7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical...

  • Data Warehouse

    4 weeks ago

    Bengaluru, India EVRY India Full time

    **Data Warehouse & ETL Azure with ADF****: - Location Karnataka Bangalore - Experience Range 8 - 10 Years - Open - Skills_ - _ - Microsoft cloud-based tools such as Azure Data Factory (ADF), Azure Synapse, Azure Databricks, Azure Blob Storage, ADLS, Azure Key Vault ;_ Job Description - About Us - EVRY India and EVRY USA are wholly owned subsidiaries of...

  • Data Warehouse

    3 hours ago

    Bengaluru, India EVRY India Full time

    **Data Warehouse & ETL Azure with ADF****: - Location Karnataka Bangalore - Experience Range 8 - 10 Years - Open - Skills_ - _ - Microsoft cloud-based tools such as Azure Data Factory (ADF), Azure Synapse, Azure Databricks, Azure Blob Storage, ADLS, Azure Key Vault ;_ Job Description - About Us - EVRY India and EVRY USA are wholly owned subsidiaries of...

  • ETL Tester

    2 months ago

    Bengaluru, India Cortex Consulting Pvt. Ltd. Full time

    Job Description :We are looking for a detail-oriented and quality-focused ETL Tester to join our team and ensure the accuracy and integrity of our data warehouse!About the Role :In this role, you will be responsible for designing and executing test plans to verify the functionality and performance of our Extract, Transform, Load (ETL) processes. You will...

  • ETL Tester

    3 weeks ago

    Bengaluru, India Cortex Consulting Pvt. Ltd. Full time

    Job Description :We are looking for a detail-oriented and quality-focused ETL Tester to join our team and ensure the accuracy and integrity of our data warehouse!About the Role :In this role, you will be responsible for designing and executing test plans to verify the functionality and performance of our Extract, Transform, Load (ETL) processes. You will...

  • System Integration Advisor

    4 days ago

    Bengaluru, Karnataka, India NTT DATA Full time

    Job DescriptionETL TesterReqExperience:7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical...

  • Data Warehouse Architect

    2 months ago

    Bengaluru, India ACS Solutions Full time

    ResponsibilitiesCreating the future data architecture/platform and generating data management artifacts, including data models, dictionaries, catalogs, and flows; ETL source-to-target mappings; and testing use cases.Enforcing data management best practices, standards, policies, and rules across different functional areas.Developing conceptual, logical, and...

  • System Integration Advisor

    4 weeks ago

    Bengaluru, India NTT DATA Full time

    Job Description ETL TesterReq. Experience: 7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical...

  • System Integration Advisor

    4 days ago

    Bengaluru, Karnataka, India NTT DATA Full time

    Job Description ETL TesterReq. Experience: 7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical...

  • System Integration Advisor

    4 days ago

    Bengaluru, Karnataka, India NTT DATA Full time

    Job Description ETL Tester Req. Experience: 7+ Years Proficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server. Previous experience of testing large scale BI solutions integrating with multiple source and target systems. Understand the mappings of source systems to data models in the target data warehouse schema and...

  • System Integration Advisor

    3 weeks ago

    Bengaluru, India NTT DATA Full time

    Job Description ETL TesterReq. Experience: 7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical...

  • Etl and Data Warehouse Testing Intern

    2 weeks ago

    Bengaluru, India Junglee Games Full time

    **Responsibilities**: - Work collaboratively with the ETL testing team to develop and execute test cases for data integration processes and data warehouse - Assist in designing, developing, and maintaining automated testing scripts using SQL and Python for data warehouse testing - Analyze test results to identify defects, issues, and risks related to data...

  • System integration senior specialist

    4 days ago

    Bengaluru, Karnataka, India NTT DATA Full time

    Job DescriptionETL TesterReqExperience:7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical...

  • System integration senior specialist

    3 weeks ago

    Bangalore, Karnataka, India NTT DATA Services Full time

    ETL Tester   Req. Experience: 7+ Years   Proficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server. Previous experience of testing large scale BI solutions integrating with multiple source and target systems. Understand the mappings of source systems to data models in the target data warehouse schema...

  • Data Warehouse Architect

    2 months ago

    Bengaluru, India Info Origin Inc Full time

    We are seeking a highly skilled and experienced Data Warehouse Architect to join our team! In this pivotal role, you will play a key role in building and maintaining our data warehouse infrastructure, with a specific focus on integrating data from Workday. You will leverage your expertise in data warehousing, ETL development, and Workday technologies to...