ETL/Data Warehousing Specialist - SSIS (5-12 Yrs) Hyderabad (Systems/Product Software)

Position Accountability /Job Duties : - Performs roles of - Back-end ETL Application Developer- - Develops and maintain ETL (Extract, Transform and Load) applications using ETL Tools - Assists with the data warehouse logical and physical design - Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
-Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems - Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
-Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
-Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
-Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
-Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
-Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
-Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts. Position Responsibilities : - Responsible for the safety issues related to the job.
-Responsible for the confidentiality of information that they access to or came across during their work at the IMC.
-Responsible for complying with the hospital code of conduct and the patient and family rights standards. Expertise Skills : - Strong Software engineering skills, with the knowledge and experience of major application development methodologies.
-Excellent presentation, communication and consulting skills.
-Experienced with relational and dimensional data models as well as the ETL process.
-Hands on experience in Microsoft SQL Server, Oracle and any Business Intelligence and Data Warehousing Tool.
-Strong verbal and written communication skills, including technical documentation.
-Strong skills in using any BI or reporting tool.
-Ability to write documentation and collect users requirements

Required Skills : English