Senior ETL Developer

Company DescriptionWelcome to RSNGINFO Solutions! Established in 2019, RSNGINFO is more than an IT software services company. We offer product development, Generative AI, data engineering, software consulting, cloud solutions, and offshore resourcing services. Our dedication to excellence and transformative partnerships sets us apart in the industry.

Job Description:We are looking for a senior ETL developer with minimum 7 years of experience. The candidate should be able to understand business requirement and provide complete solution, which includes Data Extraction from multiple heterogeneous sources, Transformation, Integration and data load. He\She should be in a position to lead a small team.

Mandatory Skills:Must have sound knowledge in SQL & SSISGood understanding of Stored Procedures, views, triggers, functions etc.,Strong knowledge in SQL & SSIS Performance tuning Able to perform QA & Code review developed by the teamCapable of understanding of existing data model (DW) and implementation of new data modelExperience in data profiling and data analysis Excellent communication and analytical skills Good to have:SQL DBA Activities (Backup, Restore, Partitioning, Job creating and monitoring etc.,) Knowledge on PowerBI, SSRS & SSAS Roles and Responsibilities:Develop, design, tune and maintain SSIS packages to perform the ETL processShould have strong knowledge on all SSIS components and able to handle diverse set of tasks using SSISExperience in data extraction from SQL, Oracle, Excel, SharePoint, flat files and other familiar data sourcesHands on experience in implementing Error re-direction, Error handling and logging. Capable of arriving solution to handle error/bad records Participate in data-modelling and database designingDesign and develop SQL Server stored procedures, functions, views and triggers used during the ETL processDesign and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data WarehouseDevelops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutionsDocuments ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.Integrates ETL development with existing projects to maximize object reuse.Creates, executes, and documents unit test plans for ETL and data integration processes and programsPerform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in productionTroubleshoot data issues and defects to determine root cause.Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniquesCapable of deploying SSIS solution in various environments and scheduling & monitoring of SQL jobsDebug and resolve technical issues occurring in Production, meeting the SLA on timeExperience in handling Client calls Individually

Key Skills

• CSS