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.
Title:
Teradata ETL Developer : Teradata Utilities, Mainframe JCL, SAP, MQ : Atlanta, GA
Posted On:
1/20/2021 2:43:14 AM
Designation:
Teradata ETL Developer
No. of vacancies:
4
Qualifications:
Bacholers Degree
Minimum Total Experience:
5
Job Tenure:
Full-time Only
Salary Offered:
DOE
Job Location:
Atlanta
GA
United States
Skills Required:
* Gather system design requirements, design and write system
specifications
* 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.