Job Title: Technical Analyst- ETL Dev
Experience : 3 to 8 Yrs
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.
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
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
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.