ETL Informatica

SmartRecruiters, Inc.; Fort Worth (TX); On-site; USD 75,000 - 110,000; Full time

Job summary

Career Guidant in the United States seeks an experienced Informatica ETL Developer to join our data warehousing team in Fort Worth. You will design, develop, test, and deploy ETL solutions, collaborate with business analysts, and ensure data quality across enterprise systems.

The ideal candidate has 2+ years in ETL and BI lifecycle, hands-on UNIX scripting, and a strong grasp of data modeling, performance tuning, and cross-functional delivery in a global environment.

Qualifications

• 2+ years of experience in ETL, reporting technologies and BI project lifecycle.
• Should have worked extensively in development projects involving Informatica.
• Experience in Enterprise data warehousing, system Analysis, Design, Development, Testing and Implementation of Data warehouse.
• Experience in all the phases of Data warehouse life cycle (SDLC).
• Experience in translating requirements into ETL code and building mappings/workflows in Informatica.
• Experience in Informatica performance tuning/partitions and bottleneck identification.
• Ability to work in a diverse, multi-stakeholder environment.
• Experience in Retail, CPG and Logistics Domain.
• Hands on UNIX/Shell scripting, Putty.

Responsibilities

• Collaborate with business analysts to translate requirements into ETL code.
• Develop mappings and workflows in Informatica using sessions and transformations.
• Tune Informatica performance and optimize mappings.
• Contribute to all phases of the data warehouse SDLC from requirements to deployment.
• Participate in a global delivery environment with cross-functional teams.

Skills

Informatica

ETL

Data warehousing

UNIX/Shell scripting

SDLC

Business analysis

Team collaboration

Retail/CPG/Logistics domain

Education

Bachelor’s degree or foreign equivalent

Tools

Informatica

PowerExchange

IDQ

Cognos

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

Basic

• 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

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

Qualifications

• 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.

Additional Information

• U.S. citizens and those authorized to work in the U.S. are encouraged to apply.
• 1.This is a Full-Time Permanent job opportunity for you.
• 2.Only Citizen and Green Card Holder can apply.
• 3.No OPT-EAD & H1B Consultants please.
• 4.Please mention your Visa Status in your email or resume.