Smartbridge · 2 days ago

ETL Informatica Developer

Houston, TX

Full-time

Hybrid

Mid, Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

AnalyticsConsulting

Insider Connection @Smartbridge

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Project Delivery: Ensure projects are completed on-time, within budget, and meet client goals.

ETL Development: Implement best practices for data movement, quality, and cleansing. Adhere to local standards for all developed components.

Data Warehouse Management: Maintain multi-terabyte data warehouses with nightly updates within a team environment.

Repository Management: Manage ETL repositories, backups, and multi-project environments.

Code Management: Maintain common code libraries, manage code check-in/check-out procedures, and oversee all environments (Dev, System Test, Production).

Documentation: Document designs, develop data maps, ensure data quality, and conduct unit tests.

Collaboration: Participate in requirements, design, and development reviews. Engage with system component owners to understand current data and systems environments.

Data Analysis: Analyze source system data for quality, develop strategies for handling anomalies, and design ETL processes.

Informatica Utilization: Use Informatica for data extraction, transformation, and loading. Develop, test, integrate, and deploy ETL routines.

Support Role: Assist in administering and maintaining the ETL environment, including configuration management activities.

Problem Solving: Identify issues, propose solutions, and present recommendations to colleagues and management.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

5+ years business/technology work experience3+ years hands-on experience InformaticaSQL ServerOracleMySQLNetezzaDB2TeradataBI architecture knowledgeData warehousing concepts knowledgeInformatica tools proficiencyInformaticaCloud proficiencyData Quality Tools familiarityData Management Tools knowledgeData Replication Tools experienceMotivatedCritical thinkerSolution-oriented interpersonal skillsWorks well independentlyWorks well within a team organizational skillsTime management skillsProblem-solving skillsProfessional demeanorClient locations