Work With Us

Back to Careers

ETL/BI Developer

  • Date Posted:
  • Location:
  • Adroitco HQ – 2801 Network Blvd., Suite 215, Frisco, TX 75034
  • Engagement Type:
  • Full Time
Interview Rounds: 4
  • (Pre-Screening, Technical, Director, HR)

Responsibilities:

  • Create, build, and implement ETL solutions for extracting data from various sources, transforming it, and loading it into the Amazon AWS Cloud data warehouse, culminating in the final production of the BI (OBIEE/Power BI/Tableau) product.
  • Reviewing and understanding requirements by analysing Business Requirement Specifications or Excel documents or Business screenshots.
  • Developing Data Models as Proof of Concepts.
  • Gathering data from various sources and crafting ETL code based on Source-to-Target Mapping documents.
  • Performing data analysis on Source Data called Spend Direct and applying Transformation Rules.
  • Creating Data Mart Tables in compliance with established business rules.
  • Designing and implementing ETL packages within the ODI/SSIS/Pentho Spoon tool framework.
  • Ensuring data integrity by conducting Data Validation using sample use cases within the Amazon Cloud Aurora Data Mart master tables.
  • Prepare, analyse, share and interact the data/content on the web/Browser using OBIEE/PowerBI/Tableau Desktop/Server or Cloud and manage Deployment on-premises/cloud.
  • Presenting data using OBIEE/Power BI/Tableau Desktop publishing it on the server, and scheduling for client review and approval (UAT sign-off).
  • Undertaking OBIEE RPD Repository Database Metadata design and administration tasks, including installations, configuration, and patching, within both Linux and Windows environments.
  • Managing installations on Virtual Machines to support the reporting and ETL processes.
  • Creating Reports and Dashboards to provide valuable insights.
  • Creating Multidimensional Cubes (cubes) by handle the attribute list differently than the Tabular Model for SQL Server Analysis Services (SSAS)
  • Working within an Agile Methodology framework

Minimum Education:

Bachelor’s degree in computer science, computer information systems, information technology, or advanced educational background equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Industry
IT Services
city
Frisco
state
Texas
country
United States
zip
75034
Apply Now