Job Details
Job Description:
The client is looking more for a ETL Lead with strong SQL stored procedure experience.
Here is what we need.
- Strong ETL Background (Data Extraction, Transformation and loading in target from heterogeneous data sources)
-
Writing SQL Stored Procedures for ETL.
- Work with scheduling tools like One Automation
- Develop and provide inputs to design specifications within defined architecture, utilizing standard procedures and techniques.
- Interface with Product Owners, Scrum Masters and Business Clients to clarify requirements, as appropriate.
- Set up complex workflows and schedules
- Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
- Write documentation that describes installation and operating procedures.
- Deep knowledge of data extraction, transformation & loading (ETL) methods using Teradata.
- Advanced SQL skills (Teradata and RDBMS like Oracle, MS SQL, DB2).
- Advanced hands-on experience with Data Warehousing.
- Experience participating in multiple technical projects using Agile methodology
- 5 years of experience with SQL Query Design in large-scale data warehouse environments.
- 5 years of experience in data collection, database design, and report development.
- Demonstrated experience in delivering IT/BI solutions.
- Expertise in Query optimization and Performance-tuning techniques
-
Knowledge in Teradata Stored Procedures, BTEQ, Utilities
- A person must have good analytical skills
- Good knowledge of UNIX programming.
- Good communication skills
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.