Red hat Data Integration Engineer 

India, Maharashtra, Pune 

400516205

About the job:

The Red Hat Salesforce PRM (Partner Relationship Management) team is looking for a Data Integration Engineer. In this role, you will have responsibility for designing and building data pipelines to extract, transform, and load data from various sources into data warehouses, Salesforce, or other storage solutions, while optimizing processes for efficiency and reliability. You should have the ability to understand the needs of the business and translate them into technical solutions within the context of the desired system architecture, focused on efficiency, accuracy, and scalability. You’ll work as part of a scrum team to complete integration development work, as well as define end-to-end process implementation strategies.

What will you do?

• Work with Product Management to understand data-related business processes and requirements

• Understand the system architecture documented by the Enterprise Architecture team and design solutions that align with it

• Be responsible for the design and development of data pipelines

• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests and wants from the underlying, true business needs

• Understand the Salesforce data model

• Ensure solutions are portable so they can be promoted to additional environments, including production, by an automated deployment pipeline

• Meet team standards for solution design, code, configuration, testing, and quality

• Participate in peer reviews to provide and receive constructive feedback

• Work as part of a scrum team as well as on your own with minimal supervision

• Work with other technical teams to build integrated solutions

• Support and troubleshoot integration issues

What will you bring?

• 8+ years of data integration design and development experience

• High-level of proficiency in developing complex SQL

• Extensive experience in working with relational databases

• Proficiency in developing using Informatica SaaS for ETL and for automated data movement / integration

• Expertise with Python development

• Experience working with integrations with Salesforce

• Bachelor’s degree

• Ability to design solutions, break large solutions down into parts, and support the delivery of those solutions by other developers

• Ability to understand data “beyond the code” and its relevance to key business processes

• Ability to understand and troubleshoot implemented code

• Ability to understand an implemented architecture and deliver on technical specifications

• Ability to accurately scope, plan, and estimate the level of effort for tasks, with an appropriate balance of risk and effort

• Ability to work on your own and manage multiple-task assignments

• Outstanding written and verbal communication skills, including presentation skills

• Excellent problem-solving and troubleshooting skills with the ability to exercise mature judgment

The following are considered a plus:

• Experience with Salesforce CPQ, Loyalty Management, Rebates Management

• Experience with the deployment of Salesforce metadata using the Salesforce Command Line Interface (CLI)

• Experience with DBT is preferred

• Experience with FiveTran is preferred

• Experience with Starburst and Snowflake is preferred

• Experience with CI/CD and automated data schema deployments is preferred

• Experience with at least one of the following Source Code Management (SCM) technologies or similar: GitHub, GitLab, Bitbucket, git

• Experience with DevOps automation using one of the following or equivalent: GitHub Actions, Azure DevOps, Jenkins

• Advanced degree in the area of specialization