Job Description
<p><p><b>Job Title :</b> ETL Developer with Experience in Airflow , Snowflake & Redshift.<br/><br/><b>Team :</b> Technology.<br/><br/><b>Work Location :</b> Coimbatore.<br/><br/><b>Job Summary :</b><br/><br/>We are looking for an experienced Senior ETL Developer with strong hands-on expertise in SSIS and SQL Server to join our data engineering team on a contract basis.<br/><br/>The selected candidate will be responsible for developing, optimizing, and maintaining robust ETL workflows that support business analytics and reporting needs.<br/><br/>This is a high-impact role for someone who thrives in a fast-paced, delivery-oriented environment and can work independently with minimal supervision.<br/><br/><b>Key Responsibilities :</b><br/><br/><b>Design and Development of ETL Workflows :</b><br/><br/>- Develop, enhance, and maintain robust SSIS packages to extract, transform, and load data from various sources (e.g., flat files, Excel, SQL Server, APIs).<br/><br/>- Implement complex business logic and transformation rules within SSIS.<br/><br/>- Design reusable components like configuration-driven packages, parameterized data flows, and modular templates.<br/><br/><b>Performance Optimization :</b><br/><br/>- Analyse and tune SSIS packages for performance (e.g., buffer sizes, data flow parallelism, lookup caching).<br/><br/>- Identify and resolve bottlenecks in ETL workflows.<br/><br/>- Use best practices for managing large volumes of data, including incremental loads and change data capture (CDC).<br/><br/><b>Data Quality and Validation :</b><br/><br/>- Implement data quality checks and validations within ETL pipelines.<br/><br/>- Create audit and control frameworks for monitoring completeness and accuracy of data movement.<br/><br/>- Handle data cleansing, deduplication, and standardization as part of transformation logic.<br/><br/><b>Error Handling and Logging :</b><br/><br/>- Build comprehensive logging and error-handling mechanisms within SSIS (e.g., event handlers, custom logs, notification alerts).<br/><br/>- Troubleshoot and debug failed packages or erroneous data movements effectively.<br/><br/><b>Deployment and Automation :</b><br/><br/>- Package and deploy SSIS solutions using tools like SSDT, MSBuild, and Azure DevOps or other CI/CD pipelines.<br/><br/>- Schedule and monitor ETL jobs using SQL Server Agent or enterprise schedulers.<br/><br/>- Maintain SSIS package versions and manage deployment across dev/test/prod environments.<br/><br/><b>Documentation and Technical Specifications :</b><br/><br/>- Document data flow logic, transformation rules, and package dependencies.<br/><br/>- Create and maintain technical specifications for ETL processes.<br/><br/>- Support knowledge transfer and onboarding of junior developers by maintaining updated documentation.<br/><br/><b>Collaboration and Stakeholder Communication :</b><br/><br/>- Work closely with data architects, DBAs, and business analysts to understand requirements and translate them into ETL solutions.<br/><br/>- Participate in requirement gathering sessions and contribute to solution design discussions.<br/><br/>- Provide estimations, timelines, and status updates for development activities.<br/><br/><b>Standards and Best Practices :</b><br/><br/>- Promote SSIS development standards including naming conventions, modularity, parameterization, and logging.<br/><br/>- Participate in code reviews to ensure maintainability and consistency.<br/><br/>- Continuously evaluate and apply improvements to coding and performance practices.<br/><br/><b>Required Skills & Experience :</b><br/><br/>- 6+ years of experience in ETL development using SSIS.<br/><br/>- Strong proficiency in SQL Server and advanced T-SQL scripting.<br/><br/>- Solid understanding of data warehousing principles, dimensional modeling (Kimball), and data integration patterns.<br/><br/>- Experience with job orchestration tools and schedulers (e.g., SQL Agent, Control-M, Azure Data Factory).<br/><br/>- Strong troubleshooting and performance optimization skills.<br/><br/>- Ability to work independently, meet deadlines, and communicate effectively with technical and business teams.<br/><br/><b>Preferred Skills :</b><br/><br/>- Exposure to cloud platforms like Azure Data Factory, Azure Synapse, or AWS Glue.<br/><br/>- Experience with reporting tools such as Power BI, SSRS, or Tableau.<br/><br/>- Previous experience working in healthcare, finance, or other regulated domains is a plus.<br/><br/>- Familiarity with version control tools (e.g., Git, Azure DevOps).<br/><br/>- Bachelors degree in Computer Science, Information Technology, or a related field.</p><br/></p> (ref:hirist.tech)