Data Architect

Country/Region: IN
- Requisition ID: 22219
- Work Model:

- Position Type:

- Salary Range:

- Location: INDIA - BENGALURU - WHITEFIELD SITE

**Title**:Data Architect (IICS, Snowflake, SQL)**:

- Description:

**Area(s) of responsibility**:
Title: Data Architect (IICS, SQL, Snowflake)

Location: Bengaluru

Educational Background: Any Graduation

Key Responsibilities:
**Responsibilities**:
Develop and implement complex ETL processes utilizing Informatica Intelligent Cloud Services (IICS) to efficiently extract, transform, and load data across multiple sources and destinations.
Demonstrated expertise in data warehousing concepts, techniques, and best practices to design and maintain scalable, high-performing data models and schemas.
Collaborate with cross-functional teams to gather project requirements, develop ETL specifications, and ensure the successful execution of data integration strategies.
Ensure real-time data synchronization to optimize system performance and enhance data-driven decision-making processes. Ability to work with various data warehouses is key (Snowflake, MSSQL, MySQL, BigQuery)
Perform ongoing platform administration tasks, including user management, data security, performance tuning, and system upgrades, to ensure optimal performance and data reliability.
Implement data quality and validation procedures, including data pipeline error monitoring and issue resolution, to maintain the integrity of critical data assets.
Continuously explore and adapt to new technologies and methodologies in the data engineering space, fostering a culture of innovation and continuous improvement within the team.
Troubleshoot and resolve integration issues and incidents within the Informatica platform while maintaining the highest level of data quality and integrity.
Adopt a proactive approach in maintaining and optimizing existing ETL processes, identifying areas for improvement, and aligning them with the organization's strategic goals.
Aid senior staff when conducting complex data analysis to resolve management inquiries.
Stay up to date with industry trends and best practices to ensure technical expertise and drive innovation within the team.
Design and participate in a comprehensive and logical test plan for systems using appropriate tools to ensure established standards are utilized.
Escalate to supervisor any situation outside the employee's control that could adversely impact the services being provided
Participation in code reviews and contribute to establishing best practices in data engineering along with maintaining documentation, ensuring accuracy and consistency across the organization.

**Essential job tasks**:
**Minimum Qualifications**:

- Strong knowledge of Informatica PowerCenter, IDQ, and IICS.
- 3-4 years’ experience in SQL query writing, building data warehousing models, data marts, stored procedures & views for front-end reporting.
- Bachelor’s degree in computer science, Engineering, or related field (master’s degree preferred).

**Preferred Qualifications**
- Basic knowledge of Snowflake DB is good to have.
- Proven experience in resolving data integration issues, ETL performance tuning, troubleshooting, and optimization.
- Knowledge of Salesforce, ServiceNow or ConnectWise data, and real-time data synchronization is good to have.
- Experience in working with Tableau/PowerBI & Snowflake, BiqQuery tools is a plus.
- Strong leadership, communication, and problem-solving skills.
- Ability to work independently and as part of a team, managing multiple projects simultaneously.