IW
SSIS Lead Developer
Info Way Solutions LLC
🇨🇦 Canada
On-site
Staff / Principal
1 week ago
- SSIS
- ETL
- T-SQL
- SQL
- Visual Studio
- Git
- Azure DevOps
- Azure Data Factory
- Azure SQL
- Azure Synapse
- Azure
- Power BI
- SSRS
- CI/CD
- Agile
- Scrum
1 week ago
Job description:
Role: SSIS Lead
Client : Infosys
Location: Hyderabad
Job Summary
We are looking for an experiencedSSIS Lead Developer to lead the design, development, implementation, and support of enterprise-level ETL and data integration solutions. The ideal candidate will have strong hands-on expertise inSQL Server, SSIS, T-SQL, ETL development, data warehousing, and performance tuning, along with the ability to lead technical teams and work closely with business and technical stakeholders.
Key Responsibilities
- Lead the design, development, and implementation of complexETL solutions using SQL Server Integration Services (SSIS).
- Develop and maintain SSIS packages for extracting, transforming, validating, and loading data from multiple sources.
- Design efficientdata flows, control flows, transformations, lookups, joins, and error-handling processes.
- Develop complexT-SQL queries, stored procedures, functions, views, and triggers.
- Analyze and optimize SSIS packages and SQL queries for performance and scalability.
- Lead troubleshooting and resolution of production ETL and data integration issues.
- Monitor scheduled jobs, batch processes, and data pipelines and ensure successful execution.
- Implement logging, auditing, error handling, restartability, and data validation mechanisms.
- Work with data architects and business analysts to translate requirements into technical solutions.
- Perform code reviews and establish development standards and best practices for SSIS/ETL development.
- Mentor junior and mid-level developers and provide technical guidance to the team.
- Manage deployments of SSIS packages across development, QA, and production environments.
- Work withSSISDB, SQL Server Agent, SSDT/Visual Studio, and source-control/deployment processes.
- Prepare technical documentation, ETL specifications, data mappings, and support documentation.
- Participate in release planning, testing, deployment, and production support activities.
- 8+ years of experience inSQL Server / SSIS / ETL development.
- Strong hands-on experience withSQL Server Integration Services (SSIS).
- ExcellentT-SQL development skills.
- Strong experience with:
- SSIS Control Flow and Data Flow
- Lookup, Merge, Merge Join, Conditional Split, Derived Column and Aggregate transformations
- Execute SQL Task
- Script Task / Script Component
- Foreach Loop / Sequence Container
- Error handling and logging
- SSIS parameters, variables, configurations and expressions
- Strong knowledge ofSQL Server databases and relational database concepts.
- Experience withSQL Server Agent Jobs and scheduling.
- Strong experience inETL performance tuning and optimization.
- Experience with data warehousing concepts such asFact/Dimension tables, Star Schema, Slowly Changing Dimensions (SCD).
- Experience with production support and troubleshooting of enterprise ETL environments.
- Strong understanding of data quality, validation, reconciliation, and error-handling processes.
- Experience withSSISDB and package deployment.
- Experience withGit, Azure DevOps, or other source-control tools.
- Strong communication, leadership, analytical, and problem-solving skills.
- Experience withAzure Data Factory (ADF) and cloud-based ETL/data integration.
- Experience withAzure SQL Database / Azure Synapse.
- Experience migrating on-premises SSIS workloads to Azure.
- Knowledge ofPower BI, SSRS, or SSAS.
- Experience with CI/CD pipelines for SSIS deployments.
- Experience with Agile/Scrum methodologies.
- Knowledge of data governance and data security practices.
- Experience working with large-volume enterprise data environments.
- Ability to lead an SSIS/ETL development team.
- Conduct technical design discussions and code reviews.
- Provide estimates and technical solutions for complex requirements.
- Mentor developers and establish coding/development standards.
- Coordinate with project managers, architects, QA teams, DBAs, and business stakeholders.
- Take ownership of technical issues from analysis through resolution.
SSIS Lead Developer · Info Way Solutions LLC