ETL Developer

Role Overview

Experience

Education

Key Responsibilities

• Design and implement data ingestion pipelines and ETL processes using SSIS, Informatica BDM, or native tools to meet functional and non-functional business requirements.
• Create and manage data workflows using orchestration tools such as Control-M to ensure scalability, optimize data delivery, and automate manual processes.
• Ensure data quality, integrity, and consistency across all systems to enable trusted data for decision-making.
• Develop complex T-SQL and PL/SQL queries, stored procedures, and scripts for data transformation and integration.
• Monitor performance and recommend configuration or infrastructure improvements to enhance efficiency and reliability.
• Troubleshoot and resolve high-impact data issues through in-depth analysis of business and system processes.
• Design logical and physical data models to support enterprise data architecture.
• Establish and enforce standards for coding, testing, debugging, and implementation of ETL solutions.
• Collaborate with stakeholders across multiple functions to understand business processes and data requirements.
• Support ETL and BI teams in development and troubleshooting data-related issues; advise on efficient data extraction for reporting and analytics.

Required Qualifications

• 8–10 years of experience in ETL development and data engineering, preferably with SSIS, Informatica BDM, SSAS, SQL Server, Oracle, and semi-/unstructured data.
• Proven experience in solution engineering, data modeling, and operations.
• Hands-on experience with orchestration tools (e.g., Control-M) and data quality frameworks.
• Familiarity with Hadoop distributions (Cloudera, MapR, Hortonworks) is a plus.
• Strong T-SQL and PL/SQL skills with ability to optimize and tune queries and ETL jobs.

Technical Skills

• **ETL Tools:**

SSIS, Informatica BDM

• **Databases:**

SQL Server, Oracle, Vertica, NoSQL

• **Data Modeling:**
• Logical and physical data modeling
• **Big Data & Cloud:**

Cloudera, Azure, Snowflake, HDFS, Spark

• **BI Tools:**

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication and collaboration skills
• Ability to work in a fast-paced environment and manage multiple priorities
• Proactive ownership mindset with strong attention to detail and documentation

Key Performance Indicators (KPIs)

• ETL job success rate and SLA adherence
• Data pipeline throughput and latency improvements
• Number of incidents resolved and mean time to recovery (MTTR)
• Query and job performance tuning impact (e.g., runtime reduction)
• Data quality metrics (completeness, consistency, accuracy)