Sr. Architect
Cognizant
Cognizant
Seeking a seasoned Senior Architect with 12-16 years of experience to lead the design, optimization, and governance of enterprise data platforms. This hybrid role emphasizes creating scalable data integration, performance-tuned analytics, and resilient architectures that drive critical business outcomes while adhering to best practices and compliance standards.
Develop robust enterprise data architectures utilizing SQL and Informatica PowerCenter for reliable, scalable solutions aligned with business objectives. Create end-to-end data integration blueprints, detailing mappings, transformations, and scheduling for analytics and operational needs. Translate complex data requirements from stakeholders into clear architecture components and detailed implementation designs. Guide data engineers in building reusable Informatica PowerCenter ETL components and optimized SQL procedures to enhance throughput and reduce maintenance. Optimize SQL queries, data models, and ETL workflows by analyzing performance metrics and applying advanced strategies like indexing and partitioning. Establish comprehensive data quality frameworks, including validation rules and exception handling, to ensure data trustworthiness. Produce detailed architecture documents, data flow diagrams, and integration patterns for implementation guidance and platform evolution. Collaborate with infrastructure and database teams on capacity planning, backup, and high availability strategies. Review solution designs and code deliverables to ensure alignment with reference architectures and standards. Drive adoption of metadata management practices for lineage tracking and impact analysis. Mentor team members on best practices in SQL tuning, ETL design, and modular architecture. Align architectural decisions with organizational data strategy, advocating for scalable platforms and cloud readiness. Assess new data technologies and tools to propose incremental enhancements for reliability and performance.
A strong educational foundation in computer science, information technology, or a related field is expected, complemented by extensive experience with enterprise data systems. Possess 12-16 years of progressive experience in data architecture or senior ETL design, with a proven track record in large-scale integration initiatives. Demonstrate deep proficiency in SQL, including complex joins, window functions, query tuning, and designing normalized and dimensional data models for analytics. Exhibit advanced hands-on experience with Informatica PowerCenter, covering mapping design, workflow orchestration, parameterization, and reusable transformations. Show proven experience designing and implementing data integration solutions in hybrid environments, working effectively with distributed teams. Possess strong knowledge of data warehousing concepts such as star schemas, slowly changing dimensions, and fact table design. Familiarity with scheduling tools, version control, and deployment processes for reliable data pipeline promotion is essential. Highlight practical understanding of data governance, security, and privacy practices, including role-based access management. Emphasize excellent communication and documentation skills for clear articulation of architectural decisions to both technical and non-technical audiences. Preference for exposure to cloud data platforms and modern analytics ecosystems where integration patterns and SQL skills were applied to deliver measurable business outcomes.
Cognizant
IT Consulting