Role Description This is a chance to work at the center of a complex and consequential cloud transformation for a major financial services org. We are looking for sharp, delivery-focused data consultants to lead the migration of a large data platform from Google Cloud Platform to AWS. You will not be reviewing architecture diagrams from the sidelines; you will be building the pipelines, designing the schemas, and making the hard calls that keep petabytes of critical financial data moving accurately and on schedule. If you thrive in technically demanding environments, love solving gnarly data problems, and want your fingerprints on an enterprise-scale transformation, this engagement is for you. What You Will Do - Own end-to-end data migration execution: - Drive the full OLAP/OLTP migration from GCP to AWS: data mapping, schema conversion, and hands-on lift-and-shift execution. - Build rock-solid synchronization pipelines: - Design and implement data sync pipelines with tight SLAs for latency, consistency, and error recovery. Zero ambiguity on failure modes. - Bring the target architecture to life: - Implement the AWS data architecture end to end, including driver personalization engines and production-grade dashboarding solutions. - Migrate historical and time-series data at scale: - Execute large-volume historical data migrations with rigorous integrity checks and minimal disruption to live operations. - Build observability from the ground up: - Create monitoring, alerting, and reconciliation frameworks that give the team real-time confidence in cross-cloud data fidelity. - Elevate the team around you: - Share your expertise freely. Mentor peers, unblock blockers, and raise the technical floor of the whole engagement. - Partner closely with the client: - Work shoulder-to-shoulder with stakeholders to nail data governance, access patterns, and analytics requirements. Qualifications - Data Migration - BigQuery to Redshift, Cloud SQL to Aurora/RDS: you have done this before and have the scars to prove it. - Data mapping, schema conversion, and ETL/ELT pipeline design at enterprise scale. - OLAP and OLTP Systems - Dimensional modeling: star and snowflake schemas, done right. - Transactional database optimization and time-series data migration. - Data Synchronization - CDC (Change Data Capture), real-time replication, latency tuning. - Strong opinions on eventual vs. strong consistency, and when each applies. - Battle-tested error handling and retry strategies. - AWS Data Services - Redshift, Aurora PostgreSQL, DMS, Glue, Kinesis, MSK (Kafka), Lambda, S3, Lake Formation. - Analytics and Personalization - Amazon QuickSight, Grafana, dashboarding frameworks, driver personalization engines. - GCP - BigQuery, Cloud Spanner, Dataflow, Pub/Sub, Cloud SQL: you know the terrain you are leaving. - Infrastructure as Code and CI/CD - Terraform, CloudFormation, and automated CI/CD for data pipelines. - Certifications - Cloud certifications are a plus but are not required. Any of the following, or equivalent credentials from a major cloud provider, are valued: - AWS Certified Solutions Architect (Associate or Professional). - AWS Certified Data Analytics Specialty or Database Specialty. - Google Professional Cloud Architect or Cloud Data Engineer. Benefits - Competitive compensation. - Professional development opportunities. - Flexible work arrangements. Minimum Degree Required Bachelor’s Degree, in lieu of a degree, demonstrating in addition to the minimum years of experience required for the role, three years of specialized training and/or progressively responsible work experience in technology for each missing year of college is required.

• Effectual Senior Cloud Architects are responsible for technical leadership of Professional Services projects. • Partner with Engagement Managers (EMs) to deliver an exceptional customer and delivery team experience. • Expected to demonstrate Effectual’s experience and expertise through the delivery of high-quality, leading-practice solutions to customers. • Define architecture strategy, govern technical standards, and mentor both client teams and internal architects across modernization, resilience, security, and optimization initiatives. • Define enterprise target-state cloud architecture and phased roadmap strategies. • Lead architecture review boards and executive design discussions with client leadership. • Establish reusable architecture standards, guardrails, and delivery patterns across programs. • Architect scalable, highly available AWS solutions using Well-Architected Framework principles. • Build multi-account landing zones, hybrid connectivity (Direct Connect, Transit Gateway), and DR/BC architectures. • Develop Infrastructure-as-Code using Terraform and CloudFormation. • Create Python automation scripts and CI/CD pipelines. • Optimize cloud performance, cost efficiency, reliability, and security posture. • Provide technical guidance and mentorship to client engineering teams. • Lead workshops, knowledge transfer sessions, and incident response. • Troubleshoot complex infrastructure challenges and create comprehensive documentation.

Role Description This role serves as the ultimate technical anchor for our client's database infrastructure within the high-demand automotive sector. We are looking for an expert-level SQL Specialist who goes far beyond standard administrative tasks, anchoring the health, security, and scalability of massive Microsoft SQL Server Enterprise databases. You will be the primary guardian of database integrity, ensuring sub-second performance and high availability at scale. This role is critical to the modernization and stability of our client's core operations. You will own the optimization of a massive library of complex legacy stored procedures, directly impacting system reliability and business continuity. Your deep-dive troubleshooting under pressure will prevent downtime, empower engineering teams, and directly influence the company’s ability to scale. Key Responsibilities - Optimize complex legacy SQL stored procedures, execution plans, indexes, and resource usage to resolve performance bottlenecks and ensure high availability. - Diagnose and debug deep-seated database logic flaws, acting as the master troubleshooter for mission-critical system errors. - Lead the core administration, security, and maintenance of SQL Server 2019 environments, including proactive monitoring, patching, replication, and upgrades. - Build and manage robust backup, recovery, and disaster recovery strategies to ensure zero data loss. - Collaborate directly with development teams to review database code, enforce architecture best practices, and proactively prevent performance degradation. Qualifications - 5+ years of professional experience as a Microsoft SQL Server DBA or Database Specialist. - Expert-Level SQL Mastery: Proven expertise in dissecting, troubleshooting, and rewriting highly complex SQL stored procedures. - Tech Stack: Deep technical command of SQL Server Enterprise Edition (2019 V.15.0.440.1). - Advanced English: Fluent written and spoken English proficiency, with the ability to clearly articulate technical issues to stakeholders. - Ownership Mindset: Strong autonomy, proactive problem-solving skills, and the resilience to handle high-pressure scenarios with minimal guidance. Requirements - Prior experience in the Automotive industry or data-heavy logistics sectors. - Exposure to cloud database migrations (e.g., AWS RDS SQL Server or Azure SQL Managed Instance). - Experience with third-party monitoring and tuning tools (e.g., Redgate, SolarWinds Database Performance Analyzer). - Familiarity with database automation and scripting via PowerShell. Benefits - 100% Remote - Holidays off - Paid Time Off - Health insurance assistance - Competitive USD compensation - Growth opportunities

Role Description We are looking for a talented and experienced AI/ML professional to contribute to our innovative projects. The consultant will work closely with our team to develop and implement advanced AI solutions. With a focus on image-based deep learning, the consultant will utilize their expertise to enhance our existing systems and explore new possibilities. The role requires a strong foundation in AI frameworks, data processing pipelines, and software development, ensuring efficient and effective solutions. Qualifications - Experience in AI/ML technologies - Strong foundation in AI frameworks - Expertise in image-based deep learning - Proficiency in data processing pipelines - Software development skills Requirements - Ability to work collaboratively with a team - Strong problem-solving skills - Effective communication skills Benefits - Inclusive workplace culture - Opportunities for growth and development - Commitment to well-being and work-life balance Company Description 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. - Part of the $4.8 billion RPG Group - Community of 10,000+ innovators across 30+ global locations - Core values: One Zensar, Nurturing, Empowering, and Client Focus