Consultant, Data Analyst
Core
Perform intensive data analysis to inspect, cleanse, transform, and model data; resolve data completeness and quality issues; analyze ETL components and create mapping rules.
Role type
Data Designer / Data Analyst
Builds
Data warehousing models, ETL mapping rules, data quality reports
Domain
Insurance / Data Engineering
Required skills
SQL, ETL design, Data modeling, Data profiling, XML/API testing, Automation scripting
Preferred skills
Informatica PowerCenter, IBM Infosphere DataStage, Teradata, 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 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 and test XML/API/OOS/web services calls.
Seniority
Mid-Senior level (5+ years experience)