Senior Consultant - SQL, Informatica & Data Visualization
Model N
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 software 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.