ETL Developer - Data Warehousing (Informatica/SSIS)

AVP VIGILANT TECHNOLOGY PVT LTD; Atlanta (GA); On-site; USD 80,000 - 155,000; Full time

Job summary

AVP Vigilant Technology Pvt Ltd is seeking an ETL Developer to design, develop, and maintain data integration and transformation solutions across enterprise data warehouses. The ideal candidate has hands-on experience with Informatica, SSIS, and SQL, and a solid understanding of ETL/ELT best practices.

Location options include Dallas, TX; Chicago, IL; New York, NY; and Atlanta, GA. The role offers a competitive salary range of $80,000 to $155,000 per year, with a focus on reliable data

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

SSIS

SQL

Data warehousing

Relational databases

Analytical skills

Team collaboration

Job description

AVP Vigilant Technology Pvt Ltd is seeking an ETL Developer to design, develop, and maintain data integration and transformation solutions across enterprise data warehouses. The ideal candidate has hands-on experience with Informatica, SSIS, and SQL, and a solid understanding of ETL/ELT best practices.

Location options include Dallas, TX; Chicago, IL; New York, NY; and Atlanta, GA. The role offers a competitive salary range of $80,000 to $155,000 per year, with a focus on reliable data