ETL Informatica Developer

Smartbridge - Houston, TX

Full-time - Mid Level

Houston, TX

Professional, Scientific, and Technical Services

About the position

We are seeking an experienced ETL Informatica Developer to design and develop scalable ETL processes and Data Warehouses (EDW) using tools such as Microsoft SQL Server, Oracle, Netezza, and Informatica. The role requires a strong understanding of Data Warehouse architecture, business intelligence systems, and the ability to work collaboratively with business users and technical teams. As part of our dynamic and successful professional services organization based in Texas, you will be responsible for delivering high-quality data solutions to a diverse set of clients. In this role, you will ensure that projects are completed on-time, within budget, and meet client goals. You will implement best practices for data movement, quality, and cleansing, while adhering to local standards for all developed components. You will maintain multi-terabyte data warehouses with nightly updates within a team environment and manage ETL repositories, backups, and multi-project environments. Additionally, you will maintain common code libraries, manage code check-in/check-out procedures, and oversee all environments including Development, System Test, and Production. Documentation is a key aspect of this role, where you will document designs, develop data maps, ensure data quality, and conduct unit tests. You will participate in requirements, design, and development reviews, engaging with system component owners to understand current data and systems environments. Analyzing source system data for quality, developing strategies for handling anomalies, and designing ETL processes will also be part of your responsibilities. You will utilize Informatica for data extraction, transformation, and loading, developing, testing, integrating, and deploying ETL routines. In a support role, you will assist in administering and maintaining the ETL environment, including configuration management activities. Problem-solving will be essential as you identify issues, propose solutions, and present recommendations to colleagues and management.

Responsibilities

• Ensure projects are completed on-time, within budget, and meet client goals.
• Implement best practices for data movement, quality, and cleansing.
• Maintain multi-terabyte data warehouses with nightly updates within a team environment.
• Manage ETL repositories, backups, and multi-project environments.
• Maintain common code libraries, manage code check-in/check-out procedures, and oversee all environments (Dev, System Test, Production).
• Document designs, develop data maps, ensure data quality, and conduct unit tests.
• Participate in requirements, design, and development reviews.
• Engage with system component owners to understand current data and systems environments.
• Analyze source system data for quality, develop strategies for handling anomalies, and design ETL processes.
• Use Informatica for data extraction, transformation, and loading.
• Develop, test, integrate, and deploy ETL routines.
• Assist in administering and maintaining the ETL environment, including configuration management activities.
• Identify issues, propose solutions, and present recommendations to colleagues and management.

Requirements

• Bachelor's degree in Business, Computer Science, Management Information Systems, Engineering, or related field.
• 5+ years of business/technology work experience.
• 3+ years of hands-on experience with Informatica.
• Experience with SQL Server, Oracle, MySQL, Netezza, and/or DB2; Teradata is a plus.
• Working knowledge of BI architecture and data warehousing concepts.
• Proficiency with Informatica tools (PowerCenter, PowerExchange, InformaticaCloud).
• Familiarity with Data Quality Tools (Informatica Data Quality, Address Doctor, Identity Resolution).
• Knowledge of Data Management Tools (Informatica MDM, Data Masking, Cloud MDM, Changed Data Capture).
• Experience with Data Replication Tools (Database Archiving, Test Data Management, Fast Clone).
• Strong interpersonal skills, able to work well with client personnel.
• Excellent organizational, time management, and problem-solving skills.

Nice-to-haves

• Experience with Teradata is a plus.
• Familiarity with Data Quality Tools such as Informatica Data Quality, Address Doctor, Identity Resolution.