Job Description :

Role: Teradata lead

Location: North Carolina

Experience:9+ years



Primary Skillset

Skill/Role details


Infa -pc, Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT, Teradata Studio


North Carolina


Informatica Powercenter ETL – Tech Lead

§  Experience in Life Science Domain, should be able to handle Business queries and relate it to the data in the back end.

§  Experience in Informatica Power Center 9.x and above (ETL - Designer, Workflow Manager), Job Schedulers.

§  Must have experience in building complex SQL queries and Shell scripting.

§  Strong on DW Fundamentals & DW concepts.

§  Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.

§  Extensive experience in Data Modeling & Architecture.

§  Experience in full lifecycle data warehouse development.

§  Excellent understanding of various relational database design concepts.

§  Experience in managing BI App Support & Maintenance projects.

§  Experience in Data Migration and Data Quality initiatives.

§  Error handling and Performance Improvements.

§  Conduct and participate in design and code walkthroughs.

§  Good hands on capability - can independently develop good quality deliverable and guide/mentor junior team members effectively.

§  Participate in requirements gathering sessions with stakeholders from business and IT teams.

§  Communicates effectively with business partners to identify needs and evaluate options.

§  Help BI reporting developers with analyzing data source, designing, testing and implementing Analytics reports and dashboards

Teradata – Tech Lead

§  Expertise in writing, re-writing and dissecting complex SQL queries using multiple join conditions, case statements, arithmetic, aggregate functions and query tuning/optimization techniques.

§  In depth, practical knowledge of Data Warehousing concepts.

§  Strong Experience in performance tuning-required with Teradata.

§  Strong expertise in reengineering system applications and processes.

§  Experience with Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT and Query manager.

§  Strong expertise in understanding data modeling involving logical and physical data model-preferred.

§  Experience in designing processes involving Star/Snowflake schema and creating source to target data mapping based on the project needs.

§  Experience in implementing data Warehouse applications(ETL). Ability to design, build, deploy and support end to end ETL processes.

§  Exposure and ideally hands on experience with Teradata Studio




Similar Jobs you may be interested in ..