Company description Re:Sources is the backbone of Publicis Groupe, the worlds third-largest communications group. Formed in 1998 as a small team to service a few Publicis Groupe firms, Re: Sources has grown to 4,000+ people servicing a global network of prestigious advertising, public relations, media, healthcare and digital marketing agencies. We provide technology solutions and business services including finance, accounting, legal, benefits, procurement, tax, real estate, treasury and risk management to help Publicis Groupe agencies do what they do best: create and innovate for their clients. In addition to providing essential, everyday services to our agencies, Re:Sources develops and implements platforms, applications and tools to enhance productivity, encourage collaboration and enable professional and personal development. We continually transform to keep pace with our ever-changing communications industry and thrive on a spirit of innovation felt around the globe. With our support, Publicis Groupe agencies continue to create and deliver award-winning campaigns for their clients. Overview Role Overview We are looking for Integration Engineer who will be responsible for designing, developing, and maintaining software solutions that integrate various systems using Application Programming Interfaces (APIs). This role involves working closely with internal and external teams to implement, manage, and troubleshoot API integrations, ensuring smooth communication between different software applications. The candidate will work closely with software developers, architects, and business teams to ensure seamless and efficient integration processes. This role requires deep knowledge of RESTful APIs, SOAP, web services, and various integration platforms. Responsibilities Design and implement API integrations: Collaborate with cross-functional teams to develop API solutions that meet business requirements, ensuring secure, efficient, and scalable integration of applications. API development and management: Build and maintain API integrations to ensure smooth communication between various software applications and systems. Technical documentation: Create and maintain comprehensive technical documentation for all API integrations, including diagrams, flowcharts, and descriptions of processes. Troubleshooting and debugging: Identify and resolve API-related issues, including troubleshooting connection problems and data inconsistencies. Testing and quality assurance: Conduct unit and integration tests to ensure the reliability and functionality of APIs before deployment. Security and compliance: Ensure API security by implementing industry-standard authentication, authorization mechanisms (OAuth, JWT, etc.), and encryption protocols. Collaboration with stakeholders: Work with product managers, development teams, and external partners to understand business needs and ensure successful API integration. Monitoring and optimization: Monitor API performance, usage, and error logs, and optimize APIs for efficiency, stability, and scalability. Platform and system integration: Integrate APIs across a variety of platforms (cloud, SaaS, on-premise, etc.), ensuring compatibility and minimal downtime. Write clean, scalable code using .NET programming languages Write unit tests and drive code from those tests (TDD) Remain up to date with the terminology, concepts and best practices for coding Contribute to integrations cloud design in Azure Create proof of concepts to prove assumptions Coordinate with other software professionals and developers Skills/Experience Technical Skills: API Management & Development: Proficiency in REST, SOAP, GraphQL, and gRPC API standards. Experience with API lifecycle management tools like Swagger, Postman, Apigee, or MuleSoft. Knowledge of API security protocols (OAuth2, JWT, SAML, etc.) and the various flows (machine to machine, interactive etc). Integration Platforms: Expertise in Enterprise Service Bus (ESB) tools like MuleSoft, TIBCO, Dell Boomi, WSO2, or Apache Camel. Familiarity with iPaaS (Integration Platform as a Service) solutions, such as Zapier, Workato, or Tray.io. Programming Languages: Strong skills in C# programming language for custom integration development. Experience writing OAuth client code in C# dotnet Data Integration: Knowledge of ETL (Extract, Transform, Load) processes and tools. Familiarity with data transformation, mapping, and manipulation using XML, JSON, XSLT, and other formats. Cloud Integration: Experience with cloud platforms like AWS, Azure, and Google Cloud. Knowledge of cloud-native services and API gateways such as Azure/AWS API Gateway, Azure Logic Apps, or Google Cloud Functions. Microservices Architecture: Understanding of microservices and serverless architectures. Experience with Azure Function Apps and App Services Familiarity with containerization tools like Docker and orchestration platforms like Kubernetes for deploying microservices. Database Integration: Proficiency with both SQL (e.g., MySQL, PostgreSQL) and NoSQL (e.g., Azure CosmosDB, MongoDB, Cassandra) databases. Understanding of data synchronization and replication techniques. Software development Familiarity with design patterns and patterns of enterprise application architecture Knowledge of SOLID principles and related paradigms 4+ years of development experience using in C# dotnet core Proven track record of driving software design from Test Driven Development Knowledge of at least one other programming language (e.g. C++, Java, Javascript, Rust) Familiarity with architecture styles/APIs (REST, gRPC) Understanding of Agile methodologies Strong attention to detail Excellent troubleshooting and communication skills Able to work well in a team setting. Knowledge of dotnet messaging patterns and libraries - MassTransit, MediatR, etc Experience with automated integration testing at the code and system level Experience with dependency injection (dotnet service collections) Experience with modern dotnet microservices coding practices (project structures, configuration, local development, automated production deployment etc.) Knowledge of Infrastructure as Code (IaC) using bicep Messaging & Streaming: Experience with messaging protocols like Azure Service Bus, AMQP, MQTT, or JMS. Familiarity with event-driven architectures and streaming platforms like Apache Kafka, RabbitMQ, or AWS SNS/SQS. Version Control & CI/CD: o Proficiency with version control tools like Git and experience working with CI/CD pipelines (Azure DevOps, Github Actions, Jenkins, GitLab CI, etc.) to automate deployments and integration testing. Security & Compliance: o Strong understanding of encryption, authentication, and authorization techniques. o Knowledge of compliance standards such as GDPR, HIPAA, and PCI-DSS related to data integration. Preferred Skills: Experience with Portfolio and Project Management Tool (PPM): o Experience of working on integrations with PPM tools like AdobeWorkfront or AdaptiveWork by Planview formally Clarizen etc. is preferred. Qualifications Must be an IT graduate
Q1.If we have 2 tables with the same schema, one table has indexes and the other doesn't. Will there be any performance difference on that tabl... read more