The Role
Design, build, modernize, and optimize ETL/ELT pipelines and Salesforce integrations across enterprise platforms. Migrate Informatica workflows to Azure Data Factory, develop advanced SQL transformations, and implement scalable data models, warehousing, governance, quality, and lineage frameworks. Own production monitoring, incident management, troubleshooting, orchestration, and documentation. Collaborate with Salesforce, architecture, DevOps, AI, and business teams to support analytics, automation, and AI use cases.
Summary Generated by Built In
Role Summary
We are seeking a highly skilled Salesforce Data Engineer responsible for designing, building, and optimizing scalable data pipelines and data integration solutions across the Salesforce ecosystem and external platforms.
This role focuses on enabling reliable data movement, analytics, and AI-driven capabilities while ensuring governance, security, and performance.
This role will focus on modernizing legacy Informatica pipelines into Azure-native architectures while enabling robust, scalable, and performant data integration with Salesforce and enterprise systems. The Salesforce Data Engineer partners closely with Salesforce Developers, Agentforce Engineers, Architects, and DevOps teams to deliver secure, high‑quality, and performant data foundations that power intelligent automation and business decision‑making.
Duties & Responsibilities
· Design, build, and modernize scalable, high-performance ETL/ELT pipelines and data integration solutions across cloud and enterprise platforms
· Translate complex business requirements into optimized, scalable data transformation, integration, and data flow architectures
· Develop and maintain robust integrations between Salesforce and enterprise systems, ensuring reliable and secure data exchange
· Lead the migration of legacy Informatica workflows to Azure Data Factory (ADF) and cloud-native architectures, applying modern design patterns and best practices
· Develop and optimize advanced SQL transformations across Oracle, Snowflake, and MySQL, ensuring performance, scalability, and cost efficiency
· Drive ETL/ELT performance optimization through query tuning, execution plan analysis, workload management, and pipeline optimization
· Design and implement scalable data models and data warehouse solutions, ensuring strong data lineage, traceability, and reusability
· Establish and enforce data quality frameworks, validation rules, and governance standards across data pipelines and integrations
· Enable modern data architecture patterns, including zero-copy, federated data access, and near real-time data integration
· Own production operations, including monitoring, incident management, root cause analysis, and SLA-driven support for critical data pipelines
· Automate orchestration, scheduling, monitoring, and documentation to improve reliability, observability, and operational efficiency
· Collaborate cross-functionally with Salesforce Developers, Agentforce Engineers, Architects, and business stakeholders to align data models with application, automation, and AI/agent use cases
· Partner with architecture teams to define scalable data architecture patterns, canonical models, and governance strategies within the Salesforce and enterprise data ecosystem
· Create and maintain comprehensive documentation for data pipelines, transformations, mappings, workflows, and operational processes
Requirements
Minimum Years of Experience
4–6 years of experience in data engineering, analytics engineering, or platform data integration.
4+ years of hands‑on experience with Informatica Power Center
2+ years of hands-on experience with Python
Basic Qualifications
· Bachelor's degree in computer science, Information Technology, Engineering, or a related field
· 5+ years of experience in data engineering and ETL/ELT development
· Strong hands-on expertise in Informatica PowerCenter and Azure Data Factory (ADF)
· Advanced SQL development skills across Oracle, Snowflake, and MySQL
· Proven experience in ETL/ELT design, development, and performance optimization, including query tuning and pipeline efficiency
· Experience integrating Salesforce with enterprise systems, ensuring reliable and scalable data exchange
· Solid understanding of data warehousing concepts, data modeling, ETL design patterns, and end-to-end data lineage
· Experience with production support, including incident management, root cause analysis, and resolution
· Hands-on experience with scheduling and orchestration tools (e.g., Tidal or similar platforms)
· Familiarity with modern data architecture patterns, including zero-copy and federated data access
· Experience working in Agile/Scrum environments, with strong collaboration across cross-functional teams
· Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues
Preferred Qualifications
· Salesforce platform familiarity or relevant certifications (e.g., Data Cloud, Platform, Integration)
· Exposure to modern cloud data architectures, particularly within the Azure ecosystem
· Working knowledge of advanced Snowflake capabilities, such as data sharing, clustering, and performance optimization
· Experience leading or contributing to ETL/ELT migrations from legacy platforms to cloud-native solutions
· Strong understanding of data governance, data quality frameworks, and compliance best practices
· Ability to effectively collaborate in complex, cross-functional enterprise environments with multiple stakeholders · Experience using Python for data engineering, automation, or pipeline development
· Familiarity with Databricks or other advanced analytics and data processing platforms
Benefits
Skills Required
- 4-6 years of experience in data engineering, analytics engineering, or platform data integration
- 4+ years of hands-on experience with Informatica PowerCenter
- 2+ years of hands-on experience with Python
- Bachelor's degree in computer science, Information Technology, Engineering, or a related field
- 5+ years of experience in data engineering and ETL/ELT development
- Strong hands-on expertise in Informatica PowerCenter and Azure Data Factory
- Advanced SQL development skills across Oracle, Snowflake, and MySQL
- Experience designing, developing, and optimizing ETL/ELT pipelines, including query tuning and pipeline efficiency
- Experience integrating Salesforce with enterprise systems
- Understanding of data warehousing, data modeling, ETL design patterns, and end-to-end data lineage
- Experience with production support, incident management, root cause analysis, and resolution
- Hands-on experience with scheduling and orchestration tools such as Tidal or similar platforms
- Familiarity with zero-copy and federated data access architecture patterns
- Experience working in Agile/Scrum environments
- Strong analytical, problem-solving, and complex data troubleshooting skills
- Salesforce platform familiarity or relevant certifications, such as Data Cloud, Platform, or Integration
- Exposure to modern cloud data architectures, particularly Azure
- Working knowledge of advanced Snowflake capabilities, including data sharing, clustering, and performance optimization
- Experience contributing to or leading ETL/ELT migrations from legacy platforms to cloud-native solutions
- Understanding of data governance, data quality frameworks, and compliance best practices
- Ability to collaborate in complex, cross-functional enterprise environments
- Experience using Python for data engineering, automation, or pipeline development
- Familiarity with Databricks or other advanced analytics and data processing platforms
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Staples India is Staples’ technology and innovation hub in Chennai, building platforms, systems, and digital solutions that support the company’s global operations and future of work. Staples serves consumers and businesses with workplace products and services, including office supplies, janitorial products, technology, furniture, breakroom essentials, print and marketing, shipping, travel, and promotional offerings. Its India teams focus on engineering, eCommerce, process optimization, and enterprise solutions.
.png)
