SMX Services & Consulting, Inc. · 7 hours ago
ETL Developer Informatica (CPI-PC o IDMC)
United States
Contract
Remote
Mid, Senior Level
3+ years expSMX Services & Consulting, Inc. is seeking an experienced ETL Developer with strong expertise in cloud technologies to design, develop, and maintain robust data integration solutions. The role involves extracting, transforming, and loading data from multiple sources into enterprise data warehouses and operational data stores, ensuring accuracy, scalability, and performance.
Information ServicesInformation Technology
Responsibilities
Design, develop, and deploy ETL workflows and mappings using Informatica PowerCenter
Analyze business requirements and translate them into technical ETL solutions
Optimize data integration processes for performance, scalability, and reliability
Work with relational databases (Oracle, SQL Server, DB2, etc.) to extract and load data
Perform data profiling, validation, and quality checks to ensure accuracy and consistency
Monitor, troubleshoot, and resolve ETL job failures in production environments
Collaborate with data architects, business analysts, and stakeholders to support reporting and analytics needs
Document ETL processes, technical specifications, and data flow diagrams
Ensure compliance with data governance, security, and best practices
Qualification
Required
Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience)
3-5+ years of hands-on ETL development experience, with a focus on Informatica PowerCenter
Strong experience with Data Masking Transformation
Strong SQL and database skills (query tuning, stored procedures, indexing)
Experience with data warehousing concepts (star schema, snowflake, slowly changing dimensions)
Familiarity with job scheduling tools (Control-M, Autosys, or similar)
Understanding of data governance, metadata management, and data quality principles
Strong problem-solving and debugging skills
Excellent communication and collaboration abilities
Preferred
Experience with cloud data platforms (AWS, Azure, GCP, Snowflake)
Knowledge of Informatica Cloud (IICS) or other ETL tools
Familiarity with Python or shell scripting for automation and Java
Knowledge of IBM Cognos
Exposure to Agile/Scrum environments
Company
SMX Services & Consulting, Inc.
Driving the Future with Technology, Talent, and Strategic Solutions At SMX Services & Consulting, Inc., we transform the way businesses manage their technology and talent by providing comprehensive solutions in IT & Engineering Staffing, SAP, Cybersecurity, Managed Services, and Digital Health.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Richard Quevedo
CEO
Steve Hodges
Chief Technology Officer
Company data provided by crunchbase