SQL Server & Informatica ETL Developer

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:

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