Reporting to the Associate Director, Data Integration Analytics, the Sr. Application Systems Developer will be responsible for technical design and implementation of lifecycle activities associated with the extract, transform and loading (ETL) of database tables with automated utilities, ETL tools (i.e. Business Objects Data Services BODS) and SQL programs.
CHARACTERISTIC DUTIES AND ESSENTIAL RESPONSIBILITIES:
Deploys code across Dev, QA and Production environments using central repositories
Develops/Maintains/Supports current and existing data flows from multiple source systems
Develops/Maintains/Supports business rules and process around data cleansing, consolidation and validation, etc.
Troubleshoots/debugs ETL and SQL query issues and provides solutions
Develop views and ad hoc/scheduled SQL queries to analyze data, produce exception reports, validate data and as required by the functional team
Creates ETL solutions using data warehouse design best practices, such as Star-Schema design and Change Data Capture, etc.
Assists in the design and creation of logical and physical data models for reporting databases
Produces data flow diagrams and other documentations and diagrams as needed
Works with Director and Project Manager to develop and follow project plans and resource estimates. Works with Reporting team and data integration team to define and develop user data requirements
Integrates, collaborates and leads projects, working hand in hand with Business Analysts, Data Warehouse team and DBA and the infrastructure team
Works with functional team to assist in the preparation of source to target data maps. Work with project team and collaborate with both reporting application developers and OLTP technical leads.
Assists in gathering/reviewing business requirements, partnering with business analysts, providing feedback on functional request feasibility and scope
All other duties as assigned.
MINIMUM QUALIFICAT
📌 Production Manager (Bengaluru)
🏢 Yugn Management Services
📍 Bengaluru
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.