Job title- ETL Developer/Senior Data Engineer
Location- Local to Boston or Rhode Island(Initial remote)
Duration- 6+ Month
Visa: USC/GC ONLY
Interview-Phone and video
Interview Process:
- Panel interview: 1 round. 30 minutes/ Video/Webex (links forthcoming)
- Managers (2 of 3 will join): Irina Feygin, Sai Sathish Kotur, and/or Lavan Gunde
- Interview Schedule: Monday-Friday. Time frame is tight – only 2pm-2:30pm EST, or 2:30pm-3pm EST
Job Description:
The Enterprise Data Office is looking for a Senior Data Engineer with a winning track record in building high performing data and analytical solutions that transform, integrate and meet various data demands from business.
Our Senior Data Engineer will be responsible for the development of ETL process on AWS technologies. We are looking for a leader who can mentor other developers along with hands on experience to develop scripts to move data from AWS S3 to downstream systems. You will be responsible for building data products which involves architecture, design, build, test and support data integration projects.
Primary responsibilities include:
- Implementing data integration architecture and solutions.
- Conducting source system/data analysis and data profiling.
- Building robust data pipelines to collect process and compute different metrics from various financial sources, adhering to quality and development standards.
- Designing application architecture / technical design and articulating the data pipeline solutions to team members.
- Data mapping from source to target and define transformation rules that meet the models created by Data Architects. Collaborating with cross functional team members as necessary and coming up with optimal solutions that meet data demands.
- Executing unit test of data populated in target data container, validating expected result and ensuring quality and accuracy. Coordinating with business users for User Acceptance Testing and with Operations team for code deployment to upper environments.
- Following change management team stipulations on path to production requirements and strictly adhering to the compliance and regulatory needs.
Required Skills/Experience:
- Expert in AWS technologies
- Proficient with ETL Development tools like Talend, Data Stage
- Excellent skills in SQL Development
- Python and other scripting language expert
- Ability to work on AWS Glue, AWS S3, Lake formation and other cloud concepts.
- Python
Education, Certifications, and/or Other Professional Credentials:
- BS/Engineering in Computer Science or any technology related degree
Notes from Kristin:
- Ideal candidates would have exposure to Talend and Data Stage they are moving from Data Stage to Talend
- AWS very important
- Redshift
- Bonus - if financial background
Hours and Work Schedule
Hours per Week: 40
Work Schedule: Monday through Friday
Saurav Kumar
Recruiter
Office+ 533-395-3922