Job Description:
88031-1
Job Title: ETL DataStage
Positions: 1
Location : Pune
Shift timing: 12-9 PM
• Advanced ETL experience using DataStage
• Strong ETL performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments
• Strong understanding of Data warehousing design concepts/skills
• Data modelling for data warehouse 3NF & DataMart – star schema
• Strong SQL skills including complex query building and query performance tuning
• Batch Data Movement – ETL (DataStage experience is preferred, but mandatory they have deep knowledge of the concepts)
• Traditional Relational Databases
• Data analysis skills - ability to dig in and understand complex models and business processes
• Strong UNIX shell scripting skills
• ETL-related Python coding skills
• Proven experience in working directly with business customers
• Ability to understand Oracle schemas and LDM/PDMs, and design/build DataStage jobs to meet requirements
• Ability to write complex SQL queries to support trouble-shooting of ETL jobs across Oracle schemas
• Proven data migration & extraction experience, including appreciation of data gove
ance & quality controls• Proven performance & tuning experience with DataStage set-up and config (with various data load scenarios)
• Strong communicator & focus on documentation for continuous improvement, e.g. repeatable and automated deployment processes
• Ability to work with Global teams
Reason for Request:
Comments for Suppliers: Immediate Joiners.
ETL experience 6+
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.
We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.
Company Info:
3rd Floor, Sonthalia Mind Space
Near Westin Hotel, Gafoor Nagar
Hitechcity, Hyderabad
Phone: +91 40 48549120 / +91 8790177967
Gyleview House, 3 Redheughs Rigg,
South Gyle, Edinburgh, EH12 9DQ.
Phone: +44 7590230910