Tech Analyst ETL
$8-15 USD / hour
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.
Project ID: #33769504
About the project
8 freelancers are bidding on average $13/hour for this job
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.
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 More
Working as ETL Architect and Developer in one of the reputed company. Can solve and work on any Datawarehousing related projects
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 More