Description:

 An ETL developer who is excited to tackle the challenges that come with large volumes of data and complex business rules. You'll help us build a hybrid platform that combines traditional warehouse technologies, MPP databases and Hadoop. 

Responsibilities:

• Implement complex business rules and Analyze and build scalable, efficient processes using industry standard ETL tools like INFORMATICA Power Center by developing the ETL code with the extraction of data from relational SQL Server tables and flat files. 
• Work with data architect to figure out the business logic that needs to be implemented in the warehouse day to day load. 
• Prepare Business Required Documents (BRD) to outline data flow from source to target and Document Data Warehouse table details, ETL code details and status documents for each subject area. 
• Analyze the existing SQL code and queries to comprehend the past data with the team; Develop stored procedures using SQL server database to support ETL jobs with optimized performance. 
• Perform design reviews and recommend suggestions to the ETL design; Perform code reviews and optimize the SQL queries and ETL code through performance tuning to improve data extraction, process and load time. 
• Coordinate with testing team to make testing team understand Business and transformation rules being used throughout ETL process. 
• Support the EIM team for successful delivery of client’s business requirements through all the phases of the implementation. 
• Develop Control-M jobs and Schedule them. 

Requirements:

• Bachelor’s degree in Computer Science / Applications, Engineering or related field.
• Sql Experience 
• Good Knowledge in Database design and Maintainence.
• Ability to work in a diverse fast paced environment and effectively collaborate across teams
• Excellent Communication Skills