Informatica Consultant (GC-EAD,GC,USC)

Sonsoft Inc; Fort Worth (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

A growing software development firm is seeking a full-time ETL Developer with over 2 years of experience in Informatica and data warehousing. The ideal candidate will work in a global delivery environment, developing mappings and addressing bottlenecks in ETL processes. This role requires excellent analytical and communication skills. Only U.S. citizens and authorized workers can apply, as sponsorship is not available.

Qualifications

• 2+ years of experience in ETL and BI project development.
• Experience in development projects involving Informatica.
• Excellent verbal and written communication skills.

Responsibilities

• Develop Mappings and Mapplets using various Transformations.
• Work with business analysts to translate requirements into ETL code.
• Identify bottlenecks in sources, mappings, and sessions.

Skills

ETL

Informatica

BI project development

UNIX/Shell scripting

Data warehousing

Tools

Cognos

Power Exchange

Job description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Description:-

• 2+ years of experience in ETL, Reporting technologies and BI project development life cycle
• Should have worked extensively in development projects involving Informatica
• Experience in Enterprise data warehousing, system Analysis, Design, Development, Testing and Implementation of Data warehouse. Enhancement and Maintaining applications using ETL-INFORMATICA
• Experience in all the phases of Data warehouse life cycle (SDLC) involving Requirement Analysis, Design, Coding, Testing, and Deployment
• Experience in working with business analysts to identify, study and understand requirements and translate them into ETL code in Requirement Analysis phase
• Excellent experience in developing Mappings, Mapplets by using various Transformations like SQ, Aggregator, Expression, Filter, Sorter, Joiner, lookup, sequence generator and update strategy based on the business requirements and workflows by using various tasks like session, event wait, event raise, command, email to automation of workflows and sessions
• Experience in Informatica performance tuning/Partitions and identifying the bottle necks in sources, mappings, targets and sessions.
• Ability to work in team in diverse/ multiple stakeholder environment
• Experience in Retail, CPG and Logistics Domain.
• Experience and desire to work in a Global delivery environment
• Primary Technical Skills: Informatica
• Hands on experience in UNIX/Shell scripting, Putty.

Preferred:-

• Exposure to other BI ETL & other Reporting tools such as Cognos
• Exposure on Power Exchange, IDQ and other Informatica tools

Qualifications

Personal:-

• Besides the professional qualifications of the candidates we place great importance in addition to various forms personality profile. These include:
• High analytical skills
• A high degree of initiative and flexibility
• High customer orientation
• High quality awareness
• Excellent verbal and written communication skills

Additional Information

U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

• This is aFULL TIMEjob oppurtunity.
• OnlyUS Citizen,Green Card Holder,GC-EAD,H4-EAD,L2-EAD,TN VIsa can apply.
• No OPT-EAD & H1-B for this position.
• Please mention your Visa Status in youremailorresume.