SSIS Developer

Mandaluyong City, Philippines Senior Developer Open Salary

The MS SQL DBA and SSIS developer will gather business requirements, produce specifications and develop the databases. You’ll support database functions by designing / coding utilities, monitoring performance. Works independently to develop, configure, code and test programs from specifications.

About the position

Responsibilities

1.      Develop ETL data workflows and code for new data integrations and maintain/enhance existing data flows and packages. Familiar with IBM AS400, File, SQL, Ole-DB, ODBC providers for connect to different system or applications make data exchange.

2.      Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies, and exception handling.

3.      Provide support to technical team, write the necessary required documentation as per the development methodology for ETL processes, and develop unit test plan, test cases and resolve ETL related test issues.

4.      Data modeling design, according to business requires for dimension design, functions calculation.

5.      Reporting service development, store procedure or T-SQL query data.

6.      Provide in-depth troubleshooting skills to assist in resolving errors and performance issues including production support.

7.      Keep alert of integrated product developments that translate to environmental or code modifications. Comply with internal development coding standards, procedural guides, and checklists for the support of the database systems.

8.      Interacting with individuals from across the company in different supporting organizations and business groups.

9.      Ability to research, learn, troubleshoot and support complex system customizations.

Requirements

1.      Bachelor’s degree in Computer Science or technology related field.

2.      At least 5 years MS SQL Server experiences, design data modelling and solutions to fulfil business and system data requirements. T-SQL development experience in SQL Server 2008 – 2016 databases, writing complex SQL (stored procedures, functions, views), Familiar SQL Server, DB2/AS400, script the Store procedure.

3.      3 years of experience in SSIS Package Maintenance and Development, familiar with control flow and data flow development.

4.      Define, develop and sustain the database physical structure and functional capabilities, database security, data back-up, and recovery specifications

5.      Turning database performance, calculating values for database parameters to provide fast responses to end users. Support database functions by designing and coding utilities.

6.      Skillful of SQL Server development and database structures, report development with SSRS.

Benefits

About the recruiter

Mary Jade Samera

Email: [email protected]

Phone:+639173639188

Trust, Passion, Responsibility and Independence

About us

ERNI was founded in 1994 in Switzerland to develop innovative software for international companies and small to medium­sized enterprises. Today, the ERNI Group has more than 800 employees at 15 locations in 7 countries and continues to grow. Interested?

Sounds interesting?
Apply now!















ERNI Schweiz

Casinoplatz 2

3011 Bern

Phone: +41 58 268 12 00

Email: [email protected]

better ask ERNI

ERNI Suisse

Bâtiment L

Route des Acacias 43

1227 Geneva

Phone: +41 58 268 11 03

Email: [email protected]

better ask ERNI

ERNI Suisse

Voie du Chariot 3

1003 Lausanne

Phone: +41 58 268 11 03

Email: [email protected]

better ask ERNI

ERNI Schweiz

Brünigstrasse 18

6005 Lucerne

Phone: +41 58 268 12 00

Email: [email protected]

better ask ERNI

ERNI Schweiz

Löwenstrasse 11

8001 Zürich

Phone: +41 58 268 12 00

Email: [email protected]

better ask ERNI

ERNI Deutschland

Trakehner Str. 7-9

60487 Frankfurt am Main

Phone: +49 697 953 28 01

Email: [email protected]

better ask ERNI

ERNI Deutschland

Design Offices München – Arnulfpark

Luise-Ullrich-Str. 20

80636 München

Phone: +49 162 334 77 30

Email: [email protected]

better ask ERNI

ERNI Slovakia

Ševčenkova 34

851 01 Bratislava

Phone: +421 2 32 55 37 37

Email: [email protected]

better ask ERNI

ERNI España

Edificio El Triangle

Plaça Catalunya 1-4, 3º planta, Módulo A y B

08002 Barcelona

Phone: +34 93 667 77 76

Email: [email protected]

better ask ERNI

ERNI España

Carrer Pallars, 208, Bajos

08005 Barcelona

Phone: +34 93 667 77 76

Email: [email protected]

better ask ERNI

ERNI España

Calle de Alfonso XII 62

Oficina 3101

28014 Madrid

Phone: +34 901 848 787

Email: [email protected]

better ask ERNI

ERNI España

Sant Cugat ERNI Office

Plaça Xavier Cugat, 2 EDIF B Planta Baja

08174 Sant Cugat del Vallès

Phone: +34 93 667 77 76

Email: [email protected]

better ask ERNI

ERNI Romania

Calea Dorobantilor no. 98-100

3rd floor, in Olimpia Business Center

400609 Cluj-Napoca

Phone: +40 744 319 228

Email: [email protected]

better ask ERNI

ERNI Singapore

7 Straits View

Marina One East Tower #05-01

Singapore 018936

Phone: +65 9161 9863

Email: [email protected]

better ask ERNI

ERNI Philippines

9th Floor, 500 Shaw Zentrum Building

500 Shaw Boulevard

Mandaluyong City, Philippines 1555

Phone: +63 2 531 59 82

Email: [email protected]

better ask ERNI