01
TRCD-26-04240
Senior Data Engineering Developer (IICS, Amazon Redshift)
Senior Data Engineering Developer needed to lead design and delivery of end-to-end data pipelines using Informatica Intelligent Cloud Services (IICS) and Amazon Redshift. The role involves integrating multiple sources (S3, SFTP/MFT, SQL Server, Redshift), designing scalable Redshift schemas with performance/cost optimization, producing technical design artefacts (DFDs, STTMs, NFRs), driving SIT/UAT with defect management, and mentoring junior developers. Requires strong SQL/Redshift tuning skills, AWS multi-environment deployment exposure, and production-grade pipeline controls (audit logging, error handling, alerting, data quality checks).
Position summary
- Location
- India
- Workplace
- On-site
- Employment
- Contract
- Experience
- Minimum 4 years and Maximum 6 years
Role overview
Why This Role Matters.
Senior Data Engineering Developer needed to lead design and delivery of end-to-end data pipelines using Informatica Intelligent Cloud Services (IICS) and Amazon Redshift. The role involves integrating multiple sources (S3, SFTP/MFT, SQL Server, Redshift), designing scalable Redshift schemas with performance/cost optimization, producing technical design artefacts (DFDs, STTMs, NFRs), driving SIT/UAT with defect management, and mentoring junior developers. Requires strong SQL/Redshift tuning skills, AWS multi-environment deployment exposure, and production-grade pipeline controls (audit logging, error handling, alerting, data quality checks).
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
01
IICS
Required
02
Informatica Intelligent Cloud Services
Required
03
Amazon Redshift
Required
04
AWS
Required
05
SQL
Required
06
Window functions
Required
07
Performance tuning
Required
08
S3
Required
09
SFTP
Required
10
MFT
Required
11
SQL Server
Required
12
Data pipelines
Required
13
Schema design
Required
14
Staging layer
Required
15
Transformation layer
Required
16
Target layer
Required
17
DFD
Required
18
STTM
Required
19
NFR
Required
20
SIT
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
Informatica Intelligent Cloud Services (IICS) hands-on (at least 2 years)
Data engineering experience (overall 4-6 years per TR; data engineering 2-4 years mentioned)
Amazon Redshift (schema design, performance tuning, warehouse management)
Advanced SQL (complex transformations, window functions)
Building end-to-end data pipelines across multiple source systems
AWS multi-environment deployments (dev/val/prod)
Production-grade pipeline practices (audit logging, error handling, alerting)
Data quality frameworks and validation strategies
SIT and UAT involvement (test strategy, test case review, defect resolution)
Technical leadership/mentoring of developers
Ability to create technical design artefacts (DFD, STTM, NFR documentation)
Stakeholder communication (technical and non-technical)
Preferred
Nice to Have
Source integrations: Amazon S3
File transfer integrations: SFTP
Managed File Transfer (MFT)
SQL Server as a source system
Automation of manual steps in data pipelines
Pipeline monitoring frameworks
Audit logging frameworks
Data quality checks implementation
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for Senior Data Engineering Developer (IICS, Amazon Redshift)
One page, about two minutes. We only ask for what we actually need to have a first conversation.