Consultant, Data Analyst
Core
Perform intensive data analysis to inspect, cleanse, transform, and model data; resolve data quality issues; analyze ETL components; create ETL mapping rules; and automate frontend tools.
Role type
Data Designer / Data Analyst
Builds
Data warehousing models, ETL mapping rules, and automated frontend tools
Domain
Data Engineering / Data Warehousing
Required skills
SQL, ETL design, data modeling, data profiling, XML/API/OOS/web services testing, automation scripting
Preferred skills
Informatica PowerCenter, IBM Infosphere DataStage, Teradata SQL Assistant, UFT/QTP, Selenium, SOAP UI, IBM Rational Tester
Technologies
Informatica PowerCenter, IBM Infosphere DataStage, Teradata, UFT/QTP, Selenium, SOAP UI, IBM Rational Tester
Responsibilities
Inspect, cleanse, transform, and model data to resolve completeness and quality issues; Analyze ETL components to determine existing mapping logics; Create ETL Data Mapping rules visual documents; Create complex SQL queries to profile data and check mapping accuracy; Automate frontend tools using UFT/Selenium and test web services calls.
Seniority
Mid-Senior level (5+ years experience)
