Data Engineer / SQL DB Developer (GCP Migration)

Role Overview:
We are seeking a skilled Data Engineer / SQL Database Developer with strong experience in MS SQL Server, SSIS, SSRS, and cloud migration projects. The ideal candidate will lead the migration of transactional databases from on-premises SQL Server to Google Cloud Platform (GCP), ensuring seamless integration and performance optimization.

Key Responsibilities

• Design and implement migration strategies for SQL Server databases to GCP instances.
• Develop and maintain SSIS packages for ETL processes and SSRS reports for reporting needs.
• Optimize database performance and troubleshoot issues during and after migration.
• Collaborate with cloud architects to configure GCP services (Cloud SQL, BigQuery, GCS, etc.).
• Ensure data integrity, security, and compliance throughout the migration process.
• Document migration steps, configurations, and best practices for future reference.

Required Skills

• Strong proficiency in MS SQL Server (T-SQL, stored procedures, indexing, performance tuning).
• Hands-on experience with SSIS (ETL workflows) and SSRS (report development).
• Proven experience in database migration projects to GCP or other cloud platforms.
• Familiarity with GCP data services (Cloud SQL, BigQuery, Dataflow, Pub/Sub).
• Knowledge of data governance, security, and compliance principles.
• Excellent problem-solving and communication skills.

Preferred Qualifications

• Experience with containerization (Docker/Kubernetes) for database deployments.
• Exposure to Python or PowerShell for automation.
• GCP certification is a plus.

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. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.