What are the responsibilities and job description for the Sr Informatica Developer with Strong Tableau Dashboard Experience position at IT America?
Title : Sr Informatica Developer with Strong Tableau Dashboard Experience
Location: Remote
Duration : Long-term
Job Summary
We are looking for a highly skilled Senior Informatica Developer with strong experience in data integration, ETL development, data warehousing, and Tableau dashboard development. The ideal candidate will be responsible for designing, developing, and maintaining ETL workflows using Informatica and creating interactive Tableau dashboards to support business reporting and data analytics.
Key Responsibilities
- Design, develop, and maintain ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
- Develop complex mappings, mapplets, sessions, workflows, and reusable ETL components.
- Perform data extraction, transformation, loading, data cleansing, and data validation.
- Develop and maintain interactive Tableau dashboards, reports, worksheets, and visualizations.
- Connect Tableau to databases, data warehouses, and other data sources.
- Create calculated fields, parameters, filters, LOD expressions, and dashboard actions in Tableau.
- Optimize Tableau dashboards and Informatica workflows for performance and scalability.
- Write complex SQL queries, stored procedures, and database validation scripts.
- Work with business analysts and stakeholders to understand reporting requirements and translate them into technical solutions.
- Perform unit testing, integration testing, troubleshooting, and production support.
- Ensure data quality, consistency, accuracy, and integrity across reporting systems.
- Document technical specifications, ETL mappings, dashboard designs, and development processes.
Required Technical Skills
- Strong hands-on experience with Informatica PowerCenter and/or Informatica IDMC.
- Strong Tableau dashboard development experience.
- Expertise in ETL development, data integration, and data warehousing concepts.
- Strong SQL skills, including complex joins, subqueries, aggregations, and performance tuning.
- Experience with relational databases such as Oracle, SQL Server, Snowflake, or Teradata.
- Experience with Tableau Desktop, Tableau Server, published data sources, and dashboard optimization.
- Knowledge of data modelling, star and snowflake schemas, and dimensional modelling.
- Experience with ETL debugging, performance tuning, and production issue resolution.
- Strong analytical, communication, and problem-solving skills.
Preferred Skills
- Experience with cloud data platforms such as AWS, Azure, or Snowflake.
- Knowledge of Informatica Cloud Data Integration and cloud-based ETL pipelines.
- Experience with Tableau extracts, live connections, and data refresh scheduling.
- Familiarity with Git, deployment processes, and Agile/Scrum methodologies.