Careers At Sagility

Software Architect

Job Code : 20221110_1

Job 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


Apply For This Job Back