SQL Server & Informatica ETL Developer

About the job

The Wissen team continues to expand its footprint in the USA, Canada, UK, Australia, and India. More openings to come as we continue to grow the team!

Please read below for a brilliant career opportunity.

Role: SQL Server & Informatica ETL Developer

Title: AVP/VP

Location: NYC, USA.

Mode of Work: 3 days/week onsite

Required Experience: 5-7 years

Job Overview:

Role Overview

We are seeking a highly motivated SQL Server & Informatica ETL Developer with strong expertise in SQL Server development, ETL implementation using Informatica, and enterprise data integration. The ideal candidate will design, develop, optimize, and support scalable ETL solutions while working closely with business users, data engineers, and application development teams in an Agile environment.

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.
• Develop complex SQL queries, stored procedures, views, triggers, and functions in Microsoft SQL Server.
• Design and optimize database objects for high-performance enterprise applications.
• Analyze business requirements and translate them into scalable ETL and database solutions.
• Perform data extraction, transformation, and loading from multiple heterogeneous data sources.
• Troubleshoot ETL failures, SQL performance issues, and production incidents.
• Optimize ETL workflows and SQL queries for improved throughput and scalability.
• Perform data reconciliation and validation to ensure data accuracy and integrity.
• Collaborate with business analysts, developers, QA teams, and production support teams.
• Participate in Agile ceremonies including sprint planning, stand-ups, retrospectives, and code reviews.
• Support production deployments and resolve critical production issues.
• Maintain technical documentation, ETL mapping specifications, and deployment procedures.
• Follow enterprise coding standards, security guidelines, and best practices.

Required Qualifications

• 5–7 years of experience in SQL Server development and ETL.
• Strong experience with Microsoft SQL Server.
• Extensive experience developing Stored Procedures, Views, Functions, Triggers Complex SQL Queries.
• Strong hands-on experience with Informatica PowerCenter.
• Experience designing and developing enterprise ETL pipelines.
• Strong SQL performance tuning and query optimization skills.
• Experience troubleshooting ETL jobs and resolving production issues.
• Good understanding of relational database concepts and data modeling.
• Experience with data reconciliation and data validation.
• Experience working in Agile/Scrum environments.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration skills.

Preferred Skills

• Experience with Python scripting for data processing or automation.
• Experience with Snowflake.
• Familiarity with AI-powered development tools (e.g., GitHub Copilot, ChatGPT, Cursor).
• Knowledge of AI-assisted software development practices.

Benefits:

• Healthcare insurance for you and your family (medical, dental, vision).
• Short / Long term disability insurance.
• Life Insurance.

Accidental death & disability Insurance.

• 401K.
• 3 weeks of Paid Time Off.
• Support and fee coverage for immigration needs.
• Remote office set up stipend.
• Support for industry certifications.
• Additional cash incentives.
• Re-skilling opportunities to transition between technologies.

Schedule: Monday to Friday

Work Mode: Hybrid

Job Type: Full-time

We are: A high end technical consulting firm built and run by highly qualified technologists. Our workforce consists of 5000+ highly skilled professionals, with leadership from Wharton, MIT, IITs, IIMs, and NITs and decades of experience at Goldman Sachs, Morgan Stanley, MSCI, Deutsche Bank, Credit Suisse, Verizon, British Telecom, ISRO etc. Without any external funding or investments, Wissen Technology has grown its revenues by 100% every other year since it started as a subsidiary of Wissen Group in 2015. We have a global presence with offices in the US, India, UK, Australia, Mexico, and Canada.

You are: A true tech or domain ninja. Or both. Comfortable working in a quickly growing profitable startup, have a “can do” attitude and are willing to take on any task thrown your way.

You will:

• Develop and promote the company’s culture of engineering excellence.
• Define, develop and deliver solutions at …