DL
Informatica, Tableau, Oracle
Diverse Lynx India
Location not stated
Mid level
2 months ago
- ETL
- Informatica
- Oracle
- SQL
- PL/SQL
- Tableau
- Unit Testing
- Change Management
- Oracle Database
- Data Modeling
- Snowflake
- Agile
2 months ago
Job Summary
We are seeking an experiencedETL Developer with6+ years of hands-on experience in designing, developing, and maintaining enterprise ETL solutions. The ideal candidate should have strong expertise inInformatica PowerCenter, Oracle (SQL/PL/SQL), and Tableau, along with a solid understanding of data warehousing concepts and data integration best practices.
Employment Details
- Employment Type: Full-time
- Work Mode: Hybrid
- Location: Pan India
- Shift: 9:30 AM – 6:30 PM
- Design, develop, test, and maintain ETL workflows using Informatica PowerCenter.
- Develop and optimize SQL and PL/SQL scripts, stored procedures, functions, and packages in Oracle.
- Build and maintain robust ETL pipelines for extracting, transforming, and loading data from multiple source systems into enterprise data warehouses.
- Perform data validation, reconciliation, and ensure data quality across ETL processes.
- Monitor ETL jobs, troubleshoot production issues, and optimize workflow performance.
- Develop and support Tableau dashboards and reports to meet business reporting requirements.
- Collaborate with business analysts, data architects, and cross-functional teams to understand business requirements and deliver scalable data solutions.
- Participate in code reviews, unit testing, deployment, and production support activities.
- Prepare and maintain technical documentation for ETL mappings, workflows, and data flows.
- Follow best practices for ETL development, performance tuning, and change management.
- Informatica PowerCenter
- Oracle Database (SQL/PL/SQL)
- Tableau
- ETL Development
- Data Warehousing Concepts
- Strong SQL and PL/SQL programming
- Data Integration and Data Mapping
- ETL Performance Tuning and Optimization
- Experience with dimensional data modeling (Star Schema/Snowflake Schema).
- Knowledge of SDLC and Agile methodologies.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent communication and stakeholder management skills.
Interview Process
- Round 1: Virtual Interview
Informatica, Tableau, Oracle · Diverse Lynx India