Description

Role & responsibilities:

Responsibilities:

  • Deploys code across Dev, QA and Production environments using central repositories.
  • Develops/Maintains/Supports new 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.
  • Ability to work weekends and off-hours for critical deployments and issues.

Required Skills:  

  • 6+ years’ working in SAP Business Objects Data Services (BODS) – for designing and development ETL solutions.
  • SAP Business Objects Data Services (BODS) proficiency needs to include:
    • Audit Rules
    • Built-in Functions
    • Interactive Debugger
 


 

Education

Any Graduate