Job Description

Role Name: Data Warehouse Developer Capital Markets Data Factory
Desired Experience Range: 5 years to 8 Years
Location of Requirement: Hyderabad
Tech Profile/Essential Skills:
. Minimum of 3 years design, performance tuning, development and experience with data warehouse and ETL technology (Oracle, SQL Server, Snowflake etc.).
. Oracle SQL, PL/SQL - min 3 years experience.
. ETL Tool (any tool) min 2 years experience.
. Data Warehouse (concepts, implementation) min 2 years experience.
. Strong analytical and problem-solving skills.
. Exposure to the whole development life cycle: design, development, testing.
. Strong written and verbal communication skills with other team members, QA teams and internal business stakeholders.
Desirable skills:
. Experience of cloud database and ETL technologies such as Snowflake or Matillion.
. Experience with agile development methodologies including Kanban and Scrum and full SDLC experience.
. Experience with source control management systems, continuous integration/deployment environments, and release management.
Detailed Responsibilities:
. Development and maintenance of the data warehouse and related data transformation.
. Work with Business Analysts, Java Developers, End Users, DevOps, BI developers and QA teams when appropriate.
. Deliver technical documents such as Technical Designs, Specifications, Users Guides.
. Design, Development and maintenance of Data Warehouse storage and transformation using Snowflake and Matillion.
. Take shared responsibility for all database support, development and administrative work to:
. Provide Data warehouse functionalities (Snowflake).
. Use ETL (Matillion).
. Develop and maintain SQL code on Snowflake.
. Develop and maintain good coding standards.
. Develop and extend database functionality to support current and future business needs.
. Maintain and manage data feeds and work with business users to improve data flow into and out of the Data Warehouse
. Create improvements in existing code and systems to improve efficiencies.
. Provide daily support to business functions.
. Participate in peer-reviews of so lution designs and related code.