ETL Developer

Overview

Key Responsibilities

• Design and implement ETL/data ingestion pipelines using SSIS, Informatica BDM or native tooling to meet functional and non‑functional requirements.
• Create and manage data workflows in orchestration tools (e.g., Control‑M); automate jobs and ensure scalable scheduling.
• Ensure data quality, integrity and consistency across systems to enable trusted reporting and analytics.
• Develop and optimize complex T‑SQL and PL/SQL queries, stored procedures and transformation scripts.
• Monitor pipeline and database performance; recommend configuration or infrastructure changes to improve efficiency and reliability.
• Troubleshoot and resolve high‑impact data issues via root‑cause analysis of business and system processes.
• Design logical and physical data models supporting enterprise data architecture.
• Establish and enforce coding, testing, debugging and deployment standards for ETL solutions.
• Collaborate with business and technical stakeholders to gather data requirements and translate them into ETL designs.
• Support and mentor ETL/BI developers; advise on efficient data extraction for reporting and analytics.

Requirements

• 8–10 years’ experience in ETL development/data engineering with hands‑on SSIS and Informatica BDM.
• Strong expertise in T‑SQL and PL/SQL; proven ability to optimize and tune queries and ETL jobs.
• Experience with orchestration tools (e.g., Control‑M) and data quality frameworks.
• Solid background in solution engineering, data modeling (logical & physical) and operations.
• Familiarity with SQL Server, Oracle; exposure to Vertica, NoSQL and semi/unstructured data.
• Experience or exposure to Hadoop distributions (Cloudera, MapR, Hortonworks) and big‑data/cloud technologies (Azure, Snowflake, HDFS, Spark) is a plus.
• Experience with BI tools such as Power BI or IBM Cognos is advantageous.
• Strong analytical, communication and collaboration skills; able to manage priorities in a fast‑paced environment.
• Bachelor’s degree in Computer Science, MIS or related field.

Preferred (Optional)

• Microsoft Certified: Azure Data Engineer Associate.
• Informatica Cloud/BDM Professional.