ETL Developer

Description

JD for Senior ETL Developer:

The primary function is providing support and solutions for an Informatica based enterprise middleware system during failure and help maintaining SLA
Customisation and support of interfaces with SFDC applications
Support interfaces to Infoquest and Einstein analytics
Develop the ETL code from requirements and mapping the fields in source systems
Responsible for major project enhancements driven by business needs involves changes at various steps of application
Ensure the complete and consistent data flow from source to target.
Maintain the integrity of data between the source system by having reconciliation enabled in the code and audit scripts
Tune the existing scripts for performance improvement
Provide quick workarounds and solutions for the problems encountered in production environment
Work with data modelling team to ensure data standards are met
Mapping the data from SFDC source system
Provide long term solutions for issues occurring frequently to avoid risks due to manual intervention
Role must take a logical approach that enables the team to systematically organize and consolidate scripts for workaround and production support


Knowledge/Skills Required:

Informatica Power Centre and Power Mart
SFDC and Teradata V2R12 and V2R13
SQL/PL SQL knowledge
Excellent Unix Knowledge
Shell Scripting
Excellent Problem-solving capabilities
Willingness to work during extra business hours
Must have positive attitude and willingness to help team and share knowledge