Vacancy expired!
Job Description
​Seeking an Informatica Developer to join ETL team to build and maintain Enterprise Data Warehouse that serves the reporting and analytical needs for business and IT consumers. This position will be responsible for SDLC of Data Integration projects that involves, but not limited to, preparing the detailed technical design documents from functional requirement documents, design and develop ETL framework, setting up the DB application schemas and developing database code, unit and system testing of end-to-end integration, release management and production support as needed.
RESPONSIBILITIES:
Understand the business requirements and translate them into Detailed Design Technical documents
Create the end-to-end solution for ETL transformational jobs that involve writing the Informatica workflows and mappings, procedures and functions and UNIX shell scripting
Promote the fully tested and qualified code into upper environments
Troubleshoot the bottlenecks on source, integration and target phases and fine tune code or environments appropriately
Qualifications
MINIMUM QUALIFICATIONS:
- 3-5 years of experience in Data Integration projects working on ETL framework for Data Warehouse projects preferably using Informatica 9.x
- Hands on experience creating mappings, mapplets, sessions, workflows, and worklets
- Performance tuning techniques on mapping and session levels (DTM buffer/block size configurations, partitioning etc.)
- 3-5 years of experience in DB2 database development for data warehouse project working on:
- Writing complex SQL queries, PL SQL functions, procedures and packages
- Hands on experience in performance tuning of SQLs
- 2-4 years of experience with Unix shell scripting
- Working knowledge in data modeling, understating of various aspects of logical, conceptual and physical modeling of data warehouse projects
- Working knowledge in creating logical / physical data models using tools like Erwin or Embarcadero ER Studio, etc.
- Working knowledge in creating and maintaining Enterprise Data Dictionaries
- Working knowledge in Change Data Capture and Slowly Changing Dimensions
DESIRED QUALIFICATIONS:
- Experience Business Intelligence or DSS environment
- Experience with Apache Nifi is a plus
Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not transfer or sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity.
Additional Information
Position is full time (40 hours per week) Monday through Friday. We are a business professional attire company.
Expeditors offers excellent benefits:
- Paid Vacation, Holiday, Sick Time
- Health Plan: Medical, Prescription Drug, Dental and Vision
- Life and Long Term Disability Insurance
- 401(k) Retirement Savings Plan
- Employee Stock Purchase Plan
- Training and Personnel Development Program
All your information will be kept confidential according to EEO guidelines. Successful candidates must pass a background check.
Vacancy expired!