16 Apr
Data Warehouse Developer
Vacancy expired!
- 3 years of data warehouse / ETL development experience in a BI/Data Warehouse environment with involvement in design and architecture.
- 3 years of experience developing scalable and comprehensive enterprise analytics solutions including extraction of data from multiple sources, transforming data according to the business rules, and loading data into the operational and presentation model.
- 3 years of experience mapping data between source system and Data Warehouse repositories, including identifying the data elements in source systems and creating a mapping document for extracts to be loaded in data warehouse.
- 3 years of experience developing ETL solutions utilizing tools such as IBM Infosphere Datastage and SSIS, including requirements gathering, analysis, design, development, implementation, support, maintenance, and technical recommendations for enterprise solutions.
- 3 years of experience writing complex and advanced SQL, optimizing large and complicated SQL queries for performance tuning to analyze and resolve performance issues within variety of operational environments.
- 3 years of experience working with Teradata database and its architecture including different types of indexes (PI, SI, JI), partitioning, statistics, explain plan and Teradata load utilities (TPT, FastLoad, FastExport, MLoad, TPump).
- 3 years of experience working with other databases like Sql server, Oracle, MongoDB, IBM DB2.
- 3 years of experience performing Unix shell scripting to provide automation solutions for new and existing processes to achieve high ETL performance and reduce errors.
- 3 years of experience maintaining and monitoring the team's incidents, problems, defects, and all work requests using the BMC Remedy & JIRA tools.
- 3 years of experience working with batch job schedulers such as ZEKE, Control-m.
Vacancy expired!