Chennai

2.5-5 Years

INDIA

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. (1.) To provide support for on call escalations and doing root cause analysis of given issue (2.) To independently resolve tickets within agreed SLA of ticket volume and time (3.) To adhere to quality standards, regulatory requirements and company policies (4.) Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts (5.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases

B-Tech

1

Application Operations-Database-MS SQL

1450573BR