Data Warehouse Etl Expert for ERP Data Integration

6 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



  • Bengaluru, Karnataka, India ResourceTree Global Services Full time

    At ResourceTree Global Services, we are looking for a skilled Data Warehouse Architect to lead our ETL efforts. This role is ideal for a seasoned Software Engineer/Tech Lead with a strong background in data warehousing and business intelligence.About the RoleWe are offering a highly competitive salary of ₹25-35 lakhs per annum, depending on experience,...

  • Etl Tester

    4 months ago


    Bengaluru, Karnataka, India Ares data private limited Full time

    Job Title: ETL Testing Location: Chennai,Pune or Bangalore Experience: Minimum 6+ years of IT/Industry experience, 5+ years in Data Warehouse Job Description: Key Responsibilities: - Minimum of 5 years of Data warehouse experience and 6+ years IT/Industry experience - Strong hands-on experience in writing complex SQL queries - Strong hands-on experience...

  • Data Warehouse Expert

    7 months 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 Tester

    7 months ago


    Bengaluru, India NTT DATA Full time

    We are currently seeking a ETL Tester -Solicited to join our team in Bangalore, Karnātaka (IN-KA), India (IN). - ETL Testing, SQL, Data Warehouse, EDW Process experience. - Experience in TOSCA will be an advantage. The Tester isolates, reproduces, and tracks defects and verifies fixes. Develops test data and procedures for ensuring the software products...

  • Data Warehouse Expert

    4 weeks ago


    Bengaluru, Karnataka, India ThoughtFocus Full time

    Job DescriptionAt ThoughtFocus, we are seeking an experienced Data Warehouse Expert to join our team. As a key member of our team, you will be responsible for designing, implementing, and maintaining large-scale data warehouses.About the RoleWe are looking for a highly skilled professional with a strong background in MS SQL Server, database management, and...


  • Bengaluru, India NTT DATA Full time

    **Req ID**: 191234 We are currently seeking a Snaplogic Data Integration Architect to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Provide in-depth technical support, troubleshooting and diagnostic support for both individual integration pipelines and the overall Snap Logic ecosystem. - Be a hands-on architect as needed to drive detailed and...


  • Karnataka, India Fusion Plus Solutions Inc Full time

    Number of Openings- 1- ECMS Request no in sourcing stage- 399072- Duration of contract- 6- Total Yrs. of Experience- 5+- Relevant Yrs. of experience- 4+- Detailed JD (Roles and Responsibilities)- Should have strong ETL and Data Warehouse Testing knowledge - Should be aware of various data testing types performed for a data lake migration - Should have...

  • Data Scientists

    7 months ago


    Bengaluru, Karnataka, India NTT DATA Full time

    **Req ID**: 276519 We are currently seeking a Data Scientists to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Data Scientists Responsibilities - Programming Languages (Pyton, R), Data Manipulation and Analysis Tools, Machine Learning Libraries, Data Visualization tools, Cloud Platforms Programming Languages (Pyton, R), Data Manipulation and...

  • ERP Advisor

    2 months ago


    Bengaluru, Karnataka, India NTT DATA Full time

    **Req ID**: 292845 We are currently seeking a ERP Advisor to join our team in Bangalore, Karnātaka (IN-KA), India (IN). - The PowerApps Developer should be extremely proficient in Microsoft's Power Platform with an emphasis on PowerApps and integration within the M365 ecosystem and Microsoft Dataverse / Common Data Service. - Minimum 5-7 years of...

  • Data Warehouse Tester

    2 months ago


    Bengaluru, Karnataka, India Broadway Gaming Full time

    Broadway Gaming is a dynamic and expanding online gaming company operating mainly in the UK gaming market. We offer Bingo, Casino and Slot products across multiple brands. We have office locations in Dublin, London, Tel Aviv, Romania and India. With a wide variety of backgrounds comes a wealth of experience, ideas and personalities and we use these to help...


  • Bengaluru, Karnataka, India HEVO DATA Full time

    About the RoleWe're seeking a skilled Data Platform Solutions Expert to join our Sales team at HEVO DATA. This is an exciting opportunity for someone with a strong background in Data Domain to work closely with sales professionals, helping them understand customers' business and technical needs and demonstrate how our platform can solve their real-time data...


  • Bengaluru, Karnataka, India Wipro Full time

    At Wipro, we are seeking a highly skilled Data Warehouse Architect to join our team. This is an exciting opportunity to work with cutting-edge technology and contribute to the design and development of data warehouses that drive business growth.We estimate the salary for this role to be around $120,000 per year, based on industry standards and location.About...

  • Data Engineer

    1 month ago


    Bengaluru, India Coders Brain Technology Private Limited Full time

    We are looking for a talented Data Engineer with experience in ETL processes, database administration, and scripting, as well as expertise in tools such as Snowflake, Azure Data Factory, DBT, and Talend. The ideal candidate will have a strong technical background and be capable of working on various aspects of data engineering, from building data pipelines...


  • Bengaluru, India NTT DATA Full time

    **Req ID**: 182849 We are currently seeking a Business Intelligence Advisor to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Working with the Data Lead, Data Delivery and Infrastructure / DevOps functions, as the Talend Data SME/Lead you'll ensure that the Talend Data Platforms are delivered and optimised to meet the client's performance and...

  • Data Architect

    11 hours ago


    Bengaluru, India Bosch Group Full time

    Company Description Bosch Global Software Technologies Private Limited is a 100% owned subsidiary of Robert Bosch GmbH, one of the world's leading global supplier of technology and services, offering end-to-end Engineering, IT and Business Solutions. With over 20,000 associates, it’s the largest software development center of Bosch, outside Germany,...

  • Data & Analytics

    4 months ago


    Bengaluru, Karnataka, India NTT DATA Full time

    **Req ID**: 293686 We are currently seeking a Data & Analytics to join our team in Bangalore, Karnātaka (IN-KA), India (IN). As a Consultant/Sr. Consultant at NTT DATA Supply Chain Consulting, you join a team that helps craft supply chain strategies for the world's largest and most dynamic firms. You will work in small teams of analytical thinkers and...

  • QA - Data Warehouse

    7 months ago


    Bengaluru, India Crimson Panda Full time

    Crimson Panda are proud to be working with Broadway gaming to hire for a QA- Data Warehouse: As a QA- Data Warehouse, you will be responsible for ensuring the accuracy, reliability, and performance of our data warehouse and associated data pipelines. You will collaborate with cross-functional teams to design and execute comprehensive testing strategies,...


  • Bengaluru, India Calfus Inc. Full time

    About CalfusCalfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale.Our core focus lies in creating...


  • Bengaluru, Karnataka, India Hevo Data Full time

    Job OverviewWe are seeking a highly motivated Data Integration Specialist to join our team at Hevo Data. This role is ideal for individuals with a strong background in sales and a passion for data integration.About the RoleThis position involves engaging with prospects, identifying their data integration needs, and presenting Hevo as a one-stop solution. The...


  • Bengaluru, Karnataka, India noesyssoftware Full time

    About This OpportunityWe are seeking a seasoned Data Warehouse Engineer who will spearhead the development of our business's data warehouse. The successful candidate will be responsible for designing and implementing ETL processes, cube development, database performance administration, and dimensional design of table structures.The ideal candidate should...