Data Engineer

Role Overview

The Informatica Data Lead partners with Solution Architects and Business Analysts to deliver end-to-end data solutions for client projects. This role leads ETL design and development, database engineering, data modeling, performance tuning, and data governance practices across MS SQL Server and PostgreSQL environments.

Key Duties & Responsibilities

Collaborate with Solution Architect and BAs to design, evaluate, and deliver high-quality end-to-end data solutions for client engagements.

Engage non-technical subject matter experts to understand and explain data behavior, patterns, and characteristics in an accessible way.

Work cross-functionally to resolve data and process issues, ensuring timely delivery and quality outcomes.

Use standard data modeling, data flow, and documentation tools to analyze, document, and present data analysis outputs.

Plan and develop ETL and data preparation/aggregation processes from multiple sources into MS SQL Server and/or PostgreSQL databases.

Maintain and optimize ETL pipelines to meet evolving requirements and changing upstream/downstream dependencies.

Participate in MS SQL code reviews and guide SQL and ETL best practices.

Review and validate database schema changes to ensure alignment with data architecture and downstream impacts.

Develop and optimize T-SQL components (stored procedures, functions, inline SQL) and work confidently with database structures.

Analyze existing SQL queries and ETL jobs for performance improvements and scalability.

Monitor code migration and database change management across development lifecycle stages (dev/test/uat/prod).

Design and develop procedures/scripts for data migration and cutover activities.

Develop, implement, and maintain database policies, procedures, and architecture documentation to ensure data security, integrity, and compliance.

Required Qualifications & Experience

5–8 years of hands-on T-SQL programming experience.

2–3 years of Informatica development experience.

Experience migrating Informatica PowerCenter to Informatica Intelligent Data Management Cloud (IDMC).

Strong experience in performance tuning across sources, mappings, targets, and sessions.

Solid understanding of Data Architecture and Data Modeling concepts.

Working experience with Microsoft SQL Server and/or PostgreSQL.

Familiarity with Git source control.

Knowledge of CI/CD pipelines and/or deployment automation tools.

Preferred / Advantageous Experience

Delivered ETL and/or data modeling projects for enterprise clients with sizeable scope (e.g., multi-year delivery or large-budget programmes).

Demonstrated interest in modern ETL/data processing solutions (e.g., Apache Flink) and continuous learning in data engineering.

Strong AWS experience, including managed services such as: Amazon RDSETL services/toolsStream processing solutions

Broad AWS cloud delivery experience in client-facing environments.

Welcome to DBiz.Ai (Digital Biz Solutions), a trailblazer in the realm of digital transformation and AI-driven solutions. At DBiz, we pride ourselves on our relentless pursuit of excellence and innovation, empowering businesses to thrive in the digital age. Our mission is to harness the power of digital technologies and artificial intelligence to deliver cutting-edge solutions that drive efficiency, enhance customer experiences, and create sustainable value for our clients.

Who We Are:
DBiz is a forward-thinking digital solutions provider, specializing in leveraging the latest advancements in technology to solve complex business challenges. Our team comprises seasoned experts in artificial intelligence, rapid product engineering using low-code, RPA, platform engineering, data analytics, and digital strategy, all dedicated to pushing the boundaries of what is possible. With a deep understanding of various industries, we tailor our solutions to meet the unique needs of each client, ensuring a personalized approach to digital transformation.

Our Expertise:
At DBiz.Ai, our core strength lies in our expertise in AI and digital technologies. We offer a comprehensive suite of services designed to address the full spectrum of digital transformation needs:

AI-First:
Predictive Analytics: Empowering businesses with data-driven insights to anticipate trends and make informed decisions.

Natural Language Processing: Enhancing customer interactions through advanced language understanding and conversational AI.

Computer Vision: Revolutionizing industries with image and video analysis capabilities for improved operational efficiency.

Rapid Product Engineering:
Accelerated Development: Fast-tracking product development cycles to bring innovative solutions to market quickly.

Agile Methodologies: Implementing agile practices to ensure flexibility, adaptability, and continuous improvement throughout the development process.

Quality Assurance: Ensuring high standards of product quality and reliability through rigorous testing and validation.

Platform Engineering:
Microsoft: Leveraging the power of Microsoft's ecosystem to build robust and scalable enterprise solutions.

OutSystems: Utilizing OutSystems' low-code platform for rapid application development and deployment.

Salesforce: Integrating Salesforce to enhance customer relationship management and drive business growth.

ServiceNow: Implementing ServiceNow to streamline IT operations and improve service delivery.

Why Choose DBiz:
Proven Track Record:
Our portfolio showcases a history of successful projects and satisfied clients across various industries.

Innovative Approach:
We stay ahead of the curve by continuously exploring and adopting the latest technological advancements.

Customer-Centric:
Our client-first philosophy ensures that we always prioritize the needs and goals of our customers.

Expert Team:
Our team of skilled professionals brings a wealth of knowledge and experience to every project, guaranteeing high-quality results.

Collaborative Partnerships:
We believe in fostering strong partnerships with our clients, working together to achieve mutual success.

Join Us:
At DBiz.Ai, we are always on the lookout for passionate and talented individuals who share our vision of leveraging technology to create a better future. Whether you are an experienced professional or a recent graduate, DBiz offers a dynamic and supportive environment where you can grow your career and make a significant impact.