Company Description
Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.
With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.
Job Description
Role : ETL Architect
Location: Cincinnati OH
Long term
Primary Skill: Informatica IDMC, Snowflake
We are looking for a IDMC developer to join our Data leverage team – a team of high-energy individuals who thrive in a rapid-pace and agile product development environment. As a Developer, you will provide accountability in the ETL and Data Integration space, from the development phase through delivery. You will work closely with the Project Manager, Technical Lead, and client teams. Your prime responsibilities will be to develop bug free code with proper unit testing and documentation. You will provide inputs to planning, estimation, scheduling, and coordination of technical activities related to ETL-based applications.
You will be responsible for meeting development schedules and delivering high-quality ETL-based solutions that meet technical specifications and design requirements ensuring customer satisfaction. You are expected to possess good knowledge in one or more of these ETL tools – IDMC, Informatica, and Matillion.
Responsibilities
- Experience in Informatica Cloud Data Integration -- processes by constructing mappings, tasks, task flows, schedules, and parameter files
- Good understanding of ETL and ELT best practices and experience with ETL and ETL Mapping documentation
- Good understanding of database designs / SQL
- Good understanding of SDLC and Agile Methodologies
- Experience with Linux and Windows Server environments
- Strong problem-solving skills and analytical skills with proven strength in applying root-cause analysis
- Ability to communicate verbally and in technical writing to all levels of the organization in a proactive, contextually appropriate manner
- Strong teamwork and interpersonal skills at all levels
- Dedicated to excellence in one’s work; strong organizational skills; detail-oriented and thorough
- Hands on experience on support activities, able to create and resolve the tickets – Jira, ServiceNow
Skills & Experience
- Strong experience in ETL tools – IDMC(Primary), Informatica (Secondary)
- Experience of working in Onsite/Offshore model
- 5+ years of experience in Informatica, with 2+ years of experience in IDMC inclusive
- 2+ years of experience in snowflake
Additional Information
All your information will be kept confidential according to EEO guidelines.
Top Skills
What We Do
DEREX Technologies, Inc. established in 1996 is engaged nationally in providing professional computer services, including management consulting firm. We provide expert services nationwide to Fortune 500 companies and other private and public organizations in the United States. Derex provides a multi-faceted portfolio of products and services to its clients, including complete IT solutions.
