ETL Developer en Querétaro, Querétaro para Performance Coatings Group GSC Mexico - Hireline México

ETL Developer en Performance Coatings Group Gsc Mexico

$ 60,000 a 70,000 MXN (Bruto)

Querétaro

Empleado de tiempo completo

Nivel de Inglés: Nivel Avanzado

Overview:

This key role will report to the onshore DB Architect/IT head and will be accountable for Extract – Transform – Load activities of Data between the ERP, CRM and other Enterprise Systems. Specific accountabilities include:


  Role & Responsibilities

• The candidate will be responsible for ETL development and maintenance.

• Should have working knowledge of T-SQL particularly analyzing the data structure and entity relationship in the SQL server database.

• Analyze and interpret complex data on target systems and provide solutions to all data issues and coordinate with data analyst to validate all requirements Coordinate with ETL team to implement ETL packages for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing ETL packages Develop ETL processes according to business requirements.

• ETL Package audit and error log process.

• Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables.

• Strong knowledge of relational databases management system (RDBMS)

• Strong knowledge of T-SQL queries SQL Server integration service (SSIS) package creation and data integration with SQL server Hand on experience on SSRS portal

• Familiarity with visualization tools like Power BI and Tableau will be an additional advantage Intermediate or greater proficiency in MS Office (Word, Excel, Access)

• Effective communication and deduction skills Be a good team player Work ethic based on a strong desire to exceed expectations.


Technical Skills

• Minimum 3 - 5+ years of experience in Data Warehousing and ETL space, with 3+ years of experience as a Data / ETL developer

• Hands on experience in Agile-SCRUM SDLC and has ability to break down the business requirements into sizable story points aligned with MVP (Minimum Viable Product) followed by additional features through various sprint releases

• Hands on experience in SQL and MS T-SQL stored procedures

• Hands on experience in cloud-based platforms like MS Azure, AWS, Google Cloud etc., MS Azure would be preferred

• Hands on development experience in Python

• Hands on experience in snowflake schema modelling

• Experience in data visualization tools like Power BI, Tableau, Qlikview, etc., Power BI Preferred