ETL Developer (Informatica/SSIS) | Data Warehouse Expert

AVP VIGILANT TECHNOLOGY PVT LTD; New York (NY); On-site; USD 80,000 - 155,000; Full time

Benefits offered by this job

Competitive salary

Career growth

Enterprise-scale projects

Collaborative environment

Flexible work options

Job summary

AVP Vigilant Technology Pvt Ltd is seeking an ETL Developer to design, develop, and maintain reliable data integration and transformation solutions. The ideal candidate will have 2–6 years of experience and strong hands-on skills with Informatica, SSIS, and SQL.

Locations include Dallas, TX; Chicago, IL; New York, NY; Atlanta, GA with a competitive salary of $80,000–$155,000 per year and opportunities for growth on enterprise-scale data projects.

Qualifications

• 2–6 years of experience in ETL/Data Integration development.
• Strong hands-on experience with Informatica.
• Experience with Microsoft SSIS.
• Advanced SQL skills.
• Understanding of ETL/ELT concepts and data warehousing.
• Experience working with relational databases such as SQL Server, Oracle, or similar.
• Strong analytical and problem-solving skills.
• Ability to work effectively in a collaborative team environment.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica and SSIS.
• Develop complex SQL queries, stored procedures, views, and data transformations.
• Extract, transform, and load data from multiple sources into data warehouses and databases.
• Perform data validation, reconciliation, and quality checks.
• Troubleshoot ETL failures and optimize data-processing performance.
• Work with business analysts, data engineers, and development teams to understand data requirements.
• Monitor scheduled ETL jobs and resolve production issues.
• Create technical documentation for ETL processes, mappings, and workflows.
• Follow data governance, security, and development standards.

Skills

ETL/Data Integration

Informatica

SQL

SSIS

Data warehousing

Analytical skills

Team collaboration

Tools

Informatica

SSIS

SQL Server

Job description

AVP Vigilant Technology Pvt Ltd is seeking an ETL Developer to design, develop, and maintain reliable data integration and transformation solutions. The ideal candidate will have 2–6 years of experience and strong hands-on skills with Informatica, SSIS, and SQL.

Locations include Dallas, TX; Chicago, IL; New York, NY; Atlanta, GA with a competitive salary of $80,000–$155,000 per year and opportunities for growth on enterprise-scale data projects.