Responsibilities/Tasks

• Develop ETL programs using any ETL tool to implement the business requirements.
• Repoint data objects in workflow scripts map to MS SQL Server (repost SQL)
• Move the pre/post ETL process to Stored procedures
• Create data mappings that involved implementation of Business Logic to load data from source to target repository
• Communicate with business customers to discuss the issues and requirements.
• Technical expertise regarding data models, data flow diagrams and database design development
• Drive test planning, test designing and execution, performance, and stress testing, implementing, and maintaining quality test automation of both client and server systems.

Experience/Exposure

• 6+ Years of experience in any ETL tools (Informatica / Data Stage etc)
• Strong experience in Buiding data pipelines to store,prepare and process data
• Strong experience in building data quality processes
• Very good data modeling skills
• Prepare data for prescriptive and predictive modeling
• Good Experience in Data acquisition and retention strategies

Please be aware we are not necessarily expecting each candidate to cover all the above listed technologies.

Education/Certification

• Bachelor’s degree