Title: Executive, MIS
Company Name: Labaid Pharmaceuticals Ltd.
Vacancy: --
Age: at most 30 years
Location: Dhaka (GULSHAN 1)
Salary: Negotiable
Experience:
∎ At least 2 years
Published: 28 Feb 2024
Education:
∎ BSc/ MSc in CS/ CSE
Requirements:
Additional Requirements:
∎ Age at most 30 years
∎ Pharmaceutical Experience is highly preferable
Responsibilities & Context:
∎ Requirements Analysis: Collaborating with business analysts and stakeholders to understand data integration requirements. Translating business requirements into technical specifications for SSIS packages.
∎ SSIS Package Design: Designing SSIS packages to extract data from source systems, transform it, and load it into destination systems. Creating workflows and tasks to handle data transformations and manipulations.
∎ Data Extraction: Developing SSIS packages to efficiently extract data from various source systems, such as databases, flat files, or APIs. Implementing incremental or full data extraction strategies as needed.
∎ Data Transformation: Defining and implementing data transformations to convert, clean, and enrich data during the ETL process. Handling data validation and error handling within SSIS packages.
∎ Data Loading: Configuring SSIS packages to load transformed data into target databases or data warehouses. Optimizing loading processes for performance and scalability.
∎ Data Modeling: Designing and implementing data models that represent the structure of the data warehouse. Developing conceptual, logical, and physical data models to support business requirements.
∎ Data Integration: Integrating data from various sources to create a unified and coherent view in the data warehouse. Managing data integration tools and technologies.
∎ Package Deployment and Execution: Deploying SSIS packages to production environments. Scheduling and monitoring the execution of SSIS packages to ensure timely and accurate data processing.
∎ Cloud Computing: Working on Azure Environment and Deploying SSIS packages to Azure.
∎ Metadata Management: Managing metadata to document and describe data within the data warehouse. Ensuring that metadata is accurate, up-to-date, and accessible to users.
∎ Error Handling and Logging: Implementing robust error handling mechanisms within SSIS packages. Setting up logging to capture information on package execution, errors, and warnings.
∎ API Design: Designing and architecting APIs to ensure they meet scalability, performance, and security requirements. Defining the API endpoints, data formats, authentication mechanisms, and communication protocols.
∎ API Testing: Skilled in tools like Postman, evaluating functionality, security, and performance to ensure the reliability, and effectiveness of developed API
∎ Performance Optimization: Identifying and optimizing performance bottlenecks in SSIS packages. Fine-tuning package configurations and settings for optimal ETL performance.
∎ Version Control: Managing version control for SSIS packages to ensure traceability and rollback capabilities. Collaborating with development teams to integrate SSIS packages into broader application development processes.
∎ Documentation: Creating and maintaining documentation for SSIS packages, including design specifications, deployment guides, and change logs. Documenting data flow diagrams and dependencies
∎ Labaid Pharmaceuticals Ltd, a leading vision driven company has started its journey to be a global player in the pharmaceuticals arena in short span of time. The strategic pillar of Labaid Pharma is to provide highest quality medicines from its world standard manufacturing plant that make the most meaningful difference for the patients and add value to our stakeholders and society. To reach our destination we are in search of talented, motivated and result oriented candidates for the mentioned position.
∎ Job Responsibilities:
∎ Requirements Analysis: Collaborating with business analysts and stakeholders to understand data integration requirements. Translating business requirements into technical specifications for SSIS packages.
∎ SSIS Package Design: Designing SSIS packages to extract data from source systems, transform it, and load it into destination systems. Creating workflows and tasks to handle data transformations and manipulations.
∎ Data Extraction: Developing SSIS packages to efficiently extract data from various source systems, such as databases, flat files, or APIs. Implementing incremental or full data extraction strategies as needed.
∎ Data Transformation: Defining and implementing data transformations to convert, clean, and enrich data during the ETL process. Handling data validation and error handling within SSIS packages.
∎ Data Loading: Configuring SSIS packages to load transformed data into target databases or data warehouses. Optimizing loading processes for performance and scalability.
∎ Data Modeling: Designing and implementing data models that represent the structure of the data warehouse. Developing conceptual, logical, and physical data models to support business requirements.
∎ Data Integration: Integrating data from various sources to create a unified and coherent view in the data warehouse. Managing data integration tools and technologies.
∎ Package Deployment and Execution: Deploying SSIS packages to production environments. Scheduling and monitoring the execution of SSIS packages to ensure timely and accurate data processing.
∎ Cloud Computing: Working on Azure Environment and Deploying SSIS packages to Azure.
∎ Metadata Management: Managing metadata to document and describe data within the data warehouse. Ensuring that metadata is accurate, up-to-date, and accessible to users.
∎ Error Handling and Logging: Implementing robust error handling mechanisms within SSIS packages. Setting up logging to capture information on package execution, errors, and warnings.
∎ API Design: Designing and architecting APIs to ensure they meet scalability, performance, and security requirements. Defining the API endpoints, data formats, authentication mechanisms, and communication protocols.
∎ API Testing: Skilled in tools like Postman, evaluating functionality, security, and performance to ensure the reliability, and effectiveness of developed API
∎ Performance Optimization: Identifying and optimizing performance bottlenecks in SSIS packages. Fine-tuning package configurations and settings for optimal ETL performance.
∎ Version Control: Managing version control for SSIS packages to ensure traceability and rollback capabilities. Collaborating with development teams to integrate SSIS packages into broader application development processes.
∎ Documentation: Creating and maintaining documentation for SSIS packages, including design specifications, deployment guides, and change logs. Documenting data flow diagrams and dependencies
∎ Job Location: Head Office, Gulshan-1, Dhaka-1212
Compensation & Other Benefits:
∎ As per company policy
Employment Status: Full Time
Job Location: Dhaka (GULSHAN 1)
Read Before Apply:
[Only non-smokers can apply]
Candidates are requested to send CV with recent photograph to Human Resources, Labaid Pharmaceuticals Ltd., Head Office : Bay Tower (Level 2), House : 23, Gulshan Avenue, Gulshan-1 Dhaka-1212, Bangladesh by not later than 6th March, 2024.
Please don't apply if you do not have the before mentioned requirements
Source: bdjobs.com