Senior ETL Developer

Who are we looking for?

A Scrum Master to manage a critical project for one of our biggest clients in Real estate domain. The Individual should be passionate about technology, experienced in developing and managing cutting edge technology applications.

Technical Skills :

Experience of 10+ years in data preparation, data gateway, data migration, data warehousing and cloud migration projects.

Experience of 10+ years and familiarity with any of the ETL Tools like Informatica, Talend and SSIS

Experience in using Snaplogic, Snowflake ETL and Data integration tool

Should be Experience in Python, Glue and postgres.

Good understanding of cloud and its components like AWS Glue, Azure Data Factory etc.,

Excellent troubleshooting and debugging skills on SQL Server Stored Procedures

Ability to interpret python scripts and convert business logic into ETL packages.

Understand different Feeds, Feed files Normalize, stage and integrate with existing data pipelines that connects to AWS Data Lake

Apply best practices in ETL package designing, coding and execution

Assist with defining, implementing, and continuously improving Data Governance processes and procedures.

Facilitate knowledge sharing within the team. Participate in a collaborative structure to capture process improvement ideas and communicate to other groups.

Excellent ETL development experience with an experience how to write highly performing, scalable ETL packages

Extensive experience in designing, implementing and documenting Conceptual, Logical and Physical data models

Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys

Develop, adhere to, and be a proponent for Data Warehouse development standards, including ETL standards, methodologies, and best practices

Experienced on performance tuning and Query optimization

Responsibilities :

Experienced on performance tuning and Query optimization

Connecting to data sources, importing data and transforming data for Business Intelligence.

Expertise in using advance level calculations on the data set.

Responsible for design methodology and project documentation.

Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.

Should have knowledge and experience in prototyping, designing, and requirement analysis.

As part of the responsibilities, participate in design sessions, develop design documents, and participate in acceptance testing and knowledge transfer activities.

Ability to plan, execute projects to deliver in time and with quality

Highly motivated Individual to learn and to mentor project member

Effectively communicate and present ideas and / or project status.

Process Skills :

Strong analytical problem-solving skills

Thorough understanding of Performance Tuning including query / application performance tuning

Customer-focused attitude and desire to interface directly with end-user clients.

Excellent verbal and written communication skills.

Should be able to lead the ETL team with design & development .

Should be able to manage the project execution (Planning to delivery).

Behavioral Skills :

Proficient communication skills.

Excellent analytic approach and problem-solving technique.

Flexible & adjustable attitude.

Train and coach members of project groups to ensure effective knowledge management activity.

Skills PRIMARY COMPETENCY : Analytics PRIMARY SKILL : BI / DW / ETL PRIMARY SKILL PERCENTAGE : 100