Tech Stack
AWSAzureCloudETLGoogle Cloud PlatformInformaticaSOAPSQL
About the role
- Design and build scalable and performant ETL workflows.
- Design, develop, and deploy integration processes using Dell Boomi AtomSphere platform.
- Work with business and technical teams to gather integration requirements and translate them into technical specifications.
- Build and maintain integration processes connecting various systems such as ERPs, CRMs, databases, and cloud services.
- Optimize and monitor existing integration processes for performance and reliability.
- Handle exception handling, logging, and alerting frameworks within integration flows.
- Collaborate with QA teams to ensure thorough testing of integrations.
- Document integration designs, configurations, and standard operating procedures.
- Provide production support and root cause analysis for integration-related issues.
Requirements
- 5–10 years of experience in Dell Boomi integration/ETL workflow development.
- Hands-on experience with Boomi Atom/Molecule/Cloud Atom deployment models.
- Strong experience in designing and developing Boomi processes, connectors, and APIs.
- Deep understanding of integration patterns, web services (SOAP/REST), data transformation, and error handling.
- Strong skills in XML, XSLT, JSON, SQL, and scripting languages.
- Good Knowledge of SQL queries and Stored Procedures.
- Experience with Boomi Process Reporting, Environment Management, and API Management.
- Hands-on experience of SQL DB.
- Experience with other ETL tools like Talend is a strong plus.
- Familiarity with cloud platforms like AWS, Azure, or GCP.
- Experience in CI/CD, version control (Git), and DevOps practices.
- Knowledge of Agile/Scrum methodologies and Jira/Confluence.