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: Informatica ETL Developer
Location: Erie, PA (Day-01 Onsite)
Job Description
Responsibilities:
- Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, Power Exchange, and other related technologies.
- Data Integration: Collaborate with business analysts and data architects to translate business requirements into technical specifications and implement efficient data integration solutions.
- Performance Optimization: Optimize ETL processes for performance and efficiency, ensuring minimal downtime and maximum throughput.
- Data Quality and Integrity: Ensure data quality and integrity throughout the ETL process, implementing data validation and cleansing routines.
- Testing and Troubleshooting: Conduct unit and integration testing of ETL processes, troubleshoot issues, and provide post-production support.
- Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and workflows.
- Collaboration: Work closely with cross-functional teams to define data requirements and contribute to database design decisions.
Qualifications:
- Educational Background: Bachelor’s or master’s degree in computer science, Information Systems, or a related field.
- Experience: 5-8 years of experience in ETL development, with a strong focus on Informatica tools.
- Technical Skills:
- Proficiency in Informatica PowerCenter and other Informatica products.
- Strong SQL skills and experience with databases like Azure DB and SQL Server
- Knowledge of data warehousing concepts and BI architecture.
- Knowledge of Insurance, Guidewire Policy Center and Policy Migration Tool will be added advantage.
- Experience with UNIX/Linux scripting and scheduling tools.
- Familiarity with data modeling techniques and schema designs (e.g., star, snowflake schemas).
- Soft Skills:
- Excellent problem-solving and analytical skills.
- Strong communication and teamwork abilities.
- Ability to work independently and manage multiple tasks simultaneously.
Regards,
Manoj
Derex Technologies INC
Contact : 973-834-5005 Ext 206
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.
