Tech Analyst ETL

Job Title: Technical Analyst- ETL Dev

Experience : 3 to 8 Yrs

Relevant Experience:

Tech Analyst ETL - Overall experience of 3 to 5 Yrs and 3+ Yrs into Informatica Power Center and experience into IICS will be plus.

[login to view URL] Analyst ETL - Overall experience of 7+ Yrs and 4+ Yrs into Informatica Power Center and 1+ Years of experience into IICS

Notice Period: Immediate or Max 15 days

Job Location: Bangalore

Shift Time: 1 PM to 10 PM

Experience and Mandatory Skills:

ETL development using Informatica Power Center.

3+ years of experience in developing SQL code in Snowflake/Oracle/MS SQL.

Good knowledge about Business Intelligence, Data warehousing concepts and methodologies and Reporting tools

Experience designing complex ETLs extracting data through RDBMS, Flat file, XML files, Json sources

Should be able to analyse poorly performing queries/ETL mappings and provide suggestions to tune them.

Essential Duties and Responsibilities:

Ability to gather and develop ETL pipelines in and out of data warehouse objects (type-2 dimensions, aggregations, star schema, etc.) using combination of Powercenter/IICS and Snowflake

Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.5 and higher

Ability to write SQL queries against Snowflake/Oracle/MS SQL.

Ability to develop scripts (Java, Python etc.) to do Extract, Load and Transform data

Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.

Ability to understand data transformation and translation requirements and which tools to leverage to get the job done

Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on-premises technologies

Providing technical support and troubleshooting issues as needed.

Performs other duties and responsibilities as assigned.

Additional Preferences or certifications

Experience with cloud technologies

Able to work on own initiative and as a team player

Experience with CI/CD pipeline tools like Jenkins

Experience working with MS Office tools.

Soft skills required

Good communication skills, client facing experience, strong analytical and problem-solving skills.

Habilidades: Oracle, SQL, Armazenamento de Dados, Informatica Powercenter ETL, ETL

Sobre o Cliente:
( 0 comentários ) Hyderabad, India

ID do Projeto: #33769504

8 freelancers estão ofertando em média $13/hora nesse trabalho


Hi, I'm interested in this project, I have good experience in ETL(Infromatica, Azure Data factory) and good SQL knowledge. I do alsoe knowledge in some of python models(Numpy, pandas etc...) Thanks, Aravind

$12 USD / hora
(0 Comentários)

Hello, I am glad to let you know that wee have work experience with Power BI for more than 8 years and we are partner of Microsoft Corporation in Power BI ( [login to view URL]) I Mais

$12 USD / hora
(0 Comentários)

Hi , I have around 10 year of experience on the informatica development and support. I lead team of 7 members with same set of skills. I handle the new projects and even do PROD support activities. Thanks, Rakesh CR

$14 USD / hora
(0 Comentários)

Hello, My name is Divyesh and I am an expert Django and React.Js with ML skills based full-stack development with 5+ long years of experience. I have worked on some social networking projects previously as well (check: Mais

$12 USD / hora
(0 Comentários)

I have abundant experience in Informatica Power center, SQL and unix servers. I've worked on complex transformations and also done performance tuning. Have handson experience on IICS too.

$12 USD / hora
(0 Comentários)

With over six years of background in Data Engineering, I am involved in ETL development for different projects. I find this field very interesting since it is responsible for making raw data beneficial to the enterpris Mais

$12 USD / hora
(0 Comentários)

Working as ETL Architect and Developer in one of the reputed company. Can solve and work on any Datawarehousing related projects

$12 USD / hora
(0 Comentários)

Summary of qualifications: - 8+ years providing IT solutions for Multinational Companies in several sectors of the industry like banking, insurance, telecommunications, retail, investment and education. - 8+ years of e Mais

$15 USD / hora
(0 Comentários)