Design, develop and maintain SSIS Packages with other BI Major/Minor enhancement projects and contribute skills to project as and when required.
Lead planning and implementation of ETL projects. Job holder will actively participate in the requirement gathering & analysis, design and understanding of end-to-end ETL solution architectures, testing and implementation phases enabling performance of the entire platform.
Responsible for reviewing ETL mapping / workflows and actively engage in design discussions for all Business Intelligence and database initiatives. Should be well adapt to develop and execute database queries and conduct analysis.
Work with IT project manager to determine project missions, goals, tasks, timelines and resource requirements; manage the overall Project Plan; resolve or assist in the resolution of conflicts within and between BI projects or functional areas; develop methods to monitor projectβs overall progress; and provide corrective supervision if necessary.
Present verbal and written reports defining plans, problems, and resolutions to appropriate levels of management during the project life cycle; Identify critical success factors and mitigate risks to the project during its lifecycle.
Working Knowledge of Azure Data factory tools, creating pipelines, Scheduling, package configuration is essential
Minimum of 5 years of experience in SSIS
Banking experience highly desirable
Minimum Bachelors in Computer Science
Expertise in SSIS, BI, SQL