.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
