Job Title: ETL Developer
Job Summary: We are seeking a skilled ETL (Extract, Transform, Load) Developer to design, develop, and maintain data integration solutions that support business intelligence, analytics, and data warehousing initiatives. The ideal candidate will have experience working with large datasets, data pipelines, and ETL tools to ensure accurate, efficient, and reliable data movement across enterprise systems.
Key Responsibilities: - Design, develop, test, and maintain ETL processes and data integration workflows.
- Extract data from various source systems, transform it according to business requirements, and load it into data warehouses or data marts.
- Develop and optimize data pipelines to ensure efficient data processing and delivery.
- Perform data validation, cleansing, and quality assurance activities.
- Troubleshoot and resolve ETL job failures, performance bottlenecks, and data discrepancies.
- Collaborate with Data Analysts, Data Engineers, Business Analysts, and stakeholders to understand data requirements.
- Create and maintain technical documentation, data mappings, and process workflows.
- Monitor ETL jobs and ensure adherence to Service Level Agreements (SLAs).
- Support database migrations, upgrades, and data warehouse enhancements.
- Implement best practices for data governance, security, and compliance.
Required Skills: - Strong understanding of ETL concepts, data warehousing, and data modeling.
- Experience with data extraction, transformation, and loading techniques.
- Knowledge of relational databases and SQL query optimization.
- Strong analytical and problem-solving skills.
- Experience handling large volumes of structured and unstructured data.
- Excellent communication and documentation skills.
Technical Skills: - ETL Tools: Informatica PowerCenter, SSIS, Talend, DataStage, Pentaho
- Databases: SQL Server, Oracle, MySQL, PostgreSQL, Snowflake
- Query Languages: SQL, PL/SQL, T-SQL
- Data Warehousing: Star Schema, Snowflake Schema, Dimensional Modeling
- Big Data Technologies: Hadoop, Spark, Hive (preferred)
- Cloud Platforms: AWS, Azure, GCP
- Data Integration Services: AWS Glue, Azure Data Factory
- Scripting Languages: Python, Shell Scripting
- Version Control: Git, GitHub, GitLab
Qualifications: - Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
- Relevant certifications in ETL, cloud platforms, or database technologies are a plus.
Experience: - 3-7 years of experience in ETL Development, Data Integration, or Data Warehousing.
- Hands-on experience with ETL tools such as Informatica, SSIS, Talend, or DataStage.
- Experience working with enterprise data warehouses and large-scale datasets.
- Familiarity with Agile/Scrum methodologies.
Preferred Qualifications: - Experience with cloud-based data platforms such as Snowflake, Redshift, BigQuery, or Azure Synapse.
- Knowledge of Data Lake architectures and modern data pipelines.
- Experience with real-time data processing and streaming technologies such as Kafka.
- Understanding of Master Data Management (MDM) and Data Governance frameworks.
- Experience with BI tools such as Power BI, Tableau, or QlikView.
Preferred Qualities: - Strong attention to detail and data accuracy.
- Ability to work independently and collaboratively in a team environment.
- Excellent troubleshooting and performance optimization skills.
- Strong organizational and time-management abilities.
- Passion for data, analytics, and continuous learning.
Employment Type: Full-Time
Location: Remote / Hybrid / On-site
Nice to Have: - Experience with modern ELT tools such as dbt, Fivetran, or Matillion.
- Knowledge of machine learning data pipelines and analytics platforms.
- Experience supporting enterprise reporting and business intelligence solutions.
- Familiarity with DevOps practices and CI/CD for data engineering.
- Experience working in domains such as Healthcare, Finance, Retail, HR Tech, or SaaS applications.
