As a Data Warehouse Engineer in our team, you should have a proven ability to deliver high-quality work on time and with minimal supervision.
Develops or modifies procedures to solve complex database design problems, including performance, scalability, security and integration issues for various clients (on-site and off-site).
Design, develop, test, and support the data warehouse solution.
Adapt best practices and industry standards, ensuring top quality deliverable''s and playing an integral role in cross-functional system integration.
Design and implement formal data warehouse testing strategies and plans including unit testing, functional testing, integration testing, performance testing, and validation testing.
Evaluate all existing hardware's and software's according to required standards and ability to configure the hardware clusters as per the scale of data.
Data integration using enterprise development tool-sets (e.g. ETL, MDM, Quality, CDC, Data Masking, Quality).
Maintain and develop all logical and physical data models for enterprise data warehouse (EDW).
Contributes to the long-term vision of the enterprise data warehouse (EDW) by delivering Agile solutions.
Interact with end users/clients and translate business language into technical requirements.
Acts independently to expose and resolve problems.
Participate in data warehouse health monitoring and performance optimizations as well as quality documentation.
Job Requirements :
2+ years experience working in software development & data warehouse development for enterprise analytics.
2+ years of working with Python with major experience in Red-shift as a must and exposure to other warehousing tools.
Deep expertise in data warehousing, dimensional modeling and the ability to bring best practices with regard to data management, ETL, API integrations, and data governance.
Experience working with data retrieval and manipulation tools for various data sources like Relational (MySQL, PostgreSQL, Oracle), Cloud-based storage.
Experience with analytic and reporting tools (Tableau, Power BI, SSRS, SSAS). Experience in AWS cloud stack (S3, Glue, Red-shift, Lake Formation).
Experience in various DevOps practices helping the client to deploy and scale the systems as per requirement.
Strong verbal and written communication skills with other developers and business clients.
Knowledge of Logistics and/or Transportation Domain is a plus.
Ability to handle/ingest very huge data sets (both real-time data and batched data) in an efficient manner.

About DataToBiz Pvt. Ltd.
About
With vision comes the insight and with insight comes the faith. We deliver the precise information/insights for your eye to visualize the facts and take the required decision with faith when it comes to making a business move. Everything now is based on assurity, the assurity that one gets from the information that is driven via collected raw data. We at DataToBiz help frame and explore that raw data to bring forth the facts behind it. These facts can help you fuel your business to rise above all others.
Connect with the team
Similar jobs
📍 Position : Lead Angular Developer
📅 Experience : 7 to 12 years
🧑💼 Open Positions : 2
📍 Work Location : Bangalore, Pune, Chennai
🏢 Work Mode : Hybrid – 3 days/week in-office
📅 Notice Period : Immediate to 15 days preferred
🔧 Key Responsibilities :
- Lead the design, development, and optimization of responsive and scalable web applications.
- Collaborate closely with UI/UX designers to translate wireframes into high-quality code.
- Drive component-based architecture using modern Angular frameworks.
- Develop reusable, testable, and efficient frontend components using Angular (v2+), JavaScript/ES6, and HTML5/CSS3.
- Ensure seamless integration with APIs, services, and backend systems.
- Conduct thorough unit testing and support integration testing using tools like Jasmine, Karma, Cypress, or similar.
- Promote coding best practices, maintain code quality, and align with SOLID principles and modern design patterns.
- Participate in pair programming, Agile, and Extreme Programming (XP) practices.
🛠️ Must-Have Technical Skills :
- Expertise in Angular (latest versions) and core JavaScript/ES6
- Working knowledge of ReactJS (preferred)
- Strong understanding of HTML5, CSS3, and responsive design techniques
- Familiarity with design tools : Figma, Adobe XD, InVision, Sketch
- Performance optimization for web apps and knowledge of deployment to various web servers
- Testing frameworks : Jasmine, Karma, Cypress, or similar
🎯 Ideal Candidate Profile :
- Currently working as an Individual Contributor in a product-based company
- Proven expertise in leading frontend modules or small teams
- Ability to build user interfaces that are beautiful, functional, and intuitive
- Passionate about clean code and frontend craftsmanship
- Strong communicator and a natural collaborator
🧪 Interview Process :
- Round 1 : Technical pairing assessment
- Round 2 : Technical round with panel
- Round 3 : HR discussion
● Collaborate with engineering, design and product teams to design and ship new
features. Identify and solve bottlenecks and fix bugs.
Desirable Qualifications:
● Deep knowledge of Ruby on Rails (RoR) practices and commonly used modules; deep
understanding of RoR internals like databases, API, caching, proxies, web services,
performance and scalability.
● Experience creating self-contained, reusable, and testable modules and components.
● Experience in SQL and NoSql databases in production environments. Experience
working with Git, AWS/GCP.
● Good communication skills
● 4+ years of relevant experience as a software engineer
- Develop new features understanding current architecture of system
- Responsible to design , develop, test, integrate and support product life cycle.
- Developing existing systems by analyzing and identifying areas for improvements
- Creating Design/Architecture documents, technical specifications, and test cases in line with Quality systems
- Maintaining systems by identifying and correcting software defectsDeveloping / Influencing Requirements.
- Willing and flexible to work on C++
- Consulting internal / external stakeholders concerning maintenance and performance of software systems; implementing software solutions
- "Strong Object Orientated C++
Key Skills: OpenText AppWorks, OpenText Process Suite (all sub components), Java, JavaScript, XML, SQL, BIRT.
Required Skills:
- Ability to translate complex business requirement into functional technical requirements using OpenText AppWorks (erstwhile Process Suite) low code design and integration framework.
- Knowledge on implementing OpenText AppWorks integration services using REST, SOAP, and Email etc.
- Good understanding of OpenText AppWorks case management features and BPM features.
- Experience in various rules and features like LifeCycle, Activities, User Interface (XForms and Low Code design), SLA, KPI, OTDS, CARS, AppWorks Gateway, Single-Sign-On, External Authentication, SAML, Listeners (File, MQ), SOAP Services, Email integration, HTTP Connector, AppWorks integration with Content/Document Management, etc.
- Experience in full OpenText AppWorks implementation including Entity modelling and Rulesets design.
- Expertise in Java, JavaScript, SQL Server Database.
- Expertise in building Web Services, REST Services API’s (nice to have) Familiar in designing and developing applications in cloud environments (preferably Azure).
- Authentication SAML 2.0, OT.
- Knowledge of OTDS and integration with OTDS
- Exposure to HTML5 ,angular and integration of AppWorks to with angular will be plus
- Exposure to another OpenText platform (ECM, xECM, Captiva, iHUB).
A strong passion for learning and adapting to new technologies.
We are seeking a passionate DevOps Engineer to help create the next big thing in data analysis and search solutions.
You will join our Cloud infrastructure team supporting our developers . As a DevOps Engineer, you’ll be automating our environment setup and developing infrastructure as code to create a scalable, observable, fault-tolerant and secure environment. You’ll incorporate open source tools, automation, and Cloud Native solutions and will empower our developers with this knowledge.
We will pair you up with world-class talent in cloud and software engineering and provide a position and environment for continuous learning.








