American Express Careers

Data Engineer I

Bangalore, India
Digital Commerce Technology

Apply Get Referred

Job Description

Focus Designs, develops, troubleshoots, evaluates, modifies, deploys and documents all data components (data architecture, logical and physical data models, database objects and database administration) that meet the needs of customer-facing applications, business applications, and/or internal end user applications.
Organizational Context Member of a database management team or database support team reporting to a Senior Data Engineer, Senior Data Architect, Engineering Director or Director of Technical Delivery.
 
Key Responsibilities
•            Partner with the product teams to understand business data requirements, identify data
•            needs and data sources to create data architecture
•            Documents data requirements / data stories and maintains data models to ensure seamless integration into existing data architectures
•            Manages data assets as per the enterprise standards, guidelines and policies
•            Documents processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements
•            Creates and maintains detailed information about the data being stored in the database
•            Understands the database requirements and translate into physical database design.
•            Follows data placement procedures and re-use of existing databases when possible
•            Builds and enhances database design and infrastructure required to support the Business portfolio
•            Performs database design review and supports database testing
•            Provides production environment support for database systems and processes
•            Communicates and works collaboratively with business and product teams to support changes and implementation
•            Write instructions to guide database operators during production runs
•            Work on assigned database features for ongoing sprints and manage database requirements based on industry trends, new technologies, known defects, and issues
•            Partner with delivery architects and engineers to design optional data tier solutions to meet platform objectives and goals
•            Function as an active member if an agile team through consistent development practices (tools, components, and documentation)
•            Identify opportunities to adopt innovative technologies
 
 

Qualifications

Education & Experience             
 
6+ years of data architecture and database development experience in a professional environment and/or comparable experience such as:
•            Familiar with Agile or other rapid application development methods
•            Experience with design and development across EDB Postgres, Couchbase, Cassandra, Netezza and Yellowbrick database platforms
•            Broader understanding of other Relational & NOSQL Database Technologies
•            Hands-on expertise with database design both ER Modeling and NOSQL Data Modeling using tools like ERStudio & Hackolade
•            Hands-on expertise in DB Performance Tuning, Query Optimization & Troubleshooting
•            Bachelor’s Degree in computer science, computer science engineering, or related field required; advanced degree preferred
 
High-performing Behaviors       
 
•            Identifies opportunities to adopt innovative technologies to enable business capabilities
•            Able to challenge the status quo and drive innovation by generating creative ideas and solutions
•            Keeps up-to-date on current research and technology in the industry
•            Understands technical aspects of the job and uses appropriate technology for the situation at hand
•            Tries new approaches when problem solving, seeking ideas, or suggestions from others as appropriate
•            Carries out systematic and rational analysis to identify the root cause of problems
•            Recognizes the importance of teamwork to achieve objectives
•            Is clear when explaining ideas and concepts to others, communication is structured and easy to understand
•            Manages multiple tasks effectively - progresses work in parallel
•            Adapts to change quickly and easily
•            Handles problems and acts on own initiative without being prompted
•            Knows when to escalate decisions and when to make on-the-spot decisions
 
Knowledge/Skills
 
•            Strong analytical skills with a demonstrated ability to understand and document business data requirements in complete, accurate, extensible and flexible logical data models using data modeling tools like ErStudio, Hackolade etc.
•            Able to facilitate discussions between small groups of Technology and business people, recognize issues of conflict and inconsistency between data requirements and pursue a resolution of these issues
•            Understands XML/JSON and schema development/reuse, Open Source and NoSQL will be an added advantage
•            Able to establish, modify or maintain data structures and associated components according to design
•            Understands Metadata Management and Database Management concepts
•            Creates data models using the relevant tools and frameworks
•            Partners with Sr. Data Engineers and Sr. Data architects to create platform level data models and database designs
•            Technical knowledge of DBMS products and ecosystem – e.g. storage formats, access algorithms, data management processes, administration, data maintenance, replication, high availability, encryption, etc.”
•            Ability to monitor and tune databases and DBMS’s to reach high performance – e.g. use data monitoring and analysis tools, tune configuration parameters, alter physical designs, benchmark, etc.
•            Has working knowledge of the range of tools used in the planning, analyzing, designing, building, testing, configuring and maintaining of assigned application(s)
•            Able to participate in assigned team’s software delivery methodology (Agile, Scrum, Agile XP, Test-Driven Development, Waterfall, etc.)
•            Understands and has practical experience with infrastructure technologies and components like servers, jvms and networking concepts
•            Application of industry best practices, processes and standards
•            Identifies a number of ways to do things differently that will continuously improve the product
•            CI/CD Integration tools like Jenkins, Liquibase etc.
•            Project Management tools like Rally, Jira etc.
•            SDLC Methodologies and Practices
•            Metadata Management and Database Management
•            System/Platform Domain Knowledge

ReqID: 19014783
Schedule (Full-Time/Part-Time): Full-time
Date Posted: Aug 12, 2019, 11:02:00 AM
Apply Get Referred