Publicerade inlägg i: Telekommunikation i Chicago | Posted: |
Job Description
Key Responsibilities
Design & develop data warehouse applications & ETL jobs utilizing databases such as Oracle, SQL Server, No SQL, Postgres, Teradata, etc.
Responsible for understanding end-to end operational data warehouses, including system integrations, data quality & harmonization rules, understanding of downstream information.
Design data model for data marts & warehouses using TOAD, Erwin data modeler & SQL Developer tools.
Utilize advanced analytical SQL functions and performance tuning SQL queries.
Develop Unix shell scripts, Python & Java scripts for file/data processing activities.
Responsible for reporting & visualizing data using business intelligence tools such as QlikView, Cognos, Spotfire, etc., & using statistics coding tools (e.g. SAS, R, etc.).
Employ experience in developing & building enterprise data warehouse by ETL jobs using PL/SQL, Informatica.
Employ software development experience following Agile models & utilizing tools such as Oracle SQL, PL/SQL, Unix Shell Scripting, XML, & JSON.
Employ experience using version control systems such as GitHub, AWS CodeCommit, & Microsoft Team Foundation Server.
Act as a dedicated team player & interface with stakeholders from variety of internal IT disciplines (i.e. DBAs, architects, data scientists, infrastructure teams, etc.).
Responsible for maintaining cloud knowledge & exposure in AWS, Azure & GCP.