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
ARMPL