Developer Informatica
EXCELHIRE
Dallas, TX
Apply
JOB DETAILS
LOCATION
Dallas, TX
POSTED
30+ days ago
Location: USA,Texas,Dallas
Job Summary:
We are seeking a skilled Informatica Developer to design, develop, and maintain ETL (Extract, Transform, Load) processes and data integration workflows using Informatica PowerCenter. The ideal candidate will have strong experience in data warehousing, SQL, and performance tuning to ensure high data quality and reliability across systems.
Key
Responsibilities
:Design, develop, and implement ETL solutions using Informatica PowerCenter.
Analyze business and technical requirements to develop data mappings and workflows.
Perform data profiling, cleansing, and transformation tasks to support data integration efforts.
Optimize existing ETL processes for performance, scalability, and maintainability.
Collaborate with data architects, analysts, and stakeholders to understand data needs.
Troubleshoot and resolve ETL job failures and performance issues.
Maintain and document ETL architecture, processes, and data flow diagrams.
Ensure compliance with data governance and security policies.
Support data migration and integration projects across multiple environments (Dev, QA, Prod).
Required Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or a related field.
3+ years of experience working with Informatica PowerCenter or other Informatica products.
Strong SQL skills and experience with relational databases (e.g., Oracle, SQL Server, MySQL).
Knowledge of data warehousing concepts, star/snowflake schema, and dimensional modeling.
Experience with performance tuning of ETL jobs and database queries.
Familiarity with job scheduling tools (e.g., Autosys, Control-M) and version control systems.
Excellent problem-solving and communication skills.
Preferred Qualifications:
Experience with Informatica Cloud or other iPaaS tools.
Knowledge of big data platforms (e.g., Hadoop, Spark) or cloud platforms (AWS, Azure, GCP).
Exposure to reporting tools such as Tableau, Power BI, or Cognos.
Familiarity with Agile development methodologies.
About the Company
E