Data Architect

Job Description: Data Engineer / Data Architect

Location: Bangalore, Karnataka
Experience: 7+ Years
Primary Skills: Informatica, Snowflake, Oracle SQL/PLSQL, PySpark, Data Analysis
Job Type: Full-Time

Job Summary

We are seeking an experienced Data Engineer / Data Architect with strong expertise in Informatica, Snowflake, Oracle, PySpark, and Data Analysis. The ideal candidate will be responsible for designing and implementing scalable data solutions, developing efficient ETL/ELT pipelines, and supporting enterprise data warehousing, analytics, and reporting initiatives.

Key Responsibilities

• Design and implement enterprise data architecture, data models, and data integration solutions.
• Develop, maintain, and optimize ETL/ELT pipelines using Informatica.
• Build and optimize data processing pipelines using Snowflake and PySpark.
• Develop complex SQL queries, stored procedures, and data integrations using Oracle SQL/PLSQL.
• Perform data analysis, data profiling, data validation, and troubleshooting.
• Optimize Snowflake queries, data transformations, and pipeline performance.
• Ensure data quality, consistency, integrity, and reliability across enterprise data systems.
• Collaborate with business analysts, data architects, and technical teams to translate business requirements into scalable data solutions.
• Support enterprise reporting, business intelligence, and analytics initiatives.
• Prepare technical documentation and follow data governance and development best practices.

Required Skills and Qualifications

• 7+ years of experience in Data Engineering, Data Architecture, or a related field.
• Strong hands-on experience with Informatica for ETL/ELT development and data integration.
• Extensive experience with Snowflake, including data loading, transformations, query optimization, and data warehousing.
• Strong knowledge of Oracle SQL and PL/SQL, including complex queries and stored procedures.
• Hands-on experience with PySpark for large-scale data processing and transformation.
• Solid understanding of data modeling, dimensional modeling, data warehousing, and database design.
• Experience in data analysis, data profiling, data validation, and issue resolution.
• Strong analytical, problem-solving, and communication skills.
• Ability to work with business stakeholders and technical teams in an enterprise environment.

Good to Have

• Experience with cloud platforms such as Microsoft Azure or AWS.
• Exposure to Power BI, Tableau, or other business intelligence tools.
• Knowledge of data governance, metadata management, and data quality frameworks.
• Informatica or Snowflake certifications.
• Experience working with large-scale enterprise data platforms and cloud data warehouses.

Location

Bangalore, Karnataka, India

Recruitment Keywords: Data Engineer, Data Architect, Informatica, Snowflake, Oracle SQL, Oracle PL/SQL, PySpark, ETL, ELT, Data Modeling, Data Warehousing, Data Analysis, Azure, AWS.

Thanks & Regards,

Shilpi Kumari

Recruiting Analyst

India Recruitment

Lecan Solutions PVT LTD

shilpi.kumari@lecansolutions.com