Lead engineer in Saint Louis, MO

View All Technical Services jobs


Technical Services   •  

8 - 10 years

Posted 7 weeks ago

8 Years of experience in Informatica products ( Power centre & Big data Management) Development and database(Min 4 years of experience in Teradata). Good Knowledge on DWH concepts Minimum 3 years of experience in AWS (EC2,EMR, Red Shift, S3, API Gateway, Kinesis, Data pipelineGlue, Lambda, Docker). Hands on experience developing enterprise solutions on designing and building frameworks, enterprise patterns, database design and development Hands on experience in a. End to end Cloud solution (AWS) b. Batch solution c. Functional solution Ability to gather requirements and convert business requirements to technical requirements. Prepare technical specifications documents. Experience of developing ETL application using Informatica PowerCenter (development experience, not just support experience). Involved in creating the mappings in order to extract the data from source to target using Informatica designer. Evaluate all functional requirements and map documents and perform troubleshoot on all development processes Documents all technical specifications and associate project deliverables. Design all test cases to provide support to all systems and perform unit tests. Should analysis the data and develop understand the ETL specifications. Develop mappings if required Develop Informatica 9x & 10x mapping, session and workflow. Involved in creating the sessions, commandtasks, workflows using the workflow designer. Good at working with transformations including complex transformations. Working knowledge on Hive and Hadoop Concepts. Working knowledge on sparkblaze environment in Informatica BDM 10.2 Understanding on tuning BDM mappings for performance improvement. Involved in building autosys to schedule the ETL Workflows. Familiar with Stored Procedures and implementing them in the ETL jobs of Informatica. Worked on the HLD and LLD document. Very good at UNIX and LINUX shell scripting Strong Database Experience with strong knowledge of writing complex SQL queries and Stored procedures. Strong Experience in Teradata utilities. Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks. Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills. Team player, Motivated, able to grasp things quickly with analytical and problem solving skills. Comprehensive technical, oral, written and communicational skillsShould have Strong Analytical and interpersonal skills with good written and verbal communication.