ETL Data Engineer -Sr. Software Engineer

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.