Senior Data Engineer (T-SQL & SSIS, Data Warehousing & ETL Specialist)

2 Hours ago • 5 Years +

Job Summary

Job Description

The Senior Data Engineer will lead and enhance data integration and warehousing initiatives by designing, developing, and optimizing complex ETL processes and database solutions. This role involves ensuring efficient data flow, maintaining data integrity, and facilitating actionable insights to support data-driven decision-making and operational excellence. Responsibilities include writing optimized T-SQL queries, managing data warehouse schemas, and collaborating with stakeholders.
Must have:
  • Proficiency in SQL Server and advanced T-SQL querying.
  • Expertise in SQL Server Integration Services (SSIS).
  • Deep understanding of data warehousing concepts and ETL best practices.
  • Experience in performance tuning and query optimization.
  • Hands-on experience with database security and compliance.
Good to have:
  • Experience with cloud platforms (Azure Data Factory, AWS Glue).
  • Knowledge of Azure SQL, Amazon RDS or other cloud-based data services.
  • Experience with scripting languages like PowerShell or Python.

Job Details

Job Summary

Synechron is seeking a highly skilled Senior Data Engineer specializing in T-SQL and SSIS to lead and advance our data integration and warehousing initiatives. In this role, you will design, develop, and optimize complex ETL processes and database solutions to support enterprise data needs. Your expertise will enable efficient data flow, ensure data integrity, and facilitate actionable insights, contributing to our organization’s commitment to data-driven decision-making and operational excellence.

Software Requirements

  • Required Skills:

    • Proficiency in SQL Server, advanced T-SQL querying, stored procedures, functions, and scripting
    • Expertise in SQL Server Integration Services (SSIS), including design, deployment, and troubleshooting
    • Deep understanding of data warehousing concepts, schema design, and ETL best practices
    • Experience in performance tuning, query optimization, and troubleshooting SQL and SSIS packages
    • Hands-on experience with database security, compliance, and data masking standards
    • Familiarity with source system analysis and complex data migration
  • Preferred Skills:

    • Experience with cloud platforms (Azure Data Factory, AWS Glue)
    • Knowledge of Azure SQL, Amazon RDS or other cloud-based data services
    • Experience with scripting languages like PowerShell or Python for automation

Overall Responsibilities

  • Design, develop, and maintain robust ETL workflows using SSIS to meet diverse data integration requirements
  • Write optimized, scalable T-SQL queries, stored procedures, and functions aligned with data quality standards
  • Develop and manage data warehouse schemas, tables, and relationships to support reporting and analytics
  • Ensure data accuracy, security, and compliance across all data processes
  • Collaborate closely with business analysts and other stakeholders to understand data requirements and translate them into technical solutions
  • Troubleshoot and resolve performance issues in SQL Server and SSIS packages
  • Document data workflows, schemas, and data mappings to support ongoing maintenance and audits
  • Participate in code reviews, performance tuning, and implementing best practices for ETL and database management
  • Support data migration projects and facilitate seamless data transfers between systems

Technical Skills (By Category)

  • Programming Languages:

    • Essential: T-SQL, SQL
    • Preferred: PowerShell, Python, or similar scripting languages for automation and scripting
  • Databases & Data Management:

    • Essential: SQL Server (2016 or higher), relational data modeling, ETL processes
    • Preferred: Azure SQL, Amazon RDS, or other cloud-based databases
  • Frameworks & Libraries:

    • Essential: SSIS (SQL Server Integration Services) packages and components
    • Preferred: Data analysis libraries (e.g., Pandas, Power BI integrations)
  • Development Tools & Methodologies:

    • Essential: SQL Server Management Studio (SSMS), Visual Studio, SQL Server Data Tools (SSDT), version control (Git)
    • Preferred: Azure Data Factory, DevOps pipelines, automated deployment tools
  • Design & Architecture:

    • Data warehouse schema design (star schema, snowflake)
    • Data flow and process automation best practices
  • Security & Compliance:

    • Basic understanding of database security, access control, and data masking standards

Experience Requirements

  • Minimum of 5+ years working in database development, data warehousing, or ETL processing
  • Proven experience designing and optimizing large-scale ETL workflows in enterprise environments
  • Demonstrated proficiency in writing complex T-SQL queries, stored procedures, and functions
  • Experience with SSIS, including package development, deployment, and troubleshooting
  • Background in data migration and data governance is preferred
  • Industry experience in financial services, banking, or large enterprise environments is advantageous
  • Alternative pathways include extensive hands-on experience or relevant professional training in ETL and database management

Day-to-Day Activities

  • Develop, test, and deploy robust ETL workflows using SSIS to meet business needs
  • Build and optimize T-SQL queries, stored procedures, and functions for performance and reliability
  • Analyze source system data structures, identify best-fit schemas, and design data warehouse models
  • Monitor and troubleshoot ETL processes, resolving performance bottlenecks and errors
  • Collaborate with stakeholders to gather requirements and translate them into technical designs
  • Review and optimize database performance and security configurations
  • Document data models, mappings, and processes for operational clarity
  • Engage in regular team meetings, code reviews, and process improvement initiatives

Qualifications

  • Bachelor’s degree or higher in Computer Science, Information Technology, or related field
  • Relevant certifications such as Microsoft Certified: Data Engineer or SQL Server certifications (preferred)
  • Proven track record of designing and maintaining enterprise data warehouses and ETL processes

Professional Competencies

  • Critical thinking and analytical skills to troubleshoot complex data issues
  • Strong communication skills for effective stakeholder engagement and documentation
  • Ability to work independently and collaboratively in a fast-paced environment
  • Adaptability to evolving data technologies and requirements
  • Results-oriented with excellent time and priority management
  • Commitment to continuous improvement and learning new data management techniques

S​YNECHRON’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.

Candidate Application Notice

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Bengaluru, Karnataka, India

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 43 offices in 18 countries within key global markets. For more information on the company, please visit our website: www.synechron.com.

Pune, Maharashtra, India (On-Site)

Mississauga, Ontario, Canada (Hybrid)

Hyderabad, Telangana, India (On-Site)

Chennai, Tamil Nadu, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Pune, Maharashtra, India (On-Site)

View All Jobs

Get notified when new jobs are added by Synechron

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug