Must Have
- Designing and implementing ELT pipelines using Informatica (PowerCenter / IDMC)
- Strong SQL and data transformation techniques
- Experience with data platforms (RDBMS, cloud data warehouses, big data ecosystems)
- Data orchestration tools (Airflow or similar) and scheduling frameworks
- Data quality validation, reconciliation, and audit frameworks
- DevOps practices, CI/CD pipelines, and version control for ETL/ELT deployments
- Ability to own end-to-end delivery from design and development through deployment and production support
- Production support, troubleshooting, performance tuning, and root cause analysis
- Data warehousing concepts and data modeling
Nice to Have
- Experience with distributed and event-driven architectures
- Near real-time and high-volume batch data processing
- Cloud-based data integration platforms
Key Responsibilities
- Design, develop, and support scalable enterprise ELT data pipelines using Informatica.
- Build high-performance batch and near real-time data integration solutions.
- Develop and optimize SQL queries and data transformations.
- Implement data quality, reconciliation, and audit controls.
- Monitor, troubleshoot, and support production data platforms.
- Work with Airflow and scheduling frameworks for workflow orchestration.
- Leverage DevOps, CI/CD, and version control best practices.
- Collaborate with business, data, and downstream application teams to deliver enterprise-grade data solutions.
- Drive end-to-end delivery from requirements through production support.
Soft Skills
- Strong written and verbal communication
- Excellent collaboration and stakeholder management
- Ability to work independently in a fast-paced Agile environment