Please reply to:- Prabhu,Shivprasad / [email protected] / 609-606-9010 Ext.# 1432
Job Details:-
| Job Title : | Sr. BI Data Engineer |
| Location : | Philadelphia, PA |
| Expected Duration of Project : | 6 Months |
| Start Date : | 01/17/2013 |
| Interview Type : | Personal |
| Duties & Responsibilites : | Description:-
The Sr. Data Engineer will be responsible for BI and ETL design, translating business demand for information into technical requirements, data transformation maps, logical and physical data models to deliver solutions for transactional and reporting systems.
Key Responsibilities:-
- Partner with business and other stakeholders to understand information needs.
- Critically evaluate requirement information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding and distinguish user requests from the underlying true needs.
- Reverse-engineer existing reports, code, databases and other existing solutions as required.
- Drive and challenge business units on their assumptions of how they will successfully execute their plans.
- Proactively communicate and collaborate with customers to analyze information needs and functional requirements to deliver the following artifacts as needed: functional requirements, use cases, source to target data transformation maps, logical and physical data models.
- Define data models, both traditional 3rd normal forms and dimensional (star and snow-flake schema)
- Serves as the conduit between the customer community and the software development team through which requirements flow.
- Assist project managers with estimation and planning.
- Work independently with users to define concepts and under direction of project managers.
- Ability to reverse engineer current processes and offer improvements.
- Determine how data will fit in with existing structures and/or design something new.
Qualifications:-
- Bachelor’s degree in Computer Science or Engineering
- 5-10 years of experience developing business requirements with an emphasis on data modeling and data transformation.
- Good understanding of data modeling – from both a logical and physical perspective.
- Strong Database development experience on both OLTP and OLAP databases.
- Solid expertise in SQL queries and query optimization
- Hands-on experience with modeling tools, such as CA Erwin
- Experience with data modeling for transactional databases, operational data stores, data warehouses and data marts.
- Experience with SQL Server 2005/2008 and MS Access required
- An understanding of what the following tools/technologies do is preferred, but not a must have: SSRS, SSAS, SSIS, SharePoint, Report Builder, Excel, Access, Oracle, Informatica, Business Objects, Oracle BI Enterprise Edition etc.
- Knowledge of Mortgage or insurance industry products are HIGHLY desired
- Strong communication and presentation skills. |
Click here to see details and upload resume for this job.
Click here to see all jobs on jobs.compunnel.com.
--
You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected].
For more options, visit this group at http://groups.google.com/group/sap-vendor?hl=en.
