Our DIRECT CLIENT is actively interviewing and hiring for a Sr Teradata Developer w/ Informatica with 10+ years' experience.
Start date is ASAP & in-person interviews will be conducted after telephonic.
Candidates have to attend in-person interviews & be able to start ASAP.
DIRECT Client: Hospitality
LOCATION: Parsippany, NJ
Duration: 6+ months
Start Date: ASAP
Interview Type: Phone & In-person
Teradata Developer w/ Informatica
Job Description :
Informatica Developer with Teradata
10 + years of expert level Informatica ETL experience is required.
Expertise in Informatica Power Center (9.x) is highly desired.
Expertise in Informatica (9.x) suite of products like PowerExhange, IDQ, IDE etc.
A minimum of 3 -4 years strong hands on experience in Informatica development with Teradata platforms is required.
Expertise in developing high performance code using Informatica ETL tool sets and Teradata load scripts/utilities.
Develop ETL solution using the tool sets from Teradata and Informatica to develop high performing ETL to processes with huge volume of data.
Document the application development process following AIM guidelines in preparing SOD,DDD, Unit test cases etc. is required.
Develop and test ETL and ELT modules based on design specification.
Develop, test, deploy and maintain ETL workflows for multiple data sources like flat files, XML, Teradata, DB2, Oracle, SQL Server.
Plan, test, and deploy ETL mappings, and database code as part of application build process across the enterprise.
Review ETL workflows for performance and recommend for process improvements.
Must also have a solid background in Informatica Transformations like lookups, source qualifier, update strategy, router, sequence generator, aggregator, rank, filter jointer, sorter, mapplets,
and other latest transformations like web services, Java etc.
Expertise in ETL performance tuning is required.
Extremely strong Teradata SQL skills.
Physical data modeling experience in Teradata.
Strong knowledge and current experience in Teradata query tuning, explain plans and performance triage/troubleshooting.
In depth and current knowledge of Teradata data distribution techniques and their applicability and usage.
Strong knowledge and recent experience in designing and implementing Teradata focused Primary Partitioning Indexes, Join Indexes, and other techniques for performance tuning.
Good understanding of Teradata parallel architecture and its physical implementation.
Experience using load Teradata utilities (standalone as well as with Informatica).
Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional Data base designs.
Strong understanding of fundamentals in dimensional Modeling (Star schema, Snowflake schema, Type 1/2/3 SCD's).
Experience with Software Development Lifecycle (SDLC) and AIM methodologies.
Coordinate between different business groups and Technical groups throughout HIT & other business units. Work within different IT teams to follow the full lifecycle development process working with PMO, BA, QMO, and Technical Services teams.
Ensure established ETL standards are followed. Strong problem diagnosis skills in developing ETL solution and Reusable Components
Provide day-to-day support for operational data needs.
Oversees offshore development team to oversee requirements and development efforts.
Working experience in UNIX shell environment. Scripting knowledge is a plus.
Knowledge of Trillium is a plus.
Please reply with expected rate, current location, work authorization and availability.
Regards,
Poonam Singh
Sr Marketing Executive
811 Church Road, Suite # 169
Cherry Hill, New Jersey-08002
Ph: 609-489-5259
Fax: 609-784-0929
Email: poonam@digipulsetech.com
No comments:
Post a Comment