Teradata Architect
Company Name:
Maccadin Inc.
Required Competencies:
The candidate should possess strong data analytical skills
Progressive and varied experience in SDLC (software development life cycle) for Data Warehouse applications on Teradata.
Experience with Teradata 14.0 and above.
Extensive experience in development and deployment of Data Warehouse solutions
Proficient in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC
(change data capture), Audit table, Error Handling Techniques for ETL process.
Experience with large volume database and their performance tuning.
Strong understanding of Data Warehouse concepts and well versed with Bill Inmon's 3NF modeling and Ralph Kimball's Dimensional modeling,
with Erwin skills.
Experience in physical modeling with knowledge to use Primary, Secondary, PPI and Join Index
Experience with MLoad, BTeq , MultiLoad, Tpump, TPT FastExport, Informatica PDO and FastLoad to design and develop dataflow paths
for loading transforming and maintaining Data Warehouse.
Experience in modeling using tools like ErWin and using industry standard data models like Teradata model for Life Sciences.
Experience with Windows 7, IE 8, Vista, XP, Office 2007/2010
Experience with Data and Issue analysis using SQL
Solid verbal and written communication skills, with the demonstrated ability to communicate complex technical topics to team, managers and
non-technical audiences.
Highly Desirable:
Experience in integration with Cognos BI 10 and later version
Experience with Tibco Spotfire reporting.
Experience with Informatica 9.0 or above
Teradata Certifications
Suppy Chain Domain experience
Experience within HealthCare/Pharmaceutical industryEstimated Salary: $20 to $28 per hour based on qualifications.
Maccadin Inc.
Required Competencies:
The candidate should possess strong data analytical skills
Progressive and varied experience in SDLC (software development life cycle) for Data Warehouse applications on Teradata.
Experience with Teradata 14.0 and above.
Extensive experience in development and deployment of Data Warehouse solutions
Proficient in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC
(change data capture), Audit table, Error Handling Techniques for ETL process.
Experience with large volume database and their performance tuning.
Strong understanding of Data Warehouse concepts and well versed with Bill Inmon's 3NF modeling and Ralph Kimball's Dimensional modeling,
with Erwin skills.
Experience in physical modeling with knowledge to use Primary, Secondary, PPI and Join Index
Experience with MLoad, BTeq , MultiLoad, Tpump, TPT FastExport, Informatica PDO and FastLoad to design and develop dataflow paths
for loading transforming and maintaining Data Warehouse.
Experience in modeling using tools like ErWin and using industry standard data models like Teradata model for Life Sciences.
Experience with Windows 7, IE 8, Vista, XP, Office 2007/2010
Experience with Data and Issue analysis using SQL
Solid verbal and written communication skills, with the demonstrated ability to communicate complex technical topics to team, managers and
non-technical audiences.
Highly Desirable:
Experience in integration with Cognos BI 10 and later version
Experience with Tibco Spotfire reporting.
Experience with Informatica 9.0 or above
Teradata Certifications
Suppy Chain Domain experience
Experience within HealthCare/Pharmaceutical industryEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
