Vacancy expired!
- Designs and implements industry best ETL technologies to satisfy client requirements
- Designs and develops optimal code to maintain exceptional performance in processing large volumes of data across diverse sources
- Gathers and translates business requirements into analytical applications.
- Collaborates with other project members and drive the development of BI initiatives.
- Designs, develops, and tests ETL solutions including modeling data warehouse metadata and automating data loading processes.
- Establishes ETL environments according to project requirements
- Design and develop ETL processes to satisfy all program area requirements
- Develops and implements an efficient migration process to move ETL objects from development to test and production environments
- Supports the project team throughout the design, development and testing process
- Participates in all design reviews and requirement sessions, if required
- Supports project documentation as required
- Understands database design, programming concepts, data modeling and framework management.
- Supports star schema modeling and implementation of a data warehouse
- Communicates ideas to both technical and non-technical people in all levels of the organization.
- Effectively communicates technical architecture details of INFORMATICA and other parts of the BI solution to others
- Develops advanced, and complex INFORMATICA
- Works with Business Analysts, Data Architects, Enterprise Architects and ETL Architects to ensure business requirements are being met with the solution being developed.
- Identify and reuse of ETL components and services to avoid duplicative implementations
- Mentor other team members in developing, documenting and modifying ETL components
- Support and administer the INFORMATICA environments
- Full understanding and experience in implementing BI solutions and data warehousing is required
- Full understanding of INFORMATICA 9 is required especially dealing with very large volumes of data, real time or micro batches
- Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing, database and tool optimization techniques and other such data architecture best practices is required.
- Excellent oral and written communication skills is required
- Excellent Analytical skills required
- Flexibility/Adaptability is required, especially when working in a large team
- Good Organization and Time Management skills required
- Attention to Detail is required
- Ability to Multi-task is required
- Data architecture and modeling experience implementing proper data structures for a BI solution using tools such as INFORMATICA and COGNOS is required.
- INFORMATICA 8 or 9 Certification
- Scrum Master Experience or Certification
- Data Warehousing – 5 year(s)
- ETL – 5 year(s)
- Informatica – 5 year(s)