Software Architect
Job Code : 20221110
BangaloreJob Description
- Relevant experience
in SQL, Informatica, Teradata Datawarehouse
- Designing,
coding, testing, tuning and maintenance of Informatica workflows
- Strong
SQL/Data Analysis or Data Mining
experience with Audit Controls, ETL Framework
- Good
Understanding of Datawarehouse concepts- OLTP, OLAP, Dimensions, Facts,
and Data modeling.
- Experience
in analysing & troubleshooting Data Issues in the Teradata environment
- Design
and build data pipelines using Azure Data Factory.
- Design
and build pipelines in continuous integration and deployment using Azure
DevOps.
- Strong
exp in Informatica Power center tool
- Experience
gathering and analysing system requirements.
- Work
directly with Modelers/Architects/DBA on data modeling, logical/physical
schema design, SQL query tuning; and the application of data-related
business rules while assisting in troubleshooting, debugging, and issue
resolution
- Communicate
effectively with end users, peers, and management regarding assignments,
and must have a can-do attitude and a desire to provide solutions
- Delivering
projects with a high-level of data quality and integrity
- Meet
deadlines and possess a proven record of successful project execution and
delivery.
- Demonstrate
knowledge of SDLC processes and procedures adjusted for a Rapid
Application Development methodology (agile)
- Provide
support for the resolution of all reporting issues escalated by the
Support Operations Team post-implementation.
- Working
with global development team to have designs implemented, tested and
present to user groups
- Influencing
decisions with divisional partners, internal teams, senior management, and
external partners.
- Collaborate
with the team to define the information architecture, advocating
interaction design best practices with a focus on consistency and
usability
- Good
knowledge in identifying performance bottlenecks and also in tuning the
Mappings and Sessions
- Expert
knowledge of DB2, SQL Stored Procedures, Triggers, and data querying
optimization
- Extensive
experience working on UNIX platform, Perl scripting and managing Autosys
jobs.
- Excellent
communication, interpersonal, analytical and leadership skills,
self-motivated, quick learner and a team player Ability to work in a team
and individually, independent thinker, focused on meeting deliverables in
a remote environment
- Ability
to effectively interact with, present information to and respond to
questions from all levels of the organization and partners.
- Ability
to communicate complex analysis in a clear, precise and actionable manner
- Comfortable
with ambiguity, creative thinking and leading change
- Good to
have familiarity with data visualization tools (Tableau/Power BI).
- Ability
to effectively function in a cross-team environment.
- Ability
to research and troubleshoot technical problems
Desired
Knowledge, Skills and attitudes:
キ
Extremely
comfortable with working with data and systems
キ
Proficient in understanding business
requirements and translating them to technical teams
キ
Contribute to the efficient design of systems
/ applications as per requirements
キ
Manage and maintain applications to ensure
smooth functioning
キ
Manage change requests and enhancements
キ
Desirable to have exposure to basic data query
languages
キ
Desirable to have knowledge of accounting or
finance
キ
Strong analytical / logical thinking skills
キ
Experience in interacting with a global
development team and global clientele / stakeholders.
キ
Excellent team skills and ability to
collaborate in a matrix organizational structure