ETL Developer

We are looking for a skilled ETL Developer with 1–5 years of experience in designing, developing, and maintaining data integration and transformation solutions. The ideal candidate should have hands-on experience with Informatica, SQL, SSIS, and ETL processes. You will be responsible for developing reliable data pipelines, integrating data from multiple sources, and ensuring data quality and consistency across enterprise systems.

Work Locations: Dallas, TX | New York City, NY | Chicago, IL

Employment Type: Full-Time

Work Arrangement: Hybrid – Candidates must be available to work from the designated office on scheduled days.

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica and SSIS.
• Extract, transform, and load data from multiple sources into target systems.
• Develop complex SQL queries, stored procedures, and database functions.
• Build and optimize data integration pipelines.
• Perform data cleansing, validation, and transformation.
• Monitor ETL jobs and troubleshoot failures.
• Optimize ETL workflows for performance and scalability.
• Work with relational databases and data warehouses.
• Ensure data accuracy, integrity, and consistency.
• Collaborate with Data Engineers, Business Analysts, and development teams.
• Prepare technical documentation and support production deployments.

Required Skills

• 1–5 years of experience as an ETL Developer or in a related role.
• Hands-on experience with Informatica PowerCenter or Informatica Cloud.
• Experience with SQL, including complex queries and stored procedures.
• Knowledge of SQL Server Integration Services (SSIS).
• Understanding of ETL/ELT processes and data warehousing concepts.
• Experience with data extraction, transformation, and loading.
• Knowledge of relational databases such as SQL Server, Oracle, or MySQL.
• Understanding of data mapping and data integration techniques.
• Strong debugging and problem-solving skills.
• Good communication and collaboration abilities.

Preferred Qualifications

• Experience with Informatica IICS.
• Knowledge of Snowflake, Azure Data Factory, or AWS Glue.
• Familiarity with data modeling and database optimization.
• Experience with scheduling and monitoring ETL jobs.
• Knowledge of Python or scripting languages.
• Understanding of cloud-based data integration solutions.
• Familiarity with Agile/Scrum methodologies and Git.

Education

Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field, or equivalent practical experience.

Compensation & Benefits

• Annual Salary: $80,000 – $155,000.
• Competitive compensation based on experience and technical expertise.
• Health, dental, and vision insurance.
• Paid vacation and holidays.
• Hybrid work flexibility.
• Professional development and career advancement opportunities.
• Collaborative and supportive work environment.

Application Process

Interested candidates are encouraged to apply with their updated resumes, highlighting their Informatica, SSIS, SQL, ETL development, data integration, and data warehousing experience.