ETL Developer

Role: ETL Developer 

Experience: 10+ years 

Location: Kochi

Skills:

• Should have hands on into SQL programming. Should be able to write SQL, performance turning, stored procedures, triggers, functions.
• Should have experience in SQL Server database.
• Should be able to do database design, dimensional modelling.
• Should have experience in the ETL tools SSIS and Azure data factory. Must have experience in SSIS. Nice to have Azure data factory.
• Should be able to do ETL job design, establish audit flow, data flow.
• Should have good knowledge in Datawarehouse concepts like star schema, DataMart, ETL and reporting concepts.
• Nice to have hands on experience in the Reporting tools like SSRS, Power BI.
• Should be able to lead a team of 3 to 5 members. Should have experience in leading ETL, database and reporting team.
• Should work with management, business analyst, solution architect and clients. Should drive the team towards deliverables.
• Strong analytical and debugging skills.

• Determines data storage needs.
• Uses different data warehousing concepts to build a data warehouse for internal departments of the organization.
• Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data.
• Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Designs develop, automates, and support complex applications to extract, transform, and load data.
• Ensures data quality.
• Develops logical and physical data flow models for ETL applications.
• Translates data access, transformation, and movement requirements into functional requirements and mapping designs.