Job Description :

- To analyse the user requirements (new / change requests) and develop solutions for ETL implementation.

- To follow the Microsoft framework

- To understand the existing data source setup and plan for ETL using SSIS and SQL server.

- Implementing and maintaining ETL process in platform recommended by client using SSIS

- Monitoring performance of the ETL jobs in Platform and provide recommendations (where necessary)

- To perform batch and real time production support

- Design, develop, and maintain SQL Server databases, stored procedures, functions, and triggers

- Optimize complex T-SQL queries for performance and scalability

- Perform data analysis, data migration, and transformation

- Build and maintain ETL processes (SSIS preferred)

- Collaborate with developers and analysts to meet project goals

- Ensure data security, consistency, and best practices

- SSIS experience ingesting and doing complex transformations.

- Create and maintain data dictionaries, which are a comprehensive set of data definitions and metadata that provide context and understanding of the organizations data assets

- Ensure that the data is accurate, consistent, and reliable across the organization. This includes establishing data quality metrics and monitoring data quality on an ongoing basis

- Work closely with other IT professionals, including database administrators, data analysts, and developers, to ensure that the organizations data architecture is integrated and aligned with other IT systems and applications

- Stay up to date with new technologies and trends in data management and architecture and evaluate their potential impact on the organizations data architecture

- Generates application documentation.

- Contributes to systems analysis and design.

- Designs and develops moderately complex applications.

- Contributes to integration builds.

- Contributes to maintenance and support.

Requirements :

- Experience in ETL by analyzing source data and providing transformation logic

- Experience in SSIS for ETL implementation. Min 1-2 years of SSIS experience and the candidate should be willing to work on SSIS (Mandatory).

- Experience in DBs like SQL server

- Experience in writing scripts for transformation if required

- Experience in suggesting tools for clients new requirement

- Provide support for production runs and improve performance if required