Verizon Lead System Consultant in Atlanta, Georgia
What you’ll be doing...
Prepare functional design and technical design documents, as well as test case documents, architecture design, solution design, and code development. Perform unit and system testing, integration and regression testing, and deployment. Perform Database creation, Database Schema creation, User access, roles and privileges management using Oracle, Teradata and MySQL. Work with stored procedures, triggers and function creation on databases for customizing data flows for extraction. Work with data modeling using ERWIN, SQL Data modeler including ER diagrams, logical modeling and physical modeling. Work with Extract Transform and Load process creation using Informatica ETL tools and PL/SQL procedures and functions, and work with ETL Architecture, Development, Administration, Production Support, Upgrade Informatica tools. Work with UNIX/LINUX Shell Scripting, and with Extract Transform and Load data from Siebel CRM, using OBIEE Applications. Conduct post production support and maintenance, data modelling, data warehouse design, analytical and critical thinking, logical reasoning in identifying and solving problems. Direct day to day interaction with business users. Lead and take complete ownership of applications, environments, deliverables, issues and their resolutions. Use agile methodologies for software development and release to production. Analyze data trends and identify problems. Develop extract-transform-load mappings and workflows in Informatica. Develop dimensional data model in Data Warehouse to create operational, statistical and analytical reports using oracle business intelligence and tableau. Work with product and system analysts to identify and understand different source systems such as call center, operations, order management, supply chain, engineering, product, sales and marketing and finance. Define rules for ETL mappings and transformations, and create ad-hoc reports and dashboards for business critical needs. Develop extract-transform-load jobs for Hadoop, and develop streaming applications for real time/near real time analytics. Install and configure Informatica, DAC, Hadoop, Spark, Oracle business intelligence applications in multiple environments. Perform extract-transform-load job monitoring, and integrate data for near real-time reports based on business functions and needs. Perform automation of manual and repetitive application tasks. Develop PL/SQL or SQL jobs for data extraction for ad-hoc reports. Analyze data from multiple sources and derive trends and source of truth. Monitor data trends to identify business problems and proactively report and work towards problem resolution.
What we’re looking for...
Bachelor's or foreign equivalent degree in Computer Engineering followed by 6 years of progressive experience with Database creation, Database Schema creation, User access, roles and privileges management using Oracle, Teradata and MySQL; 6 years of experience with stored procedures, triggers and function creation on databases for customizing data flows for extraction; 6 years of experience with data modeling using ERWIN, SQL Data modeler including ER diagrams, logical modeling and physical modeling; 6 years of experience with Extract Transform and Load process creation using Informatica ETL tools and PL/SQL procedures and functions; 6 years of experience with ETL Architecture, Development, Administration, Production Support, and Upgraded Informatica tools. Experience to include UNIX/LINUX Shell Scripting, Siebel CRM, and using OBIEE applications.
Must Reference: SHAT1-W
When you join Verizon...
You’ll be doing work that matters alongside other talented people, transforming the way people, businesses and things connect with each other. Beyond powering America’s fastest and most reliable network, we’re leading the way in broadband, cloud and security solutions, Internet of Things and innovating in areas such as, video entertainment. Of course, we will offer you great pay and benefits, but we’re about more than that. Verizon is a place where you can craft your own path to greatness. Whether you think in code, words, pictures or numbers, find your future at Verizon.
Equal Employment Opportunity
We're proud to be an equal opportunity employer- and celebrate our employees' differences,including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Different makes us better.