SQL Server / ETL Developer

$115,000 - $120,000/Yr

Synechron - New York, NY

Full-time - Mid Level

New York, NY

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The SQL Server / ETL Developer at Synechron is responsible for designing, developing, and maintaining ETL processes to ensure efficient data integration and transformation. This role involves collaboration with data analysts, data architects, and other stakeholders to support data warehousing and analytics initiatives, utilizing SQL Server and Informatica as primary tools.

Responsibilities

• Design, develop, and implement ETL processes using Informatica to extract data from various sources, transform it, and load it into SQL Server data warehouses.
• Collaborate with data architects and business stakeholders to understand data requirements and translate them into technical specifications.
• Optimize ETL workflows for performance, ensuring efficient data processing and load times.
• Monitor and maintain ETL processes, troubleshoot issues, and perform root cause analysis to ensure data integrity and reliability.
• Create and maintain documentation of ETL processes, including design specifications, data mappings, and operational procedures.
• Develop and execute test plans to validate ETL processes and ensure data quality.
• Stay current with industry best practices and emerging technologies to enhance ETL processes and toolsets.
• Provide support for data governance and quality initiatives.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as an ETL Developer, with a strong focus on SQL Server and Informatica.
• Proficient in SQL, with the ability to write complex queries, stored procedures, and functions.
• Experience in data modeling, data warehousing concepts, and dimensional modeling.
• Familiarity with data integration and transformation patterns and ETL best practices.
• Understanding of performance tuning techniques for SQL Server databases.
• Knowledge of automation tools and scripting languages (e.g., PowerShell, Python) is a plus.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and collaboration skills.

Nice-to-haves

• Experience with other ETL tools or data integration platforms.
• Familiarity with cloud-based data services (e.g., Azure, AWS).
• Knowledge of programming languages (e.g., Java, C#) is beneficial.

Benefits

• A highly competitive compensation and benefits package
• A multinational organization with 55 offices in 20 countries and the possibility to work abroad
• Laptop and a mobile phone
• 10 days of paid annual leave (plus sick leave and national holidays)
• Maternity & Paternity leave plans
• A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
• Retirement savings plans
• A higher education certification policy
• Commuter benefits (varies by region)
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
• Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms
• A flat and approachable organization
• A truly diverse, fun-loving and global work culture