Job Description :

ETL Developer with Informatica (Mid to Senior Level : 8-10 years)

Location: Baltimore, MD/Fairfax, VA (Initial Remote and Onsite as needed)

Duration: 9-12 months (Extendible)

Locals preferred

  1. Provides ETL processing subject matter expertise to client projects
  • 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
  1. Key Attributes for this role include:
  • 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
  1. Nice to Have:
  • 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

Skills:

  • Data Warehousing 5 year(s)
  • ETL 5 year(s)
  • Informatica 5 year(s)
  • Oracle/SQL 5 year(s)
             

Similar Jobs you may be interested in ..