Gap Inc.
ETL Data Engineer -Sr. Software Engineer
Job Description
About the Role
As a Senior Data Engineer, you will work closely with engineering, analytics, data science staff across various Gap Development Center to deliver the goals and objectives of the business.
What You’ll Do
- Design and build reusable components, frameworks and libraries at scale to support analytics products.
- Design and implement product features in collaboration with business and Technology stakeholders.
- Anticipate, identify and solve issues concerning data management to improve process and data quality.
- Clean, prepare and optimize data at scale for ingestion and consumption.
- Architecting & coding data pipelines and by integrating data from all sources including but not limited to ecommerce systems, POS, 3rd Party Vendors, etc.
- Build continuous integration, test-driven development and production deployment frameworks.
- Drive collaborative reviews of design, code, test plans and dataset implementation performed by other data engineers in support of maintaining data engineering standards.
- Analyze and profile data for the purpose of designing scalable solutions.
- Troubleshoot complex data issues and perform root cause analysis to proactively resolve product and operational issues.
- Mentor and develop other data engineers in adopting best practices.
Who You Are
- 5-8 years’ experience in developing applications using Relational Database e.g. Oracle , Teradata , MS-SQL Server
- 5-8 years’ programming experience in building high quality applications, data pipelines and analytics solutions and data products using RDBMS.
- 2+ years’ experience working on cloud platform (preferably Azure).
- Experience working with Data platforms, including Databricks etc.
- Working knowledge of Data warehousing, Data modelling, Governance and Data Architecture
- Exposure & experience with cloud data-based data management practices especially in Azure, AWS.
- Strong understanding of ETL concepts and tools such as Datastage , ADF , Informatica etc.
- Strong analytical and communication skills. Should be self-driven, highly motivated and ability to learn quick
- Lead/Work with many global teams, communicate effectively, both written and verbal, with technical and non-technical multi-functional teams.
- Provide coaching and mentoring to junior team members
- Experience working in Agile and Scrum development process.
