Resource having 10+ years of solid experience in Datawarehousing/BI developement with
primary focus on Datastage ETL
Required skills:
• Data Warehousing Development and Design Experience
• Should have minimum 10+ relevant years in DataStage & ETL tools.
• Should have good knowledge & experience in DataStage 11.0 and above – development
experience on parallel jobs.
• Experience working on different types of data source for data migration is an added
advantage.
• Database experience/knowledge – Oracle SQL will be preferred, knowledge on Oracle
DB query tools – TOAD, SQL Developer.
• Strong skills in all aspects of SQL development (triggers, stored procedures, views, etc.)
and implementation.
• Strong performance tuning knowledge in SQL and ability to interpret plans, identify
bottlenecks in queries and remediate them.
• Strong knowledge of database technologies and principles, including data modelling,
data mapping etc.
• Strong experience with data analysis, troubleshooting data issue.
• Should have Experience in Development / Production Support and maintenance
• Should have Experience in designing the data mart and data warehouse
• Should demonstrate excellence in understanding the existing data models and ability to
redesign them as per changing business needs
• A strong knowledge of business intelligence design concepts, with a concentration in
dimensional modelling in RDBMS.
• Good to have experience in DevOps.
• Should have worked on projects involving medium – large data warehouses
• Good written & oral communication skills, interpersonal relations, hardworking and result
oriented as an individua
• Effectively work with minimal supervision and independently
• Any exposure to Python/Spark/Java would be an added advantage
• Experienced in Agile methodologies and using relevant tools like
JIRA/Bamboo/GIT/Confluence””””
Any Graduate