Senior Consultant – SQL, Informatica & Data Visualization

Job Responsibilities

Design, develop, and maintain ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple sources.

Ensure data quality, integrity, and performance through validation and optimization techniques.

Develop and enhance data visualization dashboards using tools such as Looker

Participate or drive data reconciliation activities

Work with delivery teams to ensure the successful implementation and transition of solutions.

Full BI software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations support

Translate customer requirements into Analytics software design, development, plan, and implementation. Propose system design/enhancements based on customer problems and product requirements. Communicate with users, other technical teams, and management to collect requirements, describe software product features, and technical designs.

Ensure system changes are tested properly.

Recommend and help customers understand how Model N can be best changed, designed and/or configured technically to meet a customer's business requirement.

This is an individual contributor role, with hands-on technical delivery.

Job Qualification

Bachelor’s degree in computer science or related discipline

5+ years’ experience in Analytics software development & delivery of enterprise Analytics s oftware implementations using Informatica, with at least 3 years of experience in an analytics developer role.

Proven capability to interpret complex business requirements—both functional and technical—and convert them into well-structured data models and meaningful visualization designs

Advanced knowledge in Data Warehouse concepts .

Advanced knowledge in Data Analytics and Data Visualization concepts.

Hands-on experience with relational databases, particularly Oracle, including advanced SQL and PL/SQL programming

Proficiency in developing Informatica mappings, sessions, and workflows, with experience in monitoring ETL processes and resolving errors/failures

Experience with analytics tools such as Looker is highly desirable, including LookML development

Proven ability in performance tuning: optimizing SQL queries, Informatica workflows, and analytical solutions

Strong analytical and problem-solving skills

Ability to work independently and collaboratively within a team to deliver project milestones on schedule

Excellent communication and stakeholder management skills.