JOIN THE TRULY GLOBAL
THAKRAL FAMILY
Management
Data Integration (DI) Lead
Job Description
The Data Warehouse Lead is responsible for designing data solutions and leading a team during the writing of scripts and ETLs required to extract, transform, clean, and move data and metadata so theycan be loaded into or extracted from databases, data warehouses, data marts, or text files.
Responsibilities
- Planning, design, development and optimization of relational and multi-dimensional data models and ETL/ELT Jobs and processes.
- Definition and maintenance of the data warehouse metadata (Data Dictionary)
- Participate in defining data modeling standards, strategies, and approaches in accordance with industry best practices and procedures
- Responsible for testing, monitoring and validating data integration activity, including data extraction, cleansing, transformation, movement, loading and updating processes
- Ensures data integration processes meets service level requirements
- Designs and writes the scripts required to extract, transform, clean and move data and metadata so it can be loaded into a data warehouse, data mart or operational data store
- Supporting the technical design process by participating in the analysis of technical application requirements
- Assisting in implementing analyses that will identify requirements related to people, processes and technology
- Participating in implementing the technical infrastructure
- Assisting in the integration of technical and application components
- Maintaining, tuning and repairing applications; providing user support
- Participating in execution and documentation of tests
- Executing conversion plans and documenting possible improvements; identifying disruptions inthe processes
- Responsible for providing leadership to a team of developers
- Prioritizes requirements, schedules tasks and communicates progress
- Design of Test Scripts and Process
Skills
- Good communication and leadership skills
- Understanding of source and target data structures
- Understanding of ETL processes and products
- Knowledge of Unix shell scripting
- Strong problem-solving and metadata skills
- ETL Tools, RDBMS, SQL writing experience
- End-to-end implementation of ETL projects
- Data Warehouse design and data modeling experience
Education and Experience Level
- Experience with data performance and data warehousing concepts
- Minimum of 8 years data architecture experience, demonstrated accomplishment of data architecture and data modeling assignments
- BS Degree in Computer Science/Information Technology, Computer Engineering or any 4-year IT related degree
- Hands-on experience in implementation and deployment of SAS Data Integration Solution.
- Hands-on experience in implementation and deployment of any of the following Data Integration Technologies/Solutions: SAP, Oracle, IBM, Informatica, Microsoft SQL Server and on SAS Data Quality Solution is a plus