Home  Post Resume Quick IT Job Search  Advanced IT Job Search 
Skip Navigation LinksHome » Job Details
  Company Profile
ICON Consulting, Inc. (ICI) is a privately held, Small Woman Owned and controlled Corporation founded in June, 1996. ICI provides quality Information Technology Services including Information Technology, Technical, Professional and Management Support Services to our Government and Commercial clients throughout the nation. ICI also provides customized recruiting and staffing services to our clients in the areas of permanent, temporary-to-hire, leased employee and employment payrolling. ICI is headquartered in Denver, CO with offices in Springfield, MO, Dallas, TX and Louisville, KY.
  Job Details 

Teradata ETL Developer : Teradata Utilities, Mainframe JCL, SAP, MQ : Atlanta, GA

Posted On:  3/30/2021 5:18:01 AM

Teradata ETL Developer

No. of vacancies:  4
Qualifications:  Bacholers Degree
Essential Skills: 
Not specified
Minimum Total Experience:  5
Job Tenure:  Full-time Only
Salary Offered:  DOE
Job Location:  Atlanta GA United States

  Job Description
Skills Required:

* Gather system design requirements, design and write system
* Knowledge of Teradata utilities - Fastload, Multiload, BTEQ, TPump
* Well aware of development methodologies using standards and best practices
* Good written and verbal communication skills
* Strong logical and analytical abilities
* Must be independent and self-motivated, with a knack for taking the initiative, overcoming obstacles
* Must be ability to work effectively with others across organizational and geographical locations.
* Conceptual thinker, learner, and effective problem solver
* Comfortable with delivering often complex solutions in tight timeframes

Experience required:

* Technical/Business Analyst with 5 - 7 years of experience in Teradata including utilities
* 2 years mainframe and JCL
* 2 years of cross-platform data transport, like SFTP, FTP or GIS
* 2 years of Brio or IR, 2 years SAP BW
* Extensive experience in data warehousing/business intelligence/ETL in analyzing user requirements, data mapping, design and test specifications
* Extensive experience in analyzing/designing complex Data warehouse solutions with many source systems/ETL processing
* Strong skills in understanding relational (conceptual, logical, physical), star schema and dimensional data models for data warehouses and Business Intelligence environments
* Proven analytic capabilities in Teradata utilities, mainframe JCL, client server, MQ
o Identify and document data lineage of load files back to primary feed using JCL scans.
o Use data dictionary, preferably implemented in Brio or IR, to document business meanings of data elements.
o Hanlde multiple threads of content within data lineage.
o Query usage and relation tables for tables and views to establish dependencies and denormalization.
o Use Teradata utilities proficiently.
o Understand mainframe JCL.
o Use SQL proficiently.
o Work easily with cross-platform data transport
* Knowledge of SAP environment and tools
o Develop OpenHub extracts from BW
o Research SAP for data corresponding to extract requirements, including ECC and BW
o Combine existing SAP data components to provide compostie DSO or infocube as source for OpenHub extract.

  Contact Information
Reference Name (If Any): 

Terms and Conditions | Privacy Policy | FAQ | Contact Us | Why?? | Link to us