Previous Job
Previous
ETL Developer
Ref No.: 18-03999
Location: Irving, Texas
Start Date / End Date: 05/20/2018 to 12/29/2018
In this role, the candidate will be responsible for database development and would be tasked to help in Telecommunication Finance Systems Group. This will involve hands-on, self-directed design and development of highly scalable, reliable, and performance pipelines to consume, integrate and analyze large volumes of complex data using a variety of best-in-class proprietary and open-source platforms and tools. This role shall be responsible for implementation of a sound architecture, design, and development standard. Design optimal data transformation (ETL) jobs and manage technical metadata across all jobs. Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework. Serve as the point of contact responsible for the construction of all objects necessary within the Data Warehouse platforms. The candidate must have strong communication skills and be able to work with both users and lead IT team members in a highly collaborative team environment. Candidate should be disciplined, detail-oriented, self-motivated, and delivery-focused.

Required Skills
In-depth knowledge and hands-on experience with data integration
In-depth knowledge and hands-on experience of database/appliance systems, specifically Teradata
Strong SQL and database performance tuning skills
Batch processing and scripting in UNIX/Linux Environment (shell scripting, Autosys)
Hands-on experience in ETL development
Perform data analysis and deep dives to pinpoint problems
Working knowledge of financial application systems is a plus point
Bachelor's degree or equivalent 7+ years of experience
7+ years of professional experience in Datawarehouse Application
Strong knowledge of databases, SQL, Functions, Stored procedures, and Triggers.
Experience
3-5 years of working experience with TERADATA
2+ years of working experience with Mload, tpump, bteq, fastload, fastexport and other utilities for Teradata
Exceptional analytical and problem-solving skills. Team player with the ability to communicate effectively at all levels of the development process
Extensive Performance Tuning experience in Teradata SQL

Desired/Nice to have the skillset
Working experience in Telecom Data Warehouse
Working experience with reporting tools like Reporting Services, Tableau etc.