Job Summary
Sr Architect will design and optimize robust enterprise data integration solutions using ETL SQL and Informatica Powercenter within a hybrid work model. The role focuses on creating scalable data architectures improving data quality and enabling reliable analytics for business teams driving better decisions and long term organizational value for a global MNC environment.
Responsibilities
Design comprehensive data integration architectures that align with enterprise standards and support complex analytical and reporting needs across multiple business domains.Oversee end to end ETL solution design using Informatica Powercenter and SQL ensuring efficient data flows high performance and consistent data quality in production environments.Provide detailed technical guidance to development and operations teams on ETL patterns coding standards and reusable components that improve maintainability and scalability.Develop optimized SQL queries views and data access structures that support high volume workloads while minimizing resource usage and improving response times.Coordinate with data analysts and business stakeholders to translate data requirements into robust technical specifications and integration designs that are practical and sustainable.Implement data quality checks validation rules and reconciliation processes in ETL workflows to ensure accuracy completeness and reliability of critical business data.Conduct performance tuning and capacity planning for ETL jobs and database interactions proactively identifying bottlenecks and recommending targeted improvements.Review existing data pipelines and integration processes proposing modernization strategies that increase automation reduce manual interventions and enhance resilience.Collaborate with infrastructure and security teams to ensure that data integration solutions comply with organizational policies and meet nonfunctional requirements related to security and compliance.Document architectural decisions data flow diagrams and solution blueprints in a clear and structured manner to support knowledge sharing and ongoing maintenance.Evaluate new features and best practices in Informatica Powercenter and related data technologies recommending adoption paths that align with strategic business goals.Guide estimation planning and risk analysis for data integration initiatives helping project teams set realistic timelines and resource needs based on architectural complexity.Support production readiness activities by defining operational procedures monitoring strategies and incident handling approaches tailored to critical ETL workloads.Qualifications
Possess seven to eleven years of experience in data engineering or architecture roles with a strong focus on designing and implementing enterprise scale ETL solutions.Demonstrate advanced expertise in Informatica Powercenter including mapping design workflow orchestration and error handling strategies for complex data integrations.Show strong proficiency in SQL and relational database concepts with proven ability to design efficient schemas queries and indexes for high performance data operations.Apply practical knowledge of data warehousing principles dimensional modeling and integration patterns that support reliable reporting and analytics across functions.Exhibit solid understanding of hybrid work delivery models and effective collaboration practices using digital tools to coordinate with distributed technical and business teams.Bring experience working in large multinational environments with standard processes for change management documentation and compliance in data solutions.Display capability to analyze business requirements and convert them into clear actionable technical designs that balance performance cost and long term maintainability.Utilize familiarity with scheduling tools and monitoring solutions to keep ETL processes stable predictable and aligned with agreed service levels for data availability.Showcase strong problem solving and communication skills that enable effective coordination among data engineers analysts and other technology partners.Certifications Required
No.
