Software Engineer Data Warehouse

Requirements:

- English Level C1+ or B2+
- Be able to rotative schedule
- Bachelor of Systems Engineering, Computer Science or Related
- Minimum 5+ years' experience with star schemas, dimensional modeling, and extract transform load (ETL) design and development.
- Minimum 3+ year experience on Microsoft SSIS.
- Minimum 2+ year experience on Pentaho Data Integration.
- Expert in Data Warehouse life cycle methodologies and BI best practices.
- Expert tuning SQLqueries.
- Experience developing PL/SQL packages, procedures, views and triggers.
- Database Administration.
Expertise working with various databases (Oracle, SQL Server)
- Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.
- Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
- SSIS Advanced component experience required (transformation objects in data flow).
- Implementing ETL Packages using Data Transformation Services (DTS) and SSIS
- Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.
- The individual must have full technical knowledge for all phases of a software development lifecycle and must be able to analyze and solve complex problems in a dynamic environment.
- This individual must have good oral and written communication skills.
- This individual must have development experience with ETL tools.
- Nice to have: Python, Azure Data factory, AWS RDW, API and S3 buckets

**Responsibilities**:

- Work with Business Analysts to correlate business requirements to domain entities and data elements
- Design, develop and maintain an information architecture and conceptual models for industry specific domain area.
- Lead/key contributor for development using ETL solutions like Pentaho PDI, SSIS.
- Work independently in determining impacts to code as per the requirements updates and fixes required for fixing defects
- Develops data and metadata policies and procedures for cross-functional software development teams to build, maintain and leverage the data model, ensuring integration with customer and industry data standards.
- Work with Developers to design, implement and maintain scalable software solutions that use database structures designed and maintained by the Data Architect
- Review and evaluate database performance, risk and financial analysis feasibility studies
- Provides complete assessments of the technical characteristics of proposals and alternatives considered to optimize database performance.
- Reviews and assesses technical proposals requesting changes or upgrades to the existing databases.
- 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.
- Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for the development work.
**Salary**: ¢1,500,000.00 - ¢2,000,000.00 per month

**Education**:

- Bachelor's (required)
**Experience**:

- Minimum experience in Data Warehouse design: 5 years (required)

**Language**:

- English Level C1+ or B2+ (required)