US Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 24th Aug 2022
• Designed and implemented SQL based tools, stored procedures and functions for daily data volume and aggregation status
• Developed ETL procedures to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures.
• Designed programs for data extraction and loading into Oracle database.
• Created and managed database objects including tables, indexes and procedures.
• Developed and tested programs using SQL, PL-SQL and SQL Loader for database applications. • Developed and generated standard and ad hoc reporting capabilities from new and existing data sources.
• Developed and modified queries, programs, and stored procedures to support standard and ad hoc reporting.
• Transformed business requirements into technical specifications, source-to-target mappings.
• Analyzed data source to design simple and efficient query transforms Loaded data from flat files Designed work flows and data flows Cleaned data in.
• Integrated the data from multiple data sources into a single, consistent data store that is loaded into a server.
• Created a trove of historical data that helps to retrieve and analyze to provide useful insight into the organization's operations.