ETL Developer (US)

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

Benefits offered by this job

Flexible work opportunities

Career growth opportunities

Job summary

AVP Vigilant Technology Pvt Ltd is seeking an ETL Developer to design, develop, and maintain data integration solutions. The role emphasizes Informatica, SSIS, and SQL within data warehousing environments.

The ideal candidate has 2–6 years of ETL/Data Integration experience and will collaborate with analysts and engineers to ensure reliable, scalable data processing and governance.

Qualifications

• 2–6 years of ETL/Data Integration development experience.
• 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.

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

Tools

Informatica

SSIS

SQL Server

Oracle

Job description

ETL Developer

Experience: 2–6 Years

Locations: Dallas, TX | Chicago, IL | New York, NY | Atlanta, GA

Salary: $80,000–$155,000 per year

Job Summary

We are seeking a skilled ETL Developer to design, develop, and maintain reliable data integration and transformation solutions. The ideal candidate will have strong experience with Informatica, SSIS, and SQL and a solid understanding of data warehousing and ETL best practices.

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

Required Skills

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

Preferred Qualifications

• Experience with cloud data platforms such as AWS, Azure, or GCP.
• Knowledge of dimensional modeling and data warehouse architecture.
• Familiarity with Python or scripting.
• Experience with ETL scheduling and monitoring tools.
• Understanding of Agile/Scrum development methodologies.

What We Offer

• Competitive salary: $80K–$155K
• Career growth and professional development opportunities.
• Opportunity to work on enterprise-scale data and analytics projects.
• Collaborative and technology-focused work environment.
• Flexible work opportunities depending on role and location.

Skills: etl,data integration,sql,data warehousing