Want to know if this job is worth applying to?
Pune - Hinjewadi (Ascendas), India
Onsite
Job Summary
Synechron is seeking an experienced Data Migration and Data Engineering Specialist supporting large-scale data transformation projects. This role involves leveraging advanced SQL development and Python scripting to support data migration, data warehousing, and enterprise analytics initiatives. The ideal candidate will design and execute complex data pipelines, support cloud-based data environments, and apply AI integration techniques to enhance operational efficiency and data quality.
Software Requirements
Required Software Proficiency:
SQL (Snowflake, SQL Server) — advanced skills in designing, developing, and optimizing queries supporting data migration and warehousing (supporting 10+ years)
Python (latest version, e.g., Python 3.8+) — extensive experience scripting, automating data workflows, and supporting data transformation projects (supporting 10+ years)
Data warehousing technologies supporting scalable data storage and data lakes in Snowflake or SQL Server (support supporting 10+ years)
Data migration tools: supporting complex data conversions, migration validation, and reconciliation support
Preferred Software Skills:
Cloud platform support: AWS, Azure, or GCP — supporting data platform migration and cloud-native data management (preferred)
ETL & Data Pipelines: Talend, Informatica, or similar supporting large enterprise data integration support
Overall Responsibilities
Design, develop, and optimize scalable data pipelines supporting enterprise data migration, analytics, and compliance needs
Support data validation, reconciliation, and cleansing activities, ensuring integrity during migration processes
Collaborate with data architects, scientists, and business stakeholders to translate business needs into robust data solutions supporting operational and analytical objectives
Support cloud-based data environments, including migration support, schema evolution, and data platform setup
Automate data workflows supporting data load, transformation, and validation operations supporting continuous delivery
Monitor data pipeline performance, troubleshoot failures, and optimize for performance and data quality
Develop and maintain comprehensive documentation for data integrations, schemas, migration processes, and operational workflows
Support ongoing data quality initiatives, data governance, and compliance in line with enterprise standards
Technical Skills (By Category)
Languages & Data Tools (Essential):
SQL (Snowflake, SQL Server): data validation, migration, and query optimization support
Python: scripting, automation of data workflows, transformation support
Databases & Data Management:
Relational databases: SQL Server, Snowflake supporting enterprise data warehouses and data lakes
Data validation, reconciliation, and schema design supporting data quality and compliance
Cloud & Infrastructure:
AWS, Azure, or GCP (supporting cloud migration and hybrid architecture) (preferred)
Data Integration & Migration:
Support for ETL tools (Talend, Informatica) or scripting frameworks supporting enterprise data migration
Security & Compliance:
Knowledge of encryption, data masking, access controls, supporting data privacy and security standards (e.g., GDPR, HIPAA)
Experience Requirements
10+ years supporting enterprise data warehouses, large-scale data migration, and analytics solutions
Proven track record designing, executing, and supporting complex data pipelines supporting enterprise data platforms
Extensive experience with SQL, Python, cloud data migration, and data validation in regulated or large enterprise environments supporting compliance standards
Demonstrated ability to optimize data workflows, ensure data integrity, and support cloud migration projects supporting operational resilience
Day-to-Day Activities
Develop, test, and support data migration pipelines and data validation workflows supporting enterprise projects
Collaborate with data teams to translate business requirements into scalable and secure data solutions
Support data platform migrations, schema updates, and performance tuning activities supporting operational efficiency
Troubleshoot data discrepancies, performance bottlenecks, and security gaps supporting compliance and operational resilience
Automate data loading, transformation, and reconciliation workflows supporting continuous integration/delivery practices
Maintain detailed documentation for data schemas, workflows, migration processes, and operational procedures
Support ongoing data governance initiatives, data security, and compliance support activities
Qualifications
Bachelor’s or Master’s degree in Data Science, Computer Science, or a related field
10+ years supporting enterprise data management, large-scale data migrations, and data warehousing in regulated environments
Certifications supporting cloud data management or enterprise data governance are advantageous (e.g., Snowflake Data Engineer, AWS or GCP certifications)
Proven ability supporting complex data systems supporting high data volumes and enterprise compliance standards
Professional Competencies
Strong analytical and troubleshooting abilities supporting complex data processes and migration activities
Leadership skills to guide teams, enforce best practices, and support enterprise data standards
Effective stakeholder management and communication skills supporting project requirements and compliance reporting
Adaptability supporting evolving data standards, security protocols, and cloud environment enhancements
Strategic thinking to optimize data workflows, ensure data quality, and support enterprise analytics and compliance goals
Organizational skills to support multiple data migration projects, schema changes, and process improvements in a fast-paced environment
SYNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.