Architect I - Enterprise Solutions

9 - 12 Years
1 Opening
Bangalore

UST is looking for a Sr ETL informatic Tech lead /Architect with knowledge/experience in Salesforce This role requires 12+ years of experience with a proven track record in leading teams and managing complex data engineering projects.

As a Sr ETL informatic Tech lead /Architect. ,you are responsible for Designing ETL Processes: They design the ETL process according to business requirements, ensuring efficient data flow from source to destination. This includes selecting the right tools and methodologies for data extraction, transformation, and loading.

Work with dependent team, client stakeholders, business and work on mapping documents & create solutions

Provide guidance in Developing ETL Pipelines: Ensuring Data Quality: They implement measures to ensure data accuracy and integrity throughout the ETL process. This includes data validation, cleansing, deduplication, and error handling to ensure reliable and usable data.

Data Modeling: Participate in data modeling, designing the data structures and schema in the data warehouse to optimize query performance and align with business needs. Performance

Tuning: They are responsible for optimizing ETL processes for speed and efficiency, addressing bottlenecks, and ensuring the ETL system can handle the volume, velocity, and variety of data

Maintenance and Updates: Maintaining the ETL system involves monitoring its performance, updating ETL scripts and workflows as business requirements change, and ensuring the system scales with data growth.

Collaborating with Stakeholders: work closely with business analysts, data scientists, and IT teams to understand data requirements and deliver the data infrastructure that supports business goals.

Providing Technical Support: They offer technical support for ETL systems, troubleshooting issues and ensuring the continuous availability and reliability of data flows Technical Skills & Qualification Bachelors degree in computer science or equivalent: Min 12+ years of experience working as Informatic developer ETL Tools:

Experience with one or more ETL tools like Informatica PowerCenter, Microsoft SSIS (SQL Server Integration Services), Knowledge in Salesforce is mandatory. Databases: A strong understanding of relational databases (such as MySQL, Oracle, and SQL Server) and knowledge of SQL is essential. Experience with NoSQL databases like MongoDB or Cassandra is a plus. Data Warehousing Solutions: Familiarity with data warehousing architectures (such as Kimball and Inmon) and technologies like Amazon Redshift, Google BigQuery, and Snowflake. Programming Languages: Excellent knowledge of scripting and programming languages for data manipulation and transformation.

Big Data Technologies: Knowledge of big data technologies can be beneficial, especially for handling large-scale data processing. Data Analysis: Ability to analyze data sources, understand data relationships, and develop strategies to extract, transform, and load data effectively.

Problem-Solving: Skills in identifying issues within data processes and developing innovative solutions Strong oral and written communication skills are necessary for collaborating with team members and stakeholders, documenting ETL processes, and explaining technical details clearly Precision is crucial in ETL development to ensure the accuracy and integrity of data

Soft Skills: • Demonstrated experience leading technical teams, driving technical decisions, and mentoring junior to senior-level engineers. • Exceptional ability to translate complex business/functional and technical requirements into clearly articulated strategies and implementation plans.

• Excellent problem-solving skills with a strategic mindset and attention to detail. • Superior communication and interpersonal skills, capable of presenting technical concepts effectively to diverse stakeholders.

• Comfortable managing and prioritizing multiple projects simultaneously in a dynamic, fast-paced environment. • Proven ability to deliver high-quality, timely results with strong accountability and ownership.

• Strive to provide technical leadership, mentorship to engineering teams, managing tasks and projects using JIRA, overseeing team management, and ensuring best practices in data engineering and AWS implementations.

informatica,Etl,Mongodb,AWS