Senior Data Engineer - IICS (5-8 yrs)

Role : Senior Data Engineer - IICS (Informatica Intelligent Cloud Services)

Years of Experience : 5+ years

No. of Openings : 2

Location : Chennai

Job Summary :

We are looking for a skilled and motivated Senior Data Engineer to join data integration and analytics team. The ideal candidate will have hands-on experience with Informatica IICS, AWS Redshift, Python scripting, and Unix/Linux systems. You will be responsible for building and maintaining scalable ETL pipelines to support business intelligence and analytics needs.

We value individuals who are passionate about continuous learning, problem-solving, and enabling data-driven decision-making.

Primary Skills :

- Informatica IICS

- AWS (especially Redshift)

Secondary Skills :

- Python

- Unix/Linux

Role Description :

As a Senior Data Engineer, you will lead the design, development, and management of scalable data platforms and pipelines. This role demands a strong technical foundation in data architecture, big data technologies, and database systems (both SQL and NoSQL), along with the ability to collaborate across functional teams to deliver robust, secure, and high-performing data solutions.

Key Responsibilities :

- Design, develop, and maintain end-to-end data pipelines and infrastructure.

- Translate business and functional requirements into scalable, well-documented technical solutions.

- Build and manage data flows across structured and unstructured data sources, including streaming and batch integrations.

- Ensure data integrity and quality through automated validations, unit testing, and comprehensive documentation.

- Optimize data processing performance and manage large datasets efficiently.

- Collaborate closely with stakeholders and project teams to align data solutions with business objectives.

- Implement and maintain security and privacy protocols to ensure safe data handling.

- Set up development environments and configure tools and services.

- Mentor junior data engineers and contribute to continuous improvement and automation initiatives.

- Coordinate with QA and UAT teams during testing and release phases.

Role Requirements :

- Strong proficiency in SQL, including procedures, performance tuning, and analytical functions.

- Solid understanding of data warehousing concepts, including dimensional modeling and slowly changing dimensions (SCDs).

- Hands-on experience with scripting languages (Shell / PowerShell).

- Proficiency in data profiling, validation, and testing practices.

- Excellent problem-solving, communication (written and verbal), and documentation skills.

- Exposure to Agile methodologies and CI/CD practices.

Additional Requirements :

- Overall 5+ years of experience, with 3+ years of hands-on experience in Informatica IICS (Cloud Data Integration, Application Integration).

- Strong proficiency in AWS Redshift and writing complex SQL queries.

- Solid programming experience in Python for scripting, data wrangling, and automation.