Job Description :
7+ years of experience in System Analysis, Design, Development, and implementation
Should have good experience in data mapping of file layouts between Upstream and Downstream applications
Experience in Unit Testing, System Testing and User Acceptance Testing
Familiar with Data warehousing tools and used ETL tools
Experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views
Experience in full life-cycle database including data architecture, logical and physical design, data modeling, and implementation
Experience in design of Data Warehouse/Data Mart, Star Schema,
Snowflake, Erwin & Slow changing dimensions
Excellent verbal and written communication skills Essential Duties & Responsibilities
1. Gathering Requirements, create data mapping document and technical specification document
2. Identify Use cases from requirements and write Use Case Specifications
3. Create Mapping documents, ETL technical specifications and various documents related to data migration.
4. Write complex SQL Queries to test the Datastage ETL process
5. Ensuring project delivery on committed date
6. Reviewing designs with the rest of the project team as appropriate
7. Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement