• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 17th Dec 2020

Job Description – Hadoop+ Informatica Developer

Chandler AZ Charlotte NC
Desired Skills and Competencies
• 8-9 years of Solid experience in informatica Development with knowledge in developing UNIX Shell Script, Oracle SQL/ PL-SQL, Autosys
• Hands on experience in Data analysis, Data Modelling, complex SQL skills, Hadoop, Spark, Informatica and excellent communication skills.

Domain Knowledge: Resource should have strong business knowledge in Commercial Capital Transformation for Commercial Distribution Finance

Role Description
• Hands-on development experience in informatica PowerCenter Client Tools (Designer, Workflow manager/Monitor).
• Hands on experience in Data analysis, Data Modelling, complex SQL skills, Hadoop, Spark, Informatica and excellent communication skills.
• Extensive experience with developing, unit testing, break/fix support of informatica ETL.
• Good knowledge in developing UNIX scripts, Oracle SQL/PL-SQL, Autosys JIL Scripts.
• Good communication with excellent problem-solving skills.
• Excellent understanding of Teradata Concepts and Architecture
• Good understanding of BigData concepts and tools
• Good hands on experience in Data Analysis
• Very good knowledge of Advanced Teradata concepts like Join strategy, Index choice (AJI's), Performance Optimization, Compression, etc.
• Strong hands on experience using Teradata utilities (B-TEQ, Fast Load, MultiLoad, FastExport, TPT, Viewpoint) and Teradata Parallel Transporter (TPT).
• Expertise in improving Teradata job performance and Tuning.

Responsibilities.
• Analysis of mapping Documents provided by Business. Perform technical analysis and ensures that all the standard requirements have been met.
• Develop using Informatica, Oracle SQL and deliver in bi-weekly Sprint model.
• Develop the code by following all coding standards and performance optimization standards.
• Participate in peer review and document the review comments.
• Aligned with Stream leads and deliver the code with in SLA once Jira is assigned to you.
• Good communication skills to Interact with Business Customers, Production Support, QA, BA and DBA's with downstream applications based on need basis.
• Support Upper environment deployments and production failure analysis and fixes.
Support all production releases packaging/deployment/validation/execution of jobs on need basis.