ETL Informatica with Datawarehouse

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

Job summary

A leading IT consulting firm in Fort Worth is seeking an experienced ETL Developer to join their team. The role requires over 2 years of experience specifically with Informatica and extensive expertise in ETL processes within a data warehousing environment. The ideal candidate will also have proficiency in UNIX/Shell scripting and a Bachelor's degree. This is a full-time permanent position, and U.S. citizens and Green Card holders are encouraged to apply.

Qualifications

• 2+ years of experience in ETL and BI project development.
• Extensive knowledge in Informatica for data warehousing.
• Experience in system analysis, design, development, testing, and implementation.

Responsibilities

• Develop and maintain ETL processes using Informatica.
• Work with business analysts to understand requirements.
• Conduct performance tuning and identify bottlenecks in systems.

Skills

ETL

Informatica

UNIX/Shell scripting

Performance tuning

Business Intelligence

Education

Bachelor’s degree or foreign equivalent

Tools

Cognos

Power Exchange

Job description

Career Guidant, an internationally acclimed, trusted multi-faced orgiansation into Information Technology Custom Learning Services for Enterprises, Lateral Staffing Solutions, Information Technology Development & Consulting, Infrastructure & Facility Management Services and Technical Content development as core competencies. Our experienced professionals bring a wealth of industry knowledge to each client and operate in a manner that produces superior quality and outstanding results.

Career Guidant proven and tested methodologies ensures client satisfaction being the primary objective. Committed to our core values of Client Satisfaction, Professionalism, Teamwork, Respect, and Integrity.

Career Guidant with its large network of delivery centres,support offices and Partners across India, Asia Pacific, Middle East, Far East, Europe, USA has committed to render the best service to the client closely to ensure their operation continues to run smoothly. Our Mission

"To build Customer satisfaction, and strive to provide complete Information Technology solution you need to stay ahead of your competition" If you have any queries about our services.

Job Description

Required

• 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

Personal

• High analytical skills
• A high degree of initiative and flexibility
• High customer orientation
• High quality awareness

Qualifications

Basic

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of experience with Information Technology

Additional Information

U.S. citizens and those authorized to work in the U.S. are encouraged to apply.

• This is a Full-Time Permanent job opportunity for you.
• Only Citizen and Green Card Holder can apply.
• No OPT-EAD & H1B Consultants please.
• Please mention your Visa Status in your email or resume.