ETL Consultant

  • Downey, CA
  • Applications have closed

Required Skills:

The Senior Programmer will possess knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software; operating systems installation and configuration procedures; organization’s operational environment; software design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components; pertinent government regulations; infrastructure requirements, such as bandwidth and server sizing; database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing; functionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability; optimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the work; and speak and write effectively and prepare effective reports.

Skills Preferred:

The skills preferred is the knowledge and experience in Wireline Process with the ability to download invoices from various vendors’ FTP and portals (i.e., ACUS, Frontier). The skills to process and load invoices to the database, and to complete adjustments and charge items to the database, upload ETL to EMS. The ability to archive billing cycles and run active reports for Auth Code. Also understand and have the skills to download wireless data from Verizon, AT&T and T-Mobile portals for various departments and am able to upload that data to a database. Understand how to open automated service tickets for each task to track progresses, and the ability to close tickets as they are completed. To be responsible for Agile development with the ability to be the scrum master, by collaborating with cross-functional teams to raise productivity. Has the skills to led a team through the creation of projects and to lead new Agile project management and Agile development. Be able to lead sprint planning, daily scrum, sprint review, and sprint retrospectives, and the skills to manage agile project team activities. Understands functionality of MS DevOps and/or Jira Kanban boards, agile developer, and agile project management (scrum master) experience. Has the skills to conduct complex business problems analysis to reduce corporate and financial risk as part of the client’s strategy. Be able to apply regulatory standards and policies in procedural data analysis, and the ability to develop custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights. Knows how to use the following tools MS SQL Server T-SQL, Power BI, C#, HTML, JavaScript, CSS, REST API, ASP.NET Core, and Blazor. Development experience in Azure Cloud a plus and has work with ETL (Extract Transform Load) required and SQL development.

Must have a minimum of seven (7) years of experience in electronic data processing systems study, design, and programming. At least four (4) years of that experience must have been in a lead capacity.

Requires the possession of a bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Experience Preferred:

Development experience in ETL (Extract Transform Load) with a minimum of two (2) years of experience.