IN
0 suggestions are available, use up and down arrow to navigate them
Senior ETL developer in Bengaluru, Ka...

Create Job Alert

Get similar jobs sent to your email

Apply to this job.

Think you're the perfect candidate?

Senior ETL developer

Diverse Lynx India Pvt. Ltd. Bengaluru, Karnataka (Onsite) Full-Time
 



7911620 - Sr
ETL Developer - C1
C1
Bangalore
Job Description:

Minimum of 4 years' experience of working on DW/ETL projects and expert hands-on working knowledge of ETL tools


Experience with Data Management & data warehouse development

Star schemas, Data Vaults, RDBMS, and ODS

Change Data capture

Slowly changing dimensions

Data governance

Data quality

Partitioning and tuning

Data Stewardship

Survivorship

Fuzzy Matching

Concurrency

Vertical and horizontal scaling

ELT, ETL

Spark, Hadoop, MPP, RDBMS

Experience with Dev/OPS architecture, implementation and operation

Hand's on working knowledge of Unix/Linux

Building Complex SQL Queries
Expert SQL and data analysis skills, ability to debug and fix data issue


Complex ETL program design coding

Experience in Shell Scripting, Batch Scripting


Good communication (oral & written) and inter-personal skills

Expert SQL and data analysis skill, ability to debug and fix data issue Work closely with business teams to understand their business needs and participate in requirements gathering, while creating artifacts and seek business approval


Helping business define new requirements, Participating in End user meetings to derive and define the business requirement, propose cost effective solutions for data analytics and familiarize the team with the customer needs, specifications, design targets & techniques to support task performance and delivery


Propose good design & solutions and adherence to the best Design & Standard practices


Review & Propose industry best tools & technology for ever changing business rules and data set
Conduct Proof of Concepts (POC) with new tools & technologies to derive convincing benchmarks


Prepare the plan, design and document the architecture, High-Level Topology Design, Functional Design, and review the same with customer IT managers and provide detailed knowledge to the development team to familiarize them with customer requirements, specifications, design standards and techniques


Review code developed by other programmers, mentor, guide and monitor their work ensuring adherence to programming and documentation policies


Work with functional business analysts to ensure that application programs are functioning as defined. 

Capture user-feedback/comments on the delivered systems and document it for the client and project manager's review
Review all deliverables before final delivery to client for quality adherence


Technologies (Select based on requirement)

Databases - Oracle, Teradata, Postgres, SQL Server, Big Data, Snowflake, or Redshift

Tools – Talend, Informatica, SSIS, Matillion, Glue, or Azure Data Factory

Utilities for bulk loading and extracting

Languages – SQL, PL-SQL, T-SQL, Python, Java, or Scala

J/ODBC, JSON

Data Virtualization Data services development

Service Delivery - REST, Web Services

Data Virtualization Delivery – Denodo

 

ELT, ETL

Cloud certification Azure

Complex SQL Queries

 

Data Ingestion, Data Modeling (Domain), Consumption(RDMS)



 

Recommended Skills

  • Amazon Redshift
  • Apache Hadoop
  • Apache Spark
  • Architecture
  • Batch Scripting
  • Big Data

Apply to this job.

Think you're the perfect candidate?

Help us improve CareerBuilder by providing feedback about this job:

Job ID: 14518670

CareerBuilder TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.