SAGE - Data warehouse Architect Opening
- SAGE Publications
- 10 - 15 years
- Delhi, NCR
- 5 years ago
- Email to a friend
- Report this job
Job Description
The Data Services and Reporting Team is looking for a hands-on Data Quality and Data Warehouse developer who has specialized experience with Data Quality engines preferably SAP Data Services and SQL Server technologies to design, develop, test, and tune Data Services jobs as well as ETL, reporting and related solutions. The candidate will need to independently study the requirements and ensure the feasibility of requirements, deciphering ambiguities. S/he will need to profile various information systems, capture source/target mappings and transformations based on project requirements. The successful candidate will design complex SAP Data Services job flows to extract from/load to non-SAP systems such as on-premises MS SQL Server, MS Azure SQL Databases or flat files. S/he will possess experience with DI transforms such as Query, Validation; Case transforms as well as DQ transforms such as Match, Associate, Merge, Survive, Data Cleanse and Address Cleanse and will be able to tune jobs for high volume and complex transformation scenarios. Additionally, configuration, installation of all components as well as automation of jobs are required duties. Further, the candidate will need to own and support operational processes including documenting such processes. S/he will participate in planning of development projects; participate in enhancing processes for ETL design, source code control, integration testing, defect management, database standardization and tuning. The infrastructure ecosystem comprises of SAP Data Services, Cognos 10, SSAS, SSRS, SSIS, Informatica, TSQL, Shell/Perl/ PowerShell scripts, and Siebel Analytics on SQL Server clusters.
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:
The job functions include, but are not limited to, the following:
1. Analyze requirements and feasibility thereof
2. Design and document technical specifications
3. Develop in the platforms needed
4. Test -Unit, System and Integration testing
5. Prepare User Acceptance Testing environment
6. Deployment test and develop deployment script
7. Deploy solutions
8. Monitor and support processes
9. Communicate along the way during project and maintenance life
10. Review design and codes
11. Help grow and grow in all areas of soft skills and technically
EDUCATION, SKILLS, EXPERIENCE AND QUALIFICATION GUIDELINES
Any combination equivalent to, but not limited to, the following:
- 5+ years of experience in Data Quality engineering preferably in SAP Data Services, SSIS and Data Warehousing
- 7+ years of dimensional modeling experience and strong understanding of Data Warehouse best practices
- Strong database experience (incl. SQL, tuning, etc.) on SQL Server
- Strong analytical and logical thinking
- Meticulous and methodical in creating solutions
- Excellent verbal and written communication skills with technical and non-technical audiences
- Experience with .net programming
- Independent, self-motivated team player
- Production Support Experience and Flexibility of being on-call
Desired Skills:
Agile or RUP Software Development Methodology
Solid understanding of SOA
Practical knowledge of Soap/XML and Web Services
Experience with ERStudio, ERWin or Sparx Enterprise Architect
Suitable candidate please share your resume at re********t@sa****b.in or ta***************n@sa****b.in
Job Classification
Industry: Media, Entertainment, InternetFunctional Area: IT, Role Category: Not mentionedRole: Not mentionedEmployement Type: Full timeEducation
Under Graduation: B.Tech/B.E. in ComputersPost Graduation: Any Postgraduate in Any SpecializationDoctorate: Doctorate Not RequiredContact Details:
Company: SAGE Publications India Pvt LtdAddress: B-1/I-1,,,MATHURA ROAD,MOHAN COOPERATIVE INDUSTRIA, L AREA, , NEW DELHI, Delhi, IndiaLocation(s): Delhi, NCR
Keyskills: SSRS Data Warehousing SSIS MS SQL SERVER DATABASE
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in