Role description

Primary Skills: Microsoft SSIS and SQL

Description:

- Minimum 5+ years of being in ETL Developer role.
- Development Experience in Microsoft SQL Server Programming (Stored Procedures, functions, views, triggers etc.)
- Proficient in SSIS Package Development (Control Tasks, Dataflow Components, package deployment model, Error Handling and Event Handing etc.)
- Good Experience in trouble shooting the production issues.
- Ability to balance what is strategically right with what is practically realistic
- Lead moderately complex initiatives and deliverables within technical domain environments
- Contribute to large scale planning of strategies
- Design, code, test, debug, and document for projects and programs associated with technology domain, including upgrades and deployments
- Review moderately complex technical challenges that require an in-depth evaluation of technologies and procedures
- Resolve moderately complex issues and lead a team to meet existing client needs or potential new clients' needs while leveraging solid understanding of the function, policies, procedures, or compliance requirements
- Collaborate and consult with peers, colleagues, and mid-level managers to resolve technical challenges and achieve goals
- Lead projects and act as an escalation point, provide guidance and direction to less experienced staff
- Excellent technical architecture skills, enabling the creation of future-proof, complex global solutions
- Enforce adherence to architectural standards/principles, global product-specific guidelines, usability design standards,



cost optimization, etc.

Positive to Have :

- Experience in SQL Server and MySQL.
- Development experience in SSIS
- Knowledge of Zappysys tool and JSON.

Roles & Responsibilities :

- Develop general and detailed design specifications for moderate to complex systems
- Design, develop and implement ETL/ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution
- Implement Data Analytics best practices in designing data modeling, ETL Pipelines, near time data solutions
- Perform design validation, reconciliation and error handling in data load processes
- Optimize SSIS Package execution and SQL execution to optimize data load performance
- Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer
- Can import and export files from FTP/SFTP
- Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data

Skills

etl,sql script,ssis,etl process, About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.

📌 Lead I - Data Engineering (Bengaluru)
🏢 UST
📍 Bengaluru