Responsible for understanding the Business process and gather the requirements for MDM and quality stage integration; design, develop and deploy Datastage jobs using various Quality stages like Investigate, Standardization, Match Frequency, Unduplicate and Reference Match and Survivor Stages; generate the Pattern report and Token report for Business to identify the Data patterns and inconsistency in source data; validate the reports generated by Investigate stage; standardizing the source data and generated the valid and invalid data reports; design of Match Templates suggestions from the Business and validate the results to identify the duplicates coming from the source depending on different Match types; design and develop Data stage Jobs to extract data from heterogeneous sources; create new Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator and Row Generator; work on CI/CD to improve timeline for Built and Deployment of Application; design and develop client applications, including the CMMS; conduct timely code reviews; develop Business Objects code and test Business Objects components against data warehouses and operational data stores; analyze and design Business Objects components based on the data sources, data definitions, data relationships, and business rules; complete assigned tasks using SAP Business Objects, Crystal Reports, ETL, SAS Enterprise Miner, SAS Data Management, SQL, UML diagrams, UML models, SDLC, Business Intelligence and Java: Object oriented programming; work closely with project management, analysts, data modelers and developers to understand project requirements and contribute to the project solution; provide technical expertise on Design, Performance Tuning, Data modeling, Data Warehousing, and Data integration for applications; analyze Data Warehouses and Business Intelligence to design, test, and troubleshoot software; and build SQL Queries and perform data analysis. Location: Southfield, MI and multiple undetermined worksites throughout the U.S. Salary: $78,125 per year |
