Sr. Data Engineer

Key Responsibilities

• Design, develop, and maintain scalable data ingestion, transformation, and integration pipelines.
• Analyze, diagnose, and resolve DQCI (Data Quality & Critical Issues) remediation requirements across the data ecosystem.
• Implement fixes across ingestion, transformation, and consumption layers to ensure data accuracy and consistency.
• Perform root-cause analysis of data defects and implement sustainable long-term solutions.
• Develop and optimize ETL/ELT processes using industry-leading data integration tools.
• Build and enhance data pipelines to support business intelligence, reporting, analytics, and downstream applications.
• Develop complex data transformation and mapping logic to meet business requirements.
• Integrate data from multiple internal and external systems through APIs and batch interfaces.
• Optimize SQL queries, database objects, and data processing workloads for performance and scalability.
• Collaborate with business, analytics, and architecture teams to ensure high-quality data delivery.
• Support DevOps and CI/CD practices for deployment, version control, and release management.
• Ensure adherence to data governance, security, and compliance standards.

---

Required Technical Skills

Core Skills

• Snowflake Development
  • Data modeling and schema design
  • Performance tuning and optimization
  • Stored procedures, tasks, streams
• Matillion ETL/ELT
  • Job orchestration
  • Data transformation and workflow development
  • Integration with Snowflake and cloud platforms
• Talend Data Integration
  • ETL development
  • Data migration and integration solutions
  • Data quality and validation frameworks
• Advanced SQL
  • Complex joins, stored procedures, views, and performance optimization
  • Query tuning and large-scale data processing
• Data Pipelines
  • Batch and near real-time processing pipelines
  • Data ingestion, transformation, and orchestration
• Data Transformation & Mapping
  • Source-to-target mappings
  • Business rule implementation
  • Data reconciliation
• API Integration
  • REST/SOAP APIs
  • API-based data ingestion and integration
• Azure DevOps
  • Source control management
  • CI/CD pipeline and deployment
  • Release management and automation

---

Expected Contributions

• Diagnose and resolve DQCI remediation work across enterprise data platforms.
• Implement fixes across ingestion and transformation pipelines to eliminate recurring data issues.
• Correct defects at source, integration, or consumption layers based on root-cause analysis.
• Improve overall platform stability, reliability, and data quality.
• Deliver sustainable and scalable fixes rather than temporary workarounds.
• Optimize existing ETL/ELT processes and improve pipeline performance.
• Support production issues and provide timely resolution of critical data incidents.
• Ensure data accuracy, completeness, and consistency across systems.
• Collaborate effectively with Data Architects, Business Analysts, QA teams, and stakeholders.
• Contribute to continuous improvement initiatives and engineering best practices.

---

Preferred Qualifications

• Strong Experience with Talend + Snowflake + Matillion + Postgress
• Hands on experience on AWS and S3
• Strong knowledge of data warehousing concepts, dimensional modeling, and data governance.
• Experience working in Data warehousing projects & agile
• Strong analytical, troubleshooting, and problem-solving skills.

Target Designation: Senior Data Engineer
Location Preference: Offshore
Primary Skills: Talend, Snowflake, Advanced SQL, Matillion, Data Pipeline Engineering, Data warehousing.

Secondary Skills: Postgress, API integration, AWS, Matillion, Azure DevOps

 

Responsibilities

OK

Qualifications

OK

About us

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.