Strong in of T-SQL SQL, ETL SSIS
· implementing end to end data SSIS integration solutions
· effectively building data transformations with SSIS, including importing data from files as well as moving data between database platforms
· following correct data standards and successfully solving data issues
· data cleansing between systems
· completing unit testing and system documentation for ETL processes
· Troubleshooting and problem-solving on existing SSIS components and enhance features
· Document designs and architect data maps, develop data quality components
· Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams
· Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes
· New development as scoped and requested by the business
· C# Scripts in SSIS
· Have a participated in all phases of Software Development Lifecycle (SDLC)
· SSIS deployment Process
· Building highly scalable, robust & fault-tolerant systems.
· Taking care of the complete ETL process.
· Improving data quality, reliability & efficiency of the individual components & the complete system.
· Creating data models to reduce system complexities and hence increase efficiency & reduce cost.
· Introducing new data management tools & technologies into the existing system to make it more efficient.
· Setting & achieving individual as well as the team goal.
· Cooperation with a team working in an Agile Methodlogy;
· Bitbucket and Jira Knowledge