SQL Server & Informatica ETL Developer

Wissen Technology; New York (NY); Hybrid; USD 180,000 - 240,000; Full time

Benefits offered by this job

Healthcare insurance

Disability insurance

Life Insurance

401K

Paid time off - 3 weeks

Immigration support

Remote office stipend

Certifications support

Additional cash incentives

Re-skilling opportunities

Job summary

Wissen Technology in New York City seeks an AVP/VP-level SQL Server & Informatica ETL Developer to design, develop, and optimize enterprise ETL pipelines. You will collaborate closely with data engineers, business analysts, and application teams in an Agile environment.

The role requires 5–7 years of SQL Server and Informatica PowerCenter experience, strong SQL tuning skills, and the ability to deliver scalable data solutions for enterprise clients. Hybrid work mode with 3 days onsite.

Qualifications

• 5–7 years of experience in SQL Server development and ETL.
• Strong experience with Microsoft SQL Server.
• 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 production issues.
• Experience working in Agile/Scrum environments.

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.
• 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.

Skills

SQL Server

ETL development

Informatica PowerCenter

SQL queries & procedures

Data integration

Agile/Scrum

Performance tuning

Data reconciliation

Team collaboration

Python scripting

Snowflake

Education

Graduate degree in CS/Engineering

Tools

Informatica PowerCenter

Microsoft SQL Server

Job description

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.

Title: AVP/VP

Location: NYC, USA.

Mode of Work: 3 days/week onsite

Required Experience: 5-7 years

Job 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.
• 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.
• 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 a top tier investment bank or another esteemed client.
• Perform other duties as needed

Your Education and Experience:

• We value candidates who can execute on our vision and help us build an industry-leading organization.
• Graduate-level degree in computer science, engineering, or related technical field
• Wissen embraces diversity and is an equal opportunity employer. We are committed to building a team that represents a variety of backgrounds, skills, and abilities. We believe that the more inclusive our team is, the better our work will be. All qualified applicants, including but not limited to LGBTQ+, Minorities, Females, the Disabled, and Veterans, are encouraged to apply.

The Wissen Group was founded in the year 2000. Wissen Technology, a part of Wissen Group, was established in the year 2015. Wissen Technology is a specialized technology company that delivers high-end consulting for diverse industries, including Banking, E-commerce, Telecom, Healthcare, Manufacturing, and Energy. We help clients build world‑class products. We have offices in the US, India (Bangalore, Hyderabad, Chennai, Gurugram, Mumbai, Pune), UK, Australia, Mexico, Vietnam, and Canada.

We empower businesses with a dynamic portfolio of services and accelerators tailored to today’s digital demands and based on future ready technology stack. Our services include Industry Leading Custom Software Development, AI-Driven Software Engineering, Generative AI & Machine Learning, Real-Time Data Analytics & Insights, Interactive Data Visualization & Decision Intelligence, Intelligent Process Automation, Multi-Cloud & Hybrid Cloud Strategies, Cross-Platform Mobile Experiences, CI/CD-Powered Agile DevOps, Automated Quality Engineering, and cutting‑edge integrations.

Certified as a Great Place to Work® for five consecutive years (2020-2025) and recognized as a Top 20 AI/ML vendor by CIO Insider, Wissen Group has delivered multimillion-dollar projects for over 20 Fortune 500 companies. Wissen Technology delivers exceptional value on mission‑critical projects through thought leadership, ownership, and reliable, high‑quality, on‑time delivery.

Our industry-leading technical expertise stem from the talented professionals we attract. Committed to fostering their growth and providing top‑tier career opportunities, Wissen ensures an outstanding experience and value for our clients and employees.

We Value:

• Perfection: Pursuit of excellence through continuous improvement.
• Curiosity: Fostering continuous learning and exploration.
• Respect: Valuing diversity and mutual respect.
• Integrity: Commitment to ethical conduct and transparency.
• Transparency: Open communication and trust.

Wissen Thought leadership: https://www.wissen.com/articles/

Employee Speak:

https://www.wissen.com/blog/we-work-on-highly-complex-technology-projects-here-is-how-it-changes-whom-we-hire/

Wissen: A Great Place to Work

https://www.wissen.com/blog/here-is-what-ownership-and-commitment-mean-to-wissenites/

A technology consultancy that drives digital innovation by connecting strategy and execution, helping global clients to strengthen their core technology.