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
