-
›
- Careers ›
- Careers in India ›
-
Technical lead
Job Description
Technical lead
Job Summary
-
Location: Chennai
-
Project role: Technical lead
-
Qualification: B-Tech
-
Experience: 2.5-5 Years
-
Skills: MS SQL
-
No. of positions: 1
Job description:
We are seeking a skilled Data Engineer with experience in SQL Server Integration Services (SSIS) and SQL Server. The primary role will be support.Primary Responsibilities:1. Monitoring and Maintenance:- Continuously monitor data pipelines and ETL processes to ensure they are running efficiently and without errors.- Perform routine checks and maintenance tasks to prevent data flow disruptions.- Work as tier one support.2. Troubleshooting:- Quickly identify and resolve issues within data pipelines, including errors and data discrepancies.- Escalate complex issues to higher-level support or development teams as needed.3. Incident Management: - Log, track, and manage incidents and service requests related to data pipelines. - Provide timely updates to stakeholders on the status of incidents and resolutions.4. Collaboration:- Work closely with SMEs, data analysts, business analysts, and other stakeholders to understand data requirements and deliver appropriate solutions or reach out to higher-level support for guidance.5. Documentation and Reporting:- Document ETL processes and support documentation.- Generate reports and provide insights to support business decision-making processes.6. User Support:- Assist end-users with data-related inquiries and issues, providing clear and effective solutions.Good to have :1. Design and Development: - Develop and maintain ETL processes using SSIS to support data warehousing and business intelligence solutions. - Design, implement, and optimize complex SQL queries, stored procedures, and functions to extract, transform, and load data.Qualifications:- Bachelor s degree in Computer Science, Information Technology, or a related field.- Proven experience as a Data Engineer or in a similar role.- Expertise in SQL Server Integration Services (SSIS).- Should have working knowledge of data pipelines which deals with Flat files, SAP, SQL Server, Oracle and complex interfaces to various Enterprise applications.- Strong proficiency in SQL Server, PL/SQL, including T-SQL and stored procedures.- Familiarity with other ETL tools and data processing frameworks is a plus.- Excellent problem-solving skills and attention to detail.- Strong communication skills, both written and verbal.- Ability to work independently and as part of a team.
- To provide support for on call escalations and doing root cause analysis of given issue
- To independently resolve tickets within agreed SLA of ticket volume and time
- To adhere to quality standards, regulatory requirements and company policies
- Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts
- To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases