ETL Developer

ENIN Systems, INC; Delaware; On-site; USD 120,000 - 160,000; Full time

Job summary

ENIN Systems, INC is seeking a Senior ETL Developer to design, develop, and maintain robust data integration solutions for complex data workloads in the US. You will partner with data architects, DBAs, and analysts to deliver scalable ETL pipelines and reliable data loads.

Ideal candidates bring 14+ years in ETL development, advanced SQL, and hands-on experience with Informatica PowerCenter/IICS, IBM DataStage, Talend, or SSIS, plus data warehousing concepts and data quality practices.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 14+ years of experience in ETL development, data integration, or data engineering.
• Strong experience with one or more ETL tools, such as Informatica PowerCenter, Informatica IICS, IBM DataStage, Talend, or SSIS.
• Advanced knowledge of SQL, including complex joins, subqueries, analytical functions, and query optimization.

Responsibilities

• Design, develop, test, and maintain ETL workflows for extracting, transforming, and loading data from multiple source systems.
• Develop complex SQL queries, stored procedures, functions, and performance-optimized database scripts.
• Build and maintain data pipelines for data warehouses, data marts, and reporting platforms.
• Work with ETL tools such as Informatica PowerCenter, Informatica IICS, IBM DataStage, Talend, or Microsoft SSIS.
• Collaborate with data architects, business analysts, DBAs, developers, QA, and stakeholders.
• Monitor scheduled ETL jobs and ensure data availability, accuracy, completeness, and consistency.
• Provide technical guidance and mentorship to junior ETL developers.

Skills

ETL Development

Informatica / DataStage / Talend / SS

Advanced SQL

Data Warehousing

Data Modeling

Unix/Linux scripting

Git / SVN

Communication

Education

Bachelor's degree in CS/IT/Engineering

Tools

Informatica PowerCenter

Informatica IICS

IBM DataStage

Talend

SQL Server

Oracle

Teradata

Job description

We are seeking an experienced Senior ETL Developer to design, develop, implement, and maintain robust data integration and data transformation solutions. The ideal candidate will have strong expertise in ETL processes, data warehousing, SQL, and ETL tools such as Informatica, Talend, DataStage, or SSIS. The candidate will collaborate with data architects, business analysts, database administrators, and other technical teams to deliver reliable, scalable, and high-quality data solutions.

Key Responsibilities:

• Design, develop, test, and maintain ETL workflows for extracting, transforming, and loading data from multiple source systems.
• Develop complex SQL queries, stored procedures, functions, and performance-optimized database scripts.
• Build and maintain data pipelines for data warehouses, data marts, and reporting platforms.
• Work with ETL tools such as Informatica PowerCenter, Informatica IICS, IBM DataStage, Talend, or Microsoft SSIS.
• Analyze business and technical requirements and translate them into effective ETL solutions.
• Perform data profiling, data cleansing, data validation, reconciliation, and quality checks.
• Optimize ETL jobs, SQL queries, and data processing workflows to improve performance and scalability.
• Troubleshoot data integration issues, resolve production defects, and perform root‑cause analysis.
• Develop and maintain technical documentation, mapping specifications, data flow diagrams, and operational procedures.
• Collaborate with data architects, business analysts, developers, QA teams, and stakeholders.
• Support data migration, data conversion, and integration projects across multiple platforms.
• Implement error handling, logging, auditing, and recovery mechanisms for ETL processes.
• Participate in code reviews, unit testing, system integration testing, and deployment activities.
• Monitor scheduled ETL jobs and ensure data availability, accuracy, completeness, and consistency.
• Follow data governance, security, compliance, and development standards.
• Provide technical guidance and mentorship to junior ETL developers.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 14+ years of experience in ETL development, data integration, or data engineering.
• Strong experience with one or more ETL tools, such as Informatica PowerCenter, Informatica IICS, IBM DataStage, Talend, or SSIS.
• Advanced knowledge of SQL, including complex joins, subqueries, analytical functions, and query optimization.
• Strong experience with relational databases such as Oracle, SQL Server, PostgreSQL, or Teradata.
• Experience with data warehousing concepts, dimensional modeling, star schemas, snowflake schemas, and slowly changing dimensions (SCD).
• Experience developing complex ETL mappings, workflows, transformations, and reusable components.
• Knowledge of data migration, data quality, data profiling, and data reconciliation techniques.
• Experience with performance tuning and troubleshooting large‑volume data processing jobs.
• Familiarity with Unix/Linux shell scripting and job scheduling tools.
• Experience with version control systems such as Git or SVN.
• Strong analytical, problem‑solving, communication, and collaboration skills.

Preferred Qualifications:

• Experience with cloud‑based data platforms such as AWS, Microsoft Azure, or Google Cloud Platform.
• Knowledge of cloud data warehouses such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse Analytics.
• Experience with big data technologies such as Apache Spark, Hadoop, or Kafka.
• Familiarity with Python, PySpark, or other scripting languages for data processing and automation.
• Understanding of CI/CD pipelines, automated testing, and ETL deployment practices.
• Experience with Agile/Scrum methodologies and enterprise data integration projects.
• Knowledge of metadata management, master data management (MDM), and data governance frameworks.

Key Skills:

• ETL Development and Data Integration
• Informatica / DataStage / Talend / SSIS
• Advanced SQL and Database Programming
• Data Warehousing and Data Modeling
• Data Migration and Data Transformation
• ETL Performance Tuning
• Data Quality and Validation
• Production Support and Troubleshooting
• Technical Documentation
• Team Collaboration and Mentoring

Soft Skills

• Strong analytical and critical‑thinking abilities.
• Excellent problem‑solving and troubleshooting skills.
• Effective written and verbal communication.
• Ability to work independently and manage multiple priorities.
• Strong attention to detail and commitment to data accuracy.
• Ability to collaborate with cross‑functional and distributed teams.

Success Criteria

• Delivery of reliable, scalable, and high‑performance ETL pipelines.
• Improved data quality, consistency, and processing efficiency.
• Timely resolution of production issues and data discrepancies.
• Successful delivery of data integration and migration initiatives.
• Compliance with technical standards, data governance, and security requirements.