Software Engineer Ii

The Software Engineer is responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company. The developer will provide oversight and planning of data models, database structural design and development and works closely with the Data Architect.

Duties include working in a cross-functional software development teams (business analysts, software engineers, testers), following agile software engineering and development practices. The developer plays a key role in contributing to the design, evaluation, selection, implementation and support of databases solutions that deliver long-term value to Concentrix and our clients.

**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**: From ₡3,500,000.00 per month

**Education**:

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

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

**Language**:

- English Level C1+ or B2+ (preferred)