AVP, ETL and Cloud Database Developer(L10) - Telangana, India - Synchrony

Description

Job Description:

Role Title: AVP, ETL and Cloud Database Developer

Company Overview:

Synchrony (NYSE: SYF) is a premier consumer financial services company delivering one of the industry's most complete digitally enabled product suites. Our experience, expertise and scale encompass a broad spectrum of industries including digital, health and wellness, retail, telecommunications, home, auto, outdoors, pet and more.

• We have recently been ranked #5 among India's Best Companies to Work for 2023, #21 under LinkedIn Top Companies in India list, and received Top 25 BFSI recognition from Great Place To Work India. We have been ranked Top 5 among India's Best Workplaces in Diversity, Equity, and Inclusion, and Top 10 among India's Best Workplaces for Women in 2022.
• We offer 100% Work from Home flexibility for all our Functional employees and provide some of the best-in-class Employee Benefits and Programs catering to work-life balance and overall well-being. In addition to this, we also have Regional Engagement Hubs across India and a co-working space in Bangalore.

Organizational Overview:

This team is responsible for the design of data solutions for the Governance, Risk and Compliance team, utilizing progressive ideas and strategies for managing the flow and storage of information across the enterprise.

Role Summary/Purpose: Working under the general direction of the Development Manager, the Data Warehouse Developer will help lead the design of data solutions for the Governance, Risk and Compliance team, utilizing progressive ideas and strategies for managing the flow and storage of information across the enterprise. In this role, you will provide conceptual, architectural, and technical expertise for all aspects of the company's data warehouse initiatives. With hands-on guidance and expert advice as part of a team responsible for the design, development, integration, tuning and production support of the data warehouse stack: data management and modeling, ETL, operational data store, data warehouse and DataMart's, you will enhance data quality and bring technology discipline that will enable the growth and success of the organization. The Developer will work closely with IT and functional teams to recommend database structures based on the data storage and retrieval needs within each data domains. As part of a cross functional development team, you will works closely with the product/business owners to provide technical solution and support in a very dynamic and challenging environment

Key Responsibilities:

• Major responsibility will be to analyze business requirements in various business functional areas and translate them into conceptual, logical and physical data models.
• Proficient in Pentaho and/or SSIS and experience with other ETL technologies desirable
• Design and modify DataMart supporting business needs and configuration changes using knowledge of data warehouse principles, architectures and technologies in the context of Risk data requirements.
• Creating star, snowflake data models utilizing best practices and implementing them according to current and future data volumes/requirements as well as for the reporting application used to provide the information to the business user.
• Familiar with and follow process for agile data warehouse development.
• Define logical and physical data model structures to store, integrate, govern, and maintain data in a secure and efficient manner while maintaining accuracy of the data in the departmental data warehouse/DataMart./enterprise data lake.
• Map to information entities that can define how information should flow and be consumed by various business functions and IT customers. Create and own Data Flow Diagrams for data movement.

Required Skills/Knowledge:

• Minimum 4+ years' experience with data warehouses and big data platforms with hands-on experience
• Proficient in Pentaho and/or Talend and experience with other ETL technologies desirable
• Rigorous data analysis through SQL in Oracle and various Cloud Native technologies.
• Hands-on experience with data modeling of refined data layers on top of raw data.
• Performance Optimization of the physical models in the data lake.
• Minimum 4+ years' of programming experience in ETL tools – Pentaho or Ab Initio or Informatica highly preferred. Be able to read and reverse engineer the logic in Ab Initio graphs.
• Working knowledge of Hive, Cloud Native Database and other Data Lake technologies.
• Strong familiarity with data governance, data lineage, data processes, DML, and data architecture control execution
• Experience to analyze system requirements and implement migration methods for existing data.
• Familiarity with predictive analysis and data visualization techniques using relevant tools (e.g. Tableau, and R.) required.

Desired Skills/Knowledge:

• Background in Financial Services
• Hands-on experience writing shell scripts, complex SQL queries, Hive scripts, Hadoop commands and Git
• Ability to write abstracted, reusable code components
• Programming experience in at least one of the following languages: Scala, Java or Python Analytical mindset
• Willingness and aptitude to learn new technologies quickly
• Demonstrated experience building strong relationships with colleagues and partners

Eligibility Criteria:

• Master's / Bachelor's degree with 4+ years of experience in a quantitative field (such as Engineering, Computer Science, Statistics, Econometrics) and Information Technology experience. Or in lieu of a degree 6+years of experience in Information Technology experience.
• Mandatory Skill set : Shell Scripting, Pentaho, ORACLE , PYTHON, BIG DATA , MYSQL , AWS , GCP

Work Timings: 02:00 PM to 11:00 PM (IST)

This role qualifies for Enhanced Flexibility and Choice offered in Synchrony India and will require the incumbent to be available between 06:00 AM Eastern Time – 11:30 AM Eastern Time (timings are anchored to US Eastern hours and will adjust twice a year locally). This window is for meetings with India and US teams. The remaining hours will be flexible for the employee to choose. Exceptions may apply periodically due to business needs. Please discuss this with the hiring manager for more details.

For Internal Applicants:

• Understand the criteria or mandatory skills required for the role, before applying
• Inform your manager and HRM before applying for any role on Workday
• Ensure that your professional profile is updated (fields such as education, prior experience, other skills) and it is mandatory to upload your updated resume (Word or PDF format)
• Must not be any corrective action plan (First Formal/Final Formal, PIP)
• L8+ Employees who have completed 18 months in the organization and 12 months in current role and level are only eligible.
• L08+ Employees can apply

Job Family Group: