Client

Newscorp

Position

Senior ETL Developer

Location

Princeton NJ

Job Type

Contract  

Yrs of Exp

8yrs

Job Description

• ETL developer with strong python experience on spark/EMR.


• Experience with AWS Athena and dynamoDB is a must and any orchestration tool e.g. Airflow is a plus


• The primary function is providing support and solutions for an Informatica based enterprise middleware system during failure and help maintaining SLA


• 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


• 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