Deltacubes - Informatica Developer - Data Warehousing

De; Kolkata District; On-site; INR 1,100,000 - 1,900,000; Full time

Job summary

De is seeking an Informatica Developer to design and maintain ETL architectures powering clients' analytical platforms. You will collaborate with data architects, analysts, and infra teams to translate business requirements into scalable data workflows.

You will design mappings, optimize ETL performance, and mentor junior developers, while ensuring data quality and boardroom-ready dashboards.

Qualifications

• Expertise in Informatica PowerCenter or IICS and advanced transformations.
• Strong SQL and stored procedures in relational databases.
• Ability to communicate technical concepts to non-technical stakeholders.
• Knowledge of data warehousing and star/snowflake schemas.
• Capability to handle multiple projects in a fast-paced environment.

Responsibilities

• Design and develop Informatica mappings, sessions, and workflows for data integration.
• Optimize ETL performance and troubleshoot data bottlenecks.
• Collaborate on data profiling and validation to ensure data integrity.
• Apply data warehousing best practices to improve scalability and maintainability.
• Provide mentorship and participate in code reviews to uphold standards.

Skills

Informatica PowerCenter or IICS

Advanced SQL and stored procedures

Data warehousing concepts (Star/Snowfl

Effective communication to non-tech

Multi-project prioritization

Education

Bachelor's degree in Computer Science or IT

Job description

Role Overview

As an Informatica Developer, you will be at the core of our data integration initiatives, designing and maintaining robust ETL architectures that serve as the backbone for our clients' analytical platforms. You will collaborate closely with data architects, business analysts, and infrastructure teams to translate complex business requirements into scalable data workflows. Your work will directly influence the accuracy and availability of data, ensuring that our stakeholders can rely on high-quality information to support their operational and strategic goals.

Key Responsibilities

• Design and develop complex Informatica mappings, sessions, and workflows to facilitate seamless data integration across disparate source systems.
• Optimize ETL performance and troubleshoot data bottlenecks to ensure timely delivery of critical business reports and dashboards.
• Collaborate with cross-functional teams to perform data profiling and validation, ensuring the integrity and consistency of data assets.
• Implement best practices in data warehousing and ETL design to enhance system scalability and maintainability for long-term project success.
• Provide technical mentorship to junior developers and participate in code reviews to maintain high standards of software engineering across the team.

Required Skillset

• Demonstrated expertise in Informatica PowerCenter or IICS, with a deep understanding of advanced transformations and workflow management.
• Strong proficiency in writing complex SQL queries and stored procedures to manipulate and analyze data within relational database environments.
• Proven ability to communicate technical concepts effectively to non-technical stakeholders and work collaboratively within a distributed team environment.
• Solid grasp of data warehousing methodologies, including Star and Snowflake schemas, and their application in real-world business scenarios.
• A bachelor's degree in Computer Science, Information Technology, or a related field, complemented by a proactive approach to learning new data technologies.
• Capability to manage multiple project priorities in a fast-paced environment while maintaining high attention to detail and quality standards.

(ref:hirist.tech)