Data Consultant SAP EIM
As a Package Consultant at IBM, get ready to tackle numerous mission-critical company directives. Our team takes on the challenge of designing, developing and re-engineering highly complex application components and integrating software packages using various tools. You will use a mix of consultative skills, business knowledge, and technical expertise to effectively integrate packaged technology into our clients’ business environment and achieve business results.
Your Role and 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.
Works 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
Required Technical and Professional Expertise
- 5 years of experience in Business Objects Data services
- 2 years of experience in SQL and 5 years of experience delivering complex data management engagements, including all phases of project life cycle from scoping and planning, requirements gathering, design, development, testing, and go live phases.
- Worked in at least two end to end SAP S4 implementation.
Should have Worked in the Big Three Objects of Data Migration Customer, Vendor, Material.
2 years of experience in Data Migration Cockpit and LSMW (Legacy System Workbench)
2 plus years of experience in loading data into S4/ECC using Idocs/Bapi
- 5 years of the ability to drive the ETL (SAP BODS) support process and ensure compliance of project standards and deliverables.
Preferred Technical and Professional Expertise
2 years of SAP Information Stewards
2 Years of experience in Smart Data Integrator and Data Quality (SDQ)